I am trying to do an analysis of transition in and out of public income
transfers. My data is organized roughly the following way:
Id y_1001 y_1002 y_1003
1 0 1 0
2 0 0 0
3 1 1 0
This means that I have the weekly status of each individual from 1991 to
2011. But in order to any sort of analysis I would guess that I had to
convert the data into the following way instead (for example survival
analysis):
Id Status Time
1 0 1
1 1 2
1 0 3
2 0 1
2 0 2
2 0 3
3 1 1
3 1 2
3 0 3
Is that correct, and if so, does there exist a smart way to convert the
data from one format into the other? Or can I perhaps use the data as
given?
Thanks,
Kristian
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
