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: Identifying subfamilies (2nd+ marriages) within records of families
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: Identifying subfamilies (2nd+ marriages) within records of families
Date
Wed, 1 Feb 2012 23:30:47 +0000
Good. Now retract the slur on my blonde friends and family members!
Nick
On Wed, Feb 1, 2012 at 11:26 PM, Anna Reimondos <[email protected]> wrote:
> Thanks Nick- that worked perfectly!!
> Much appreciated,
> Anna
>
> On Thu, Feb 2, 2012 at 10:10 AM, Nick Cox <[email protected]> wrote:
>> Blonde moment!!!
>>
>> Sounds like
>>
>> bysort family (reg) : gen familynum = sum(reg != reg[_n-1]) - 1
>>
>> With this definition, I am assuming that -family- is string (else how
>> can a value be empty?) and the wife herself is labelled 0.
>>
>> There would be a small tweak needed if -family- were really numeric.
>>
>> Nick
>>
>> On Wed, Feb 1, 2012 at 10:53 PM, Anna Reimondos <[email protected]> wrote:
>>
>>> I have a dataset of families which looks something like this:
>>>
>>> The first variable is a family id, then there is a registration
>>> number, and a variable identifying whether the person is the wife,
>>> husband or child.
>>> In the example below there are two families. In the first family there
>>> is a wife, husband and kids. In the second family the woman has had 2
>>> marriages. In the first she had 2 children, and in the second marriage
>>> she had one child. What I would like to do is create a variable called
>>> 'familynum' which will number the different families within the main
>>> family.
>>>
>>> NB: There is no registration or familynum for the woman.
>>>
>>> family reg person familynum
>>> 1 Wife (1)
>>> 1 693 Husband(2) 1
>>> 1 693 Child (3) 1
>>> 1 693 Child (3) 1
>>> 2 Wife (1)
>>> 2 542 Husband(2) 1
>>> 2 542 Child (3) 1
>>> 2 542 Child (3) 1
>>> 2 879 Husband(2) 2
>>> 2 879 Child (3) 2
>>>
>>>
>>> I have done similar things before, and I know the solution is probably
>>> very obvious...but I am having a blonde moment.
>>
>> *
>> * 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/