EViews.com

Hi,

I would like to perform analysis on a panel data from excel, however I struggle with importing the data .
The excel file consists time series data and cross section data as well. The problem is that my number of observation isn't equal among the cross section data.
I've tried all the methods which could be found here and couldn't make it.
It will be super kind if someone will help to solve this issue.

The file is constructed as the follow :

Time code parameter parameter parameter ......
2008 x
2009 x
2010 x
2011 x
2008 y
2009 y
2010 y

As can be noticed Y has 3 time series data and x has 4. I couldn't upload the original data cause it is too large.
I cannot organized the codes in the original file cause it has many codes.
Any tips, comments will be welcomed.

Many thanks and have a nice day.

That structure should work just fine. EViews doesn't care if the panel is balanced or not, it will still read it in just fine.

Thank you !

So I did "open- foreign data as a work file" and still it give me many "N/A" although I've done it with Eview 7". any clue ?

I think we'll need to see the file to offer any help.

unfortunately, the file is larger than 2 MB, tried with unzip but still 3.6MB , may I send it to your email?

sent
Thank you :)

Row 13097 has no TICK value.

I fixed it and deleted this row and still many "NA" when I open as a foreign work file :\

Could you give an example of where you get an NA?

As always, the more details you give, the easier it is for us to help you.

Hi , Thanks .

After I deleted the row and impotred the file it gives me N/A for each factor .
I attach print screen.

What's the build date and version number of your copy (Help->About EViews)?

7.1 sep 2010 build - enterprise

That's 3 years out of date. Update to the latest version of 7.
http://www.eviews.com/download/download.html

Hi, I have the following series

h1 x1
1 0.5
2 0.6
3 0.8
2 -0.5
1 -0.6
3 0.6
...

for each x, I want to create 3 series by:

smpl @all if h1=1
y1=x1
smpl @all if h1=2
y2=x1
smpl @all if h1=3
y3=x1

However, y series are not continuous and can't run garch models: arch(1,1) y1 y1(-1) y2(-1) y3(-1)
Could you please help? Thanks a lot. Horward