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