Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.

# Re: st: Identifying subfamilies (2nd+ marriages) within records of families

 From Anna Reimondos To statalist@hsphsun2.harvard.edu Subject Re: st: Identifying subfamilies (2nd+ marriages) within records of families Date Thu, 2 Feb 2012 10:52:42 +1100

```Ok I apologize to all your blonde friends and family members! There is
no scientific evidence for a link between hair colour and
intelligence. There is evidence that blondes have more fun though...
http://www.sciencedirect.com/science/article/pii/S016517651000114X

On Thu, Feb 2, 2012 at 10:30 AM, Nick Cox <njcoxstata@gmail.com> wrote:
> Good. Now retract the slur on my blonde friends and family members!
>
> Nick
>
> On Wed, Feb 1, 2012 at 11:26 PM, Anna Reimondos <areimondos@gmail.com> wrote:
>> Thanks Nick- that worked perfectly!!
>> Much appreciated,
>> Anna
>>
>> On Thu, Feb 2, 2012 at 10:10 AM, Nick Cox <njcoxstata@gmail.com> 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 <areimondos@gmail.com> 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/

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