Resizing Undated Workfile

[bjohn]

I have accquired a dataset in very raw form. It is structured with five series containing: country, year, variable name, value and data vintage.

The dataset is unbalanced, in the sense that if there is no data for a particular country in a certain year, the dataset contains to reference to it. I would first like to resize the dataset so that it contains N*T*V*D observations, where N=number of countries, T=maximum span of time, V=number of variables,D=total number of different data vintages, and where missing data is simply coded NA.

I tried to use the pagestruct command to do this but without success. If you could let me know how to reshape it, I would be very grateful

[EViews Gareth]

I'm assuming you want a standard panel, with YEAR as your time series ID, and COUNTRY as your cross-section ID:

Code: Select all

pagestruct(balance=sem) country @date(year)