Thanks Nick for the answer. I asked becoz I was thinking that there
may be a way to tell Stata that A=1 and B=2, so on and so forth. The
wave variables in the original data set are frivolous anyway - the
SMOK variables being missing whenever the person failed to respond in
that wave.
Cheers,
Ada
On 4/26/06, Nick Cox <n.j.cox@durham.ac.uk> wrote:
> 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/
>
--
Ada Ma
Research Fellow
Health Economics Research Unit
University of Aberdeen, UK.
http://www.abdn.ac.uk/heru/
Tel: +44 (0) 1224 553863
Fax: +44 (0) 1224 550926
*
* 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/