Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Re: reshape when the stub is at the beginning of the variables


From   "Michael Blasnik" <michael.blasnik@verizon.net>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: reshape when the stub is at the beginning of the variables
Date   Tue, 25 Apr 2006 19:55:40 -0400

Check out the advanced syntax for reshape. I believe that you can specify the location of the "j" part of the variable names using the @ symbol. I haven't used this option in a while, but I think you will need to specify that the j variable is a string and may need to use the atwl() option for the reshape xij line.

reshape xij @SMOK

Michael Blasnik
michael.blasnik@verizon.net

----- Original Message ----- From: "Carol Bao" <yanjunbb@yahoo.com>
To: <statalist@hsphsun2.harvard.edu>
Cc: <nmani1@uic.edu>
Sent: Tuesday, April 25, 2006 7:01 PM
Subject: st: reshape when the stub is at the beginning of the variables



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
*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index