Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: RE: combine data by groups
From
"G. Dai" <[email protected]>
To
[email protected]
Subject
Re: st: RE: combine data by groups
Date
Wed, 3 Mar 2010 12:12:17 -0800
thanks, Nick. Get your advice ;-)
On Wed, Mar 3, 2010 at 12:10 PM, G. Dai <[email protected]> wrote:
> that is great. thank you, Martin!
> G.
>
>
> On Wed, Mar 3, 2010 at 12:05 PM, Martin Weiss <[email protected]>wrote:
>
>>
>> <>
>>
>> *******
>> clear*
>>
>> inp str10 personid byte(parentsid momlive dadlive)
>> 001 1 0 .
>> 001 2 . 1
>> 002 1 1 .
>> 002 2 . 1
>> end
>>
>> compress
>> list, noo
>>
>> collapse (firstnm) momlive dadlive, by(personid)
>> list, noo
>> *******
>>
>>
>> HTH
>> Martin
>>
>> -----Original Message-----
>> From: [email protected]
>> [mailto:[email protected]] On Behalf Of G. Dai
>> Sent: Mittwoch, 3. März 2010 20:40
>> To: [email protected]
>> Subject: st: combine data by groups
>>
>> hi all, this is an easy question,but somehow I can't figure it.
>> The data is like:
>> personid parentsid momlive dadlive
>> 001 1 0
>> .
>> 001 2 .
>> 1
>> 002 1 1
>> .
>> 002 2 .
>> 1
>>
>> where personid and parentsid are person and her parents' id.
>> when parentid==1, we only record whether mom still live or not (momliv)
>> similarly
>> for parentid==2 and dadlive.
>>
>> I want to change the data set to the following form
>>
>> personid momlive dadlive
>> 001 0 1
>> 002 1 1
>>
>> what is the best way to do this?
>>
>> thanks,
>> Guang
>>
>> *
>> * For searches and help try:
>> * http://www.stata.com/help.cgi?search
>> * http://www.stata.com/support/statalist/faq
>> * http://www.ats.ucla.edu/stat/stata/
>>
>>
>> *
>> * For searches and help try:
>> * http://www.stata.com/help.cgi?search
>> * http://www.stata.com/support/statalist/faq
>> * http://www.ats.ucla.edu/stat/stata/
>>
>
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/