How to enter data into a panel workfile.
Moderators: EViews Gareth, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13309
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
Yep, works in the same way as everywhere else in EViews, just write x(-1). EViews will know when the data is/isn't available.
Follow us on Twitter @IHSEViews
-
- Posts: 7
- Joined: Fri Apr 13, 2012 12:02 pm
Re: How to enter data into a panel workfile.
so if my variable is credit_growth_dummy, I need to go to generate and write credit_growth_dummy(2) - because I want the 1984 values to be in the 1986 row. Or will I have to write -2?
regards,
Fida
regards,
Fida
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13309
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
i want to join several xls-files to one panel (reading data from a single xls-file isn't a problem). is there an "easy way" to do that or do i have to put everything into one xls-file?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13309
- Joined: Tue Sep 16, 2008 5:38 pm
How to enter data into a panel workfile.
That's essentially the same as the example I gave where each cross-section is a different sheet of an Excel file. Having them in different files rather than different sheets is not much of a problem.
Follow us on Twitter @IHSEViews
Re: How to enter data into a panel workfile.
EViews Gareth wrote:That's essentially the same as the example I gave where each cross-section is a different sheet of an Excel file. Having them in different files rather than different sheets is not much of a problem.
thanks, but i think i mean something different. i don't have a file for each cross-section, i have different files for different variables of the cross-sections:
- unemp.xls - unemployment rates for each state for different years
- poverty.xls - poverty rates for each state for different years
i always have one column for the cross-section id and one for the year and then a third for the explanatory variable.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13309
- Joined: Tue Sep 16, 2008 5:38 pm
How to enter data into a panel workfile.
Ah, ok. That should be even easier. Use wfopen to open the first file, then use import to open the remaining files.
Follow us on Twitter @IHSEViews
Re: How to enter data into a panel workfile.
EViews Gareth wrote:Ah, ok. That should be even easier. Use wfopen to open the first file, then use import to open the remaining files.
Thanks
Re: How to enter data into a panel workfile.
tho_mi wrote:EViews Gareth wrote:Ah, ok. That should be even easier. Use wfopen to open the first file, then use import to open the remaining files.
Thanks
Reading the first xls works fine and gives me a panel, but import alone doesn't work, i always get the error message "Different number of id series provided for source and destination...". Do i have to add something to the import command?
edit:
Opening the second file alone also works fine.
Last edited by tho_mi on Tue May 15, 2012 9:30 am, edited 1 time in total.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13309
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
You have to specify the source and destination IDs.
Follow us on Twitter @IHSEViews
Re: How to enter data into a panel workfile.
EViews Gareth wrote:You have to specify the source and destination IDs.
Thanks, works now. Is there something like a documentation for the different commands? Always using google for such simple things is a bit frustrating...
edit:
I know that there is/should be a command reference, but it's missing here at our university :X
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13309
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
All the documentation should be available in PDF form from the Help menu.
Follow us on Twitter @IHSEViews
Re: How to enter data into a panel workfile.
EViews Gareth wrote:All the documentation should be available in PDF form from the Help menu.
Ah, wonderful, thanks.
Re: How to enter data into a panel workfile.
Is there a way to replicate the first method of creating a panel workfile using code, rather than going through the menus interactively? I can successfully convert from pooled data to stacked data using the first method described above, but I'd like to have some code to be able to quickly repeat the process.
Thanks
Thanks
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13309
- Joined: Tue Sep 16, 2008 5:38 pm
Re: How to enter data into a panel workfile.
The bottom of that example has the command line version.
Follow us on Twitter @IHSEViews
Return to “General Information and Tips and Tricks”
Who is online
Users browsing this forum: No registered users and 5 guests