How to enter data into a panel workfile.
Moderators: EViews Gareth, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
In the Excel file, which column corresponds to the cross sections?
Follow us on Twitter @IHSEViews
Re: How to enter data into a panel workfile.
None i guess, i'm not quite sure how to do that
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
If you don't know what your cross sections are, it is unlikely that EViews will either.
Follow us on Twitter @IHSEViews
Re: How to enter data into a panel workfile.
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 525 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
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
Re: How to enter data into a panel workfile.
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
thanks for your patience gareth
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
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
Re: How to enter data into a panel workfile.
So there's no way I am gonna run my 3-dimensional panel in eviews
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
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
Re: How to enter data into a panel workfile.
Gareth,
Could you let me know how to do that? I need to employ a gravity model, hence the 3-dimensional panel data
Could you let me know how to do that? I need to employ a gravity model, hence the 3-dimensional panel data
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
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
Re: How to enter data into a panel workfile.
That's when i get the illegal panel structure error: Year nested with whatever I put as cross-section id (1:4186)
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
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
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 537 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13323
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
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 10 guests