Re: st: reshaping problem: unique values in other variables

[Michael McCulloch <mm@pinest.org>]

Thank you Philip!

At 04:51 PM 3/18/2006, you wrote:
> Use 2 calls to -reshape- ensuring that at each call, the value of the 
> variables is unique within the identifier, or, here, set of identifiers, 
> specified in the i() option :
>
>
> . li, clean
>
>        id   dset   rec   med   afev   wheeze   cough
>   1.    2      b     1     0     -9        0       0
>   2.    2      b     2     1     -9        0       0
>   3.    2      a     1     1    1.7        0       0
>   4.    2      a     2     0    1.8        0       0
>   5.    6      b     1     1     -9        0       1
>   6.    6      b     2     1     -9        0       0
>   7.    6      a     1     0   2.08        0       1
>   8.    6      a     2     0   1.85        0       0
>
> . reshape wide med afev wheeze cough, i(id rec)  j(dset) string
>
> * note variable dset is a string, hence the string option is specified
> * note sneaky use of two identifiers whose conjunction _for the 
> subobservation now defined by drec_  yields unique values for med, afev etc
>
>
> . list, clean
>
>        id   rec   meda   afeva   wheezea   cougha   medb   afevb 
> wheezeb   coughb
>   1.    2     1      1     1.7         0        0      0      -9 
> 0        0
>   2.    2     2      0     1.8         0        0      1      -9 
> 0        0
>   3.    6     1      0    2.08         0        1      1      -9 
> 0        1
>   4.    6     2      0    1.85         0        0      1      -9 
> 0        0
>
> . reshape wide med* afev* wheeze* cough*,  i(id ) j(rec)
>
>
> . list id med* af* wh*, clean
>
>        id   meda1   medb1   meda2   medb2   afeva1   afevb1   afeva2 
> afevb2   wheezea1   wheezeb1   wheezea2   wheezeb2
>   1.    2       1       0       0       1      1.7       -9      1.8 
> -9          0          0          0          0
>   2.    6       0       1       0       1     2.08       -9     1.85 
> -9          0          0          0          0
>
>
> (where for clarity I have left out listing some of the variables because 
> of ugly line-wrapping, at least on my screen)
>
> Phil
>
>
> .
> At 09:25 PM 16/03/2006 -0800, you wrote:
>
> > I have data with the following structure:
> >
> > list id  rec med afev  wheeze cough date agev
> >   +---------------------------------------------------+
> >   | id          dset   rec   med  afev   wheeze   cough |
> >   |---------------------------------------------------|
> >   |  2      b     1     0         -9        0       0 |
> >   |  2      b     2     1         -9        0       0 |
> >   |  2      a     1     1       1.70        0       0 |
> >   |  2      a     2     0       1.80        0       0 |
> >   |  6      b     1     1         -9        0       1 |
> >   |  6      b     2     1         -9        0       0 |
> >   |  6      a     1     0       2.08        0       1 |
> >   |  6      a     2     0       1.85        0       0 |
> >   +---------------------------------------------------+
> >
> > I wish to reorganize the data so that there is one row for each ID, with 
> > subsets for dset (a or b) and rec (1 or 2) for each of the variables: 
> > med, afev, wheeze, cough.
> >
> > My goal is to have:
> > id      med(a1)  med(b1)  med(a2)  med(b2)      afev(a1)  afev(b1) 
> > afev(a2)   afev(b2)
> > 2         1             0             0             1               1.70 
> >  -9             1.80          -9
> > 6         0             1             0             1             2.08 
> > -9             1.85          -9
> >
> > I have tried using the reshape command but each subset does not have 
> > unique values of the variables afev, wheeze, and cough.
> > I have tried using the collapse command, but I do not want to create 
> > summary statistics.
> > I have tried using the contract command, but I do not want to create 
> > frequency counts.
> > Any assistance would be greatly appreciated.
> >
> >
> >
> >
> >
> > Best wishes,
> > Michael
> >
> >
> > ____________________________________
> >
> > Michael McCulloch
> > Pine Street Clinic
> > 124 Pine Street, San Anselmo, CA 94960-2674
> > tel     415.407.1357
> > fax     415.485.1065
> > email:  mm@pinest.org
> > web:    www.pinest.org
> >         www.pinestreetfoundation.org
> >
> >
> >
> >
> >
> > *
> > *   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/
> Philip Ryan
> Associate Professor,
> Department of Public Health
>
> Head, Data Management & Analysis Centre
> Faculty of Health Sciences
>
> postal address:
> Department of Public Health
> Mail Drop 511
> University of Adelaide 5005
> South Australia
>
> location:
> Level 6
> Bice Building
> Royal Adelaide Hospital
> North Terrace
> Adelaide
>
> tel 61 8 8303 3570
> fax 61 8 8223 4075
> http://www.public-health.adelaide.edu.au/
> CRICOS Provider Number 00123M
> -----------------------------------------------------------
> This email message is intended only for the addressee(s)
> and contains information that may be confidential and/or
> copyright. If you are not the intended recipient please
> notify the sender by reply email and immediately delete
> this email. Use, disclosure or reproduction of this email
> by anyone other than the intended recipient(s) is strictly
> prohibited. No representation is made that this email or
> any attachments are free of viruses. Virus scanning is
> recommended and is the responsibility of the recipient.
>
> *
> *   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/

Best wishes,
Michael


____________________________________

Michael McCulloch
Pine Street Clinic
124 Pine Street, San Anselmo, CA 94960-2674
tel     415.407.1357
fax     415.485.1065
email:  mm@pinest.org
web:    www.pinest.org
        www.pinestreetfoundation.org





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