PANEL DATA

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

Soli
Posts: 7
Joined: Wed Sep 30, 2015 6:01 am

PANEL DATA

Postby Soli » Wed Sep 30, 2015 6:20 am

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
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12542
Joined: Tue Sep 16, 2008 5:38 pm

Re: PANEL DATA

Postby EViews Gareth » Wed Sep 30, 2015 7:59 am

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.
Follow us on Twitter @IHSEViews

Soli
Posts: 7
Joined: Wed Sep 30, 2015 6:01 am

Re: PANEL DATA

Postby Soli » Wed Sep 30, 2015 9:00 am

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
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12542
Joined: Tue Sep 16, 2008 5:38 pm

Re: PANEL DATA

Postby EViews Gareth » Wed Sep 30, 2015 9:49 am

I think we'll need to see the file to offer any help.
Follow us on Twitter @IHSEViews

Soli
Posts: 7
Joined: Wed Sep 30, 2015 6:01 am

Re: PANEL DATA

Postby Soli » Wed Sep 30, 2015 10:06 am

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

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

Re: PANEL DATA

Postby EViews Gareth » Wed Sep 30, 2015 10:17 am

Follow us on Twitter @IHSEViews

Soli
Posts: 7
Joined: Wed Sep 30, 2015 6:01 am

Re: PANEL DATA

Postby Soli » Wed Sep 30, 2015 10:29 am

sent
Thank you :)

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

Re: PANEL DATA

Postby EViews Gareth » Wed Sep 30, 2015 10:37 am

Row 13097 has no TICK value.
Follow us on Twitter @IHSEViews

Soli
Posts: 7
Joined: Wed Sep 30, 2015 6:01 am

Re: PANEL DATA

Postby Soli » Wed Sep 30, 2015 10:50 am

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

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

Re: PANEL DATA

Postby EViews Gareth » Wed Sep 30, 2015 11:16 am

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.
Follow us on Twitter @IHSEViews

Soli
Posts: 7
Joined: Wed Sep 30, 2015 6:01 am

Re: PANEL DATA

Postby Soli » Wed Sep 30, 2015 12:31 pm

Hi , Thanks .

After I deleted the row and impotred the file it gives me N/A for each factor .
I attach print screen.
Attachments
Capture.PNG
Capture.PNG (38.96 KiB) Viewed 3362 times

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

Re: PANEL DATA

Postby EViews Gareth » Wed Sep 30, 2015 12:57 pm

What's the build date and version number of your copy (Help->About EViews)?
Follow us on Twitter @IHSEViews

Soli
Posts: 7
Joined: Wed Sep 30, 2015 6:01 am

Re: PANEL DATA

Postby Soli » Wed Sep 30, 2015 1:20 pm

7.1 sep 2010 build - enterprise

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

Re: PANEL DATA

Postby EViews Gareth » Wed Sep 30, 2015 1:34 pm

That's 3 years out of date. Update to the latest version of 7.
http://www.eviews.com/download/download.html
Follow us on Twitter @IHSEViews

COM446
Posts: 12
Joined: Wed Jul 08, 2015 2:10 pm

Re: PANEL DATA

Postby COM446 » Wed Nov 11, 2015 9:02 am

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
Last edited by COM446 on Wed Nov 11, 2015 10:00 am, edited 1 time in total.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 3 guests