How to enter data into a panel workfile.

[EViews Gareth]

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.

[distressedbydisso]

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]

-2

[tho_mi]

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]

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.

[tho_mi]

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]

Ah, ok. That should be even easier. Use wfopen to open the first file, then use import to open the remaining files.

[tho_mi]

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]

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.

[EViews Gareth]

You have to specify the source and destination IDs.

[tho_mi]

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]

All the documentation should be available in PDF form from the Help menu.

[tho_mi]

All the documentation should be available in PDF form from the Help menu.

Ah, wonderful, thanks.

[dasilver]

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]

The bottom of that example has the command line version.