st: Analysis of event history data

["Kristian Thor Jakobsen" <KRJ@dm.dk>]

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/