Hi, I am asking this for a friend:
She has a data set in its wide form like this:
ID Wave1 Wave2 Wave3 ASMOK BSMOK CSMOK
1 0 1 1 . 1 0
2 1 1 0 1 0 .
Which reads: for person 1, he/she appears in wave 2
and wave 3 of the survey and reports to smoke in wave
2 (BSMOK) and not smoke in wave 3 (CSMOK). For person
2, he/she is interviewed in wave 1 and 2 but drops out
in wave 3 and reports to smoke in wave 1 and not in
wave 2.
The question is, the stub for reshape into variable
SMOK appears at the beginning of the variables as A, B
and C respectively for three waves (all the other
variables as well). Is there any easier way to
reshape the data? Or any suggestions?
Thanks,
Carol
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
*
* 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/
