Reading this sort of file into an EViews panel is easy. If your data is currently in Excel and you want to put it into a panel workfile, then, again, the best way to do it really depends upon what form the data is in inside Excel.Ī common form of panel data structure in Excel is the following: Note if you wanted to do this via the command line, you just need to do this: 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). In this case I used unemp? The "?" represents the cross-section identifier (in this case _US or _CAN).
Thus I can use one of my series as a pattern. In our case our series (gdp and unemp) have a pattern of series_crossid. The easiest, in this case, is to enter a series pattern. Via the menus you can do this:Ĭlick on Proc->Reshape Current Page->Stack in New Page Moving this data into a panel workfile is relatively simple. For posts on entering data into a panel from Excel files, scroll down a bit! The workfile I'm using can be found at:Īs 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. In this post I'm going to describe a method which converts data that is currently in "pool" form into a panel. Which method works best really depends upon how your data starts out. There are a number of different ways to enter data into a panel workfile.