Dear Statalisters
I am writing to ask for advice regarding transition tables using long
data. I have 12 waves of data and want to work out entries and exits
from poverty. I have created the relevant variables using a lag of 1
period however, how would I modify this to allow me to create specific
transition tables for entries and exits between wave1 and wave 7, and
then wave7 and wave12 (rather than the previous period only as in the
code below?
Any help would be most appreciated.
Sara
ge lagpov=L.ps60
lab var lagpov "pov status, previous interview"
lab val lagpov ps60
ta lagpov ps60, row col
ta lagpov ps60 if wave==2, row col
*DUMMY VARIABLES MARKING ENTRY TO & EXIT FROM POVERTY
ge enterpov=0 if L.ps60==0
replace enterpov=1 if L.ps60==0 & ps60==1
lab var enterpov "entered poverty?"
lab def enterpov 0 "stayed non-poor" 1 "entered poverty"
lab val enterpov enterpov
ge exitpov=0 if L.ps60==1
replace exitpov=1 if L.ps60==1 & ps60==0
lab var exitpov "left poverty?"
lab def exitpov 0 "stayed poor" 1 "left poverty"
lab val exitpov exitpov
*
* 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/