For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.
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?
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.
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.
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?
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 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...
I know that there is/should be a command reference, but it's missing here at our university :X
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.
Who is online
Users browsing this forum: No registered users and 4 guests