I don't want the GSOEP is, although that detail seems incidental.
If I understand this correctly, your approach just compounds the problem
with the data structure.
For most subsequent analyses with Stata, you would be much better off
with a long data structure, rather than this wide one, in the
terminology of
-reshape-. Check out -reshape-, and then -tsset-. You will then find
that creation of variables like this is easier or indeed unnecessary.
Nick
[email protected]
Alekos Bibudis
Using data from the GSOEP I`d like to transform some variables handling
with information on occupational status.
There is a variable for each wave and month of the year holding 0/1
coded information wether the person was unemployed at this point in time
or not (84 variables from Jan99 to Dez05).
I additionally have information on the month and year the interview was
conducted. That is for each wave a variable coded 1 (Jan) to 12 (Dec) (7
variables from month00 to month06).
What I'd like to arrange is to generate twelve new variables holding the
information of unemployment status of the twelve months BEFORE the
interview was conducted (Monat1 to Monat12) starting with Interviewmonth
Jan00 and ending with Jan06.
The logic would be:
generate a new yariable and give it the value of the month before the
interview
generate another new variable and give it the value of two months before
the interview
...
generate a last variable and give it the value of twelve months befor
the interview
For 2006 there is no information on unemployment status, because it will
be gathered retrospectivively in the next wave.
Here's what I've tried, I know it doesn't work, but maybe it'll help to
see what I'm after:
#d;
version 9.1;
local y = 1999;
foreach x in 00 01 02 03 04 05 06{;
gen Monat1 = Dez`y' if month`x' = 1;
local y = `y' + 1;
};
I'd appreciate every help I can get on this.
*
* 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/
