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   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: Re: reshape when the stub is at the beginning of the variables
Date   Wed, 26 Apr 2006 23:38:59 +0100

I don't think so; but I can't prove that

But turn it round. What are you expecting? 

That -reshape- should
somehow realise that A matches 1, B matches 
2, C matches 3?  

What would you expect -reshape- to do if the 
variables were 

ID WaveX WaveY WaveZ ASMOK BSMOK CSMOK 

That one works, but not in the same way. 

Nick 
n.j.cox@durham.ac.uk 

> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Ada Ma
> Sent: 26 April 2006 23:22
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: Re: reshape when the stub is at the beginning of the
> variables
> 
> 
> Carol Bao's friend data set looks interesting.  I had not noticed the
> atwl option before.  If the variable names were:
> ID   WaveA WaveB WaveC ASMOK BSMOK CSMOK
> 
> I could have reshaped it long in one shot:
> reshape long @SMOK Wave, i(ID) j(type) atwl() string
> 
> But unfortunate they are not, they are:
> ID   Wave1 Wave2 Wave3 ASMOK BSMOK CSMOK
> 
> Is it still possible to reshape both the Wave variables and the SMOK
> variables in one shot?
> 
> 
> 
> On 4/26/06, Michael Blasnik <michael.blasnik@verizon.net> wrote:
> > 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?
> > >
> 

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