In this post I'm going to describe a method which converts data that is currently in "pool" form into a panel. For posts on entering data into a panel from Excel files, scroll down a bit! The workfile I'm using can be found at:
http://www.eviews.com/Forum_support/poo ... poolg7.wf1
The workfile looks like this:
As you can see there are 7 cross-sections, CAN, FRA, GER, ITA, JPN, UK, USA, with 43 years of data (1950 to 1992) and two data series, GDP and Unemp.
Moving this data into a panel workfile is relatively simple. Via the menus you can do this:
Click on Proc->Reshape Current Page->Stack in New Page
Enter the stacking identifiers.
You have a number of choices for this. The easiest, in this case, is to enter a series pattern. In our case our series (gdp and unemp) have a pattern of series_crossid. Thus I can use one of my series as a pattern. In this case I used unemp? The "?" represents the cross-section identifier (in this case _US or _CAN).
Hit ok, and you're done!
Note how you now have a panel workfile (you can tell from the Range statement at the top of the workfile - the fact it has a x7 at the end lets us know it is a panel).
Note if you wanted to do this via the command line, you just need to do this:
- Code: Select all