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: 13307
Joined: Tue Sep 16, 2008 5:38 pm

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Mon Apr 16, 2012 8:50 am

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

distressedbydisso
Posts: 7
Joined: Fri Apr 13, 2012 12:02 pm

Re: How to enter data into a panel workfile.

Postby distressedbydisso » Mon Apr 16, 2012 11:09 am

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

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

How to enter data into a panel workfile.

Postby EViews Gareth » Mon Apr 16, 2012 11:44 am

-2
Follow us on Twitter @IHSEViews

tho_mi
Posts: 61
Joined: Sat May 12, 2012 2:41 am

Re: How to enter data into a panel workfile.

Postby tho_mi » Sat May 12, 2012 3:53 am

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?

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

How to enter data into a panel workfile.

Postby EViews Gareth » Sat May 12, 2012 6:51 am

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

tho_mi
Posts: 61
Joined: Sat May 12, 2012 2:41 am

Re: How to enter data into a panel workfile.

Postby tho_mi » Sat May 12, 2012 7:55 am

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.

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

How to enter data into a panel workfile.

Postby EViews Gareth » Sat May 12, 2012 9:35 am

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

tho_mi
Posts: 61
Joined: Sat May 12, 2012 2:41 am

Re: How to enter data into a panel workfile.

Postby tho_mi » Sun May 13, 2012 10:51 am

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 :)

tho_mi
Posts: 61
Joined: Sat May 12, 2012 2:41 am

Re: How to enter data into a panel workfile.

Postby tho_mi » Tue May 15, 2012 9:23 am

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.

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

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Tue May 15, 2012 9:27 am

You have to specify the source and destination IDs.
Follow us on Twitter @IHSEViews

tho_mi
Posts: 61
Joined: Sat May 12, 2012 2:41 am

Re: How to enter data into a panel workfile.

Postby tho_mi » Tue May 15, 2012 9:38 am

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

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

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Tue May 15, 2012 12:01 pm

All the documentation should be available in PDF form from the Help menu.
Follow us on Twitter @IHSEViews

tho_mi
Posts: 61
Joined: Sat May 12, 2012 2:41 am

Re: How to enter data into a panel workfile.

Postby tho_mi » Wed May 16, 2012 6:23 am

EViews Gareth wrote:All the documentation should be available in PDF form from the Help menu.


Ah, wonderful, thanks.

dasilver
Posts: 8
Joined: Wed Aug 04, 2010 11:35 am

Re: How to enter data into a panel workfile.

Postby dasilver » Mon May 21, 2012 10:37 am

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

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

Re: How to enter data into a panel workfile.

Postby EViews Gareth » Mon May 21, 2012 10:39 am

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: Google [Bot] and 14 guests