EViews Gareth wrote:There are a number of different ways to enter data into a panel workfile. Which method works best really depends upon how your data starts out.
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
pagestack unemp?
Simple!
Greetings Gareth,
Thanks for your post. Very useful indeed.
Once doing this, how does one type in the equations in a system for a Seemingly Unrelated Regression model?
Would it be something similar to the following?...
gdp_can=c(1)+c(2)*unemp_can
gdp_fra=c(3)+c(4)*unemp_fra
gdp_ita=c(5)+c(6)*unemp_ita
gdp_ger=c(7)+c(8)*unemp_ger
gdp_us=c(9)+c(10)*unemp_us
gdp_uk=c(11)+c(12)*unemp_uk
gdp_jpn=c(13)+c(14)*unemp_jpn
Hope I can get some help here
Cheers