How to enter data into a panel workfile.

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

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

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Wed Feb 11, 2015 7:26 am

In the Excel file, which column corresponds to the cross sections?
Follow us on Twitter @IHSEViews

agaro123
Posts: 10
Joined: Mon Feb 09, 2015 10:10 am

Re: How to enter data into a panel workfile.

Postby agaro123 » Wed Feb 11, 2015 8:39 am

None i guess, i'm not quite sure how to do that

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

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Wed Feb 11, 2015 8:56 am

If you don't know what your cross sections are, it is unlikely that EViews will either.
Follow us on Twitter @IHSEViews

agaro123
Posts: 10
Joined: Mon Feb 09, 2015 10:10 am

Re: How to enter data into a panel workfile.

Postby agaro123 » Wed Feb 11, 2015 9:11 am

could you care to explain that to me so I can modify the excel file accordingly? This is the latest file i used. does this show cross sections?
Attachments
Book1.xlsx
(398.01 KiB) Downloaded 522 times

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

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Wed Feb 11, 2015 9:15 am

ok, let's take another step back. You've asked how to have EViews recognise your panel data. How is your data panel data? I don't mean in terms of EViews. I don't mean in terms of Excel. I mean what makes your data panel data?
Follow us on Twitter @IHSEViews

agaro123
Posts: 10
Joined: Mon Feb 09, 2015 10:10 am

Re: How to enter data into a panel workfile.

Postby agaro123 » Wed Feb 11, 2015 9:17 am

I'm looking at FDI inflows from 16 source countries into 14 host countries from 1990-2012 - which makes it a panel? to be honest i havent worked with panel data so far, so i'm not quite sure.
thanks for your patience gareth

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

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Wed Feb 11, 2015 9:24 am

A standard panel (2-dimensional) has a time dimension and a single cross-section dimension. You need to figure out how to define those in your data.
Follow us on Twitter @IHSEViews

agaro123
Posts: 10
Joined: Mon Feb 09, 2015 10:10 am

Re: How to enter data into a panel workfile.

Postby agaro123 » Wed Feb 11, 2015 9:38 am

So there's no way I am gonna run my 3-dimensional panel in eviews

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

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Wed Feb 11, 2015 9:41 am

EViews will allow 3-dimensional panel data, sure. You just have to give it two cross-section identifiers. But most statistical techniques require a 2d panel.
Follow us on Twitter @IHSEViews

agaro123
Posts: 10
Joined: Mon Feb 09, 2015 10:10 am

Re: How to enter data into a panel workfile.

Postby agaro123 » Wed Feb 11, 2015 11:53 am

Gareth,

Could you let me know how to do that? I need to employ a gravity model, hence the 3-dimensional panel data

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

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Wed Feb 11, 2015 12:13 pm

Bring the file into EViews, then click on Proc->Structure/Resize, change the structure to dated panel, and enter the time and cross-section identifiers.
Follow us on Twitter @IHSEViews

agaro123
Posts: 10
Joined: Mon Feb 09, 2015 10:10 am

Re: How to enter data into a panel workfile.

Postby agaro123 » Wed Feb 11, 2015 12:55 pm

That's when i get the illegal panel structure error: Year nested with whatever I put as cross-section id (1:4186)

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

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Wed Feb 11, 2015 2:41 pm

What did you enter?
Follow us on Twitter @IHSEViews

mikela
Posts: 14
Joined: Tue Jan 11, 2011 8:24 am

Re: How to enter data into a panel workfile.

Postby mikela » Wed Mar 11, 2015 4:07 am

Hi,
i've looked through this thread but i can't find a way to use any of the programs to import my data from excel and stack them in eviews.

i attach the excel file, there are 230 cross sections, and 10 variables across 9 years (but some sheets will have less years).

Is there a way i can import them in a loop and stack them using as variable names the xls sheets? and as ids the b1, b2, b3, ... cross ids?

thanks!
m
Attachments
bankDataEviewsForum.xlsx
(188.78 KiB) Downloaded 531 times

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

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Wed Mar 11, 2015 8:46 am

Code: Select all

%file = "c:\temp\bankdataeviewsforum.xlsx"
%sheetnames = @tablenames(%file)

for %s {%sheetnames}
   import %file @rename * {%s}*
next

pagestack x_11180?
Follow us on Twitter @IHSEViews


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 15 guests