Importing data from excel, large amount of NA

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

lallaar
Posts: 1
Joined: Thu Sep 09, 2010 7:09 am

Importing data from excel, large amount of NA

Postby lallaar » Thu Sep 09, 2010 7:33 am

Hi,

I am trying to import data from excel and I get up to 16382 values and then get NA for the rest (total amount of values are 32018). I was wondering if anyone could help. I am setting up the workfile as unstructured and then attempting to import all the data in. This is the same for all variables.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12601
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing data from excel, large amount of NA

Postby EViews Gareth » Thu Sep 09, 2010 7:58 am

Could you provide details on exactly what you are doing, and if possible provide the workfile and the Excel file?
Follow us on Twitter @IHSEViews

patrix
Posts: 10
Joined: Thu Sep 09, 2010 11:00 am

Re: Importing data from excel, large amount of NA

Postby patrix » Thu Sep 09, 2010 11:21 am

I have the same problem.
I know the cause, but I don't know how to solve this issue.
I want to import a series of daily exchange rates and I have chosen the 5-day week frequency. The problem is that there were some holidays (even 3-4 days) when there was no exchange rates reported. So, even if I declare the start and end date of the series, the last 40-50 cells are filled with NA.
Is there any solution to solve this issue?
Thank you!

EViews Glenn
EViews Developer
Posts: 2645
Joined: Wed Oct 15, 2008 9:17 am

Re: Importing data from excel, large amount of NA

Postby EViews Glenn » Thu Sep 09, 2010 2:04 pm

You probably should choose an irregular frequency rather than trying to shoehorn into a 5-day. The holiday setting is exactly the kind of data for which the irregular was designed.

patrix
Posts: 10
Joined: Thu Sep 09, 2010 11:00 am

Re: Importing data from excel, large amount of NA

Postby patrix » Sat Sep 11, 2010 1:48 am

Hello! Thank you again for your answer. Now there is another problem. Well, I need to calculate variances for every quarter and, as I see, there no way to do this when using undated series.

EViews Glenn
EViews Developer
Posts: 2645
Joined: Wed Oct 15, 2008 9:17 am

Re: Importing data from excel, large amount of NA

Postby EViews Glenn » Mon Sep 13, 2010 12:28 pm

To be clear about what I mean by irregular earlier...you should create an irregular dated (Dated - specified by date series). Given this structure there should be a variety of ways to compute what you want.

patrix
Posts: 10
Joined: Thu Sep 09, 2010 11:00 am

Re: Importing data from excel, large amount of NA

Postby patrix » Mon Sep 13, 2010 2:02 pm

Ok, so I imported data from Excel. I had the following objects, beside the C and resid: date series and exchange rate series (non dated/irregular). Then, in the main menu I choosed Proc - Structure/Resize current page, then:
- work file structure type: Dated - specified by date series;
- date series: name of the object that contains the date series (i.e., dateser)
OK

And I solved the problem. Thank you again, and I hope that this small guide will help others.

ran_v3000
Posts: 2
Joined: Sun Sep 19, 2010 9:50 am

Re: Importing data from excel, large amount of NA

Postby ran_v3000 » Tue Sep 21, 2010 3:25 am

it is my first time that using eviews i have data of 22443 person and 15 variables that are related to these person for 3 years(1380,1381,1382).but i dont know how to insert these data in to eviews.
these data are now in excel and look like this:

person/ age.80 /age.81/ age.82 /li.1380/ li.1381 /li.1382 ....
1 / 20 / 21 / 22 / 1000 / 1140 /1200
2 / 34 / 35 / 36 / 2347 / 2432 / 3211
.
.
.

i had use import or open foreign data as work file but the result does not look like panel data .please help me i don't know how to work with eviews.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12601
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing data from excel, large amount of NA

Postby EViews Gareth » Tue Sep 21, 2010 8:09 am

Follow us on Twitter @IHSEViews

camellia912
Posts: 1
Joined: Fri Jan 07, 2011 7:42 am

Re: Importing data from excel, large amount of NA

Postby camellia912 » Fri Jan 07, 2011 8:05 am

Thanks Patrix for your tip because I had the same trouble with you. However, when I imported date variable from Excel, it became number format in Eviews, not date format as shown in Excel. Pls show me solution in this case. Tks alot.

patrix
Posts: 10
Joined: Thu Sep 09, 2010 11:00 am

Re: Importing data from excel, large amount of NA

Postby patrix » Thu Feb 10, 2011 2:45 pm

In the data import wizard, you can can choose the type of data. Instead of General formating chose Date for the first column (be aware of the type of formating: YMD or DMY).

martingale
Posts: 51
Joined: Tue Jul 24, 2012 11:36 am

Re: Importing data from excel, large amount of NA

Postby martingale » Mon Aug 06, 2012 1:22 pm

Hei

My EViews version i 7.

Problem:
Eviews doesn't read dates from Excel as dates (271921 cells).

What I tried:
i) make an Excel file with just the date column and an Excel file with the rest of data, then choose new work file
ii) choose unstructured/undated date
iii) write in the first date which is 12/29/2006
iv) import from Excel file which has no date
v) get the message that 99 observations (i.e. all in the sample) will be discarded unless 99 observations are resized, choose OK
vi) import from Excel file which has the dates
vii) choose Proc - Structure/Resize current page, then:
- work file structure type: Dated - specified by date series;
- date series: name of the object that contains the date series
viii) then I get the message "illegal panel structure dateid is nested within the previous dimensions of the panel structure"

What is wrong?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12601
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing data from excel, large amount of NA

Postby EViews Gareth » Mon Aug 06, 2012 1:24 pm

Not sure I follow what you're asking. What are you trying to do?
Follow us on Twitter @IHSEViews

martingale
Posts: 51
Joined: Tue Jul 24, 2012 11:36 am

Re: Importing data from excel, large amount of NA

Postby martingale » Mon Aug 06, 2012 1:41 pm

import dates from excel to eviews

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12601
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing data from excel, large amount of NA

Postby EViews Gareth » Mon Aug 06, 2012 1:50 pm

Need a little more information than that.

You have two Excel files. One only has dates. The other appears to have cross-section data in it. The fact that both files have the same number of observations makes me think that, perhaps, the two are related? If so, why not have them in a single Excel file?
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 19 guests