Hello,
I have cross-sectional time series data and I would like to convert it
to a data set of annual observations by assuming that the variables
remained at the same level during each five year period. (I would like
to eventually merge it with another data set)
I discovered the "expand" command but I am not sure how to use it.
I have something that looks like:
ID period var1 year
1 1 205 .
1 2 220 .
and would like to do something like:
expand 5
sort ID period
by ID: replace year = 1960 in 1 if period==1
by ID: replace year = year[_n-1] + 1 if missing(year)
in order to get
ID period var1 year
1 1 205 1960
1 1 205 1961
1 1 205 1962
1 1 205 1963
1 1 205 1964
1 2 220 1965
1 2 220 1966
...
1 1 339 1960
1 1 339 1961
etc.
Perhaps one of you who has done this many times before can give me a hint?
Thanks very much,
Arnold.
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
