Resizing Undated Workfile
Posted: Tue Jun 14, 2011 9:03 am
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
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