Page 11 of 16
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 7:26 am
by EViews Gareth
In the Excel file, which column corresponds to the cross sections?
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 8:39 am
by agaro123
None i guess, i'm not quite sure how to do that
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 8:56 am
by EViews Gareth
If you don't know what your cross sections are, it is unlikely that EViews will either.
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 9:11 am
by agaro123
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?
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 9:15 am
by EViews Gareth
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?
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 9:17 am
by agaro123
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
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 9:24 am
by EViews Gareth
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.
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 9:38 am
by agaro123
So there's no way I am gonna run my 3-dimensional panel in eviews
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 9:41 am
by EViews Gareth
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.
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 11:53 am
by agaro123
Gareth,
Could you let me know how to do that? I need to employ a gravity model, hence the 3-dimensional panel data
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 12:13 pm
by EViews Gareth
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.
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 12:55 pm
by agaro123
That's when i get the illegal panel structure error: Year nested with whatever I put as cross-section id (1:4186)
Re: How to enter data into a panel workfile.
Posted: Wed Feb 11, 2015 2:41 pm
by EViews Gareth
What did you enter?
Re: How to enter data into a panel workfile.
Posted: Wed Mar 11, 2015 4:07 am
by mikela
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
Re: How to enter data into a panel workfile.
Posted: Wed Mar 11, 2015 8:46 am
by EViews Gareth
Code: Select all
%file = "c:\temp\bankdataeviewsforum.xlsx"
%sheetnames = @tablenames(%file)
for %s {%sheetnames}
import %file @rename * {%s}*
next
pagestack x_11180?