PANEL DATA

[Soli]

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.

[EViews Gareth]

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.

[Soli]

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 ?

[EViews Gareth]

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

[Soli]

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

[EViews Gareth]

support@eviews.com

[Soli]

sent
Thank you :)

[EViews Gareth]

Row 13097 has no TICK value.

[Soli]

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

[EViews Gareth]

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.

[Soli]

Hi , Thanks .

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

[EViews Gareth]

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

[Soli]

7.1 sep 2010 build - enterprise

[EViews Gareth]

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

[COM446]

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