I had a similar problem recently and the only way that I know to solve it is
renaming the variables. In my case it was very time consuming.
Juan
Quoting Carol Bao <[email protected]>:
> 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/
>
*
* 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/
