Statalist The Stata Listserver


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

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


From   Paul Millar <[email protected]>
To   [email protected]
Subject   Re: st: Re: reshape when the stub is at the beginning of the variables
Date   Tue, 25 Apr 2006 18:09:43 -0600

Another approach might be to use the renpfix command, which renames (or removes the prefix) see -whelp renpfix-

Once the prefix is removed it is easy to reshape.

- Paul

----- Original Message -----
From: Michael Blasnik <[email protected]>
Date: Tuesday, April 25, 2006 5:55 pm
Subject: st: Re: reshape when the stub is at the beginning of the variables

> 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
> [email protected]
> 
> ----- Original Message ----- 
> From: "Carol Bao" <[email protected]>
> To: <[email protected]>
> Cc: <[email protected]>
> 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/
> 
*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index