st: Re: RE: RE: Identifier from three variables

["N�dia N. Sim�es" <nadia.simoes@iscte.pt>]

my mistake. do not consider the previous email
----- Original Message ----- 
From: "Rafael Osorio" <rafael.osorio@undp-povertycentre.org>
To: <statalist@hsphsun2.harvard.edu>
Sent: Monday, July 30, 2007 1:45 PM
Subject: st: RE: RE: Identifier from three variables



> Other way of doing it, supposing each identifier is <= 99:
>
> gen id = house*1000+family*100+individual
>
> By doing it this way you can tell to which house and family a specific 
> person belongs to. If your data was not sorted by the identifiers, if you 
> sort by this new identifier the result will be equal to sorting it by all 
> identifiers. If your final id is large:  gen double id...
>
> If your identifiers are greater than 99, adjust the multipliers.
>
> Rgds,
>
> Rafael
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu 
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox
> Sent: Friday, July 27, 2007 2:09 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: RE: Identifier from three variables
>
> I'll answer this myself:
>
> 1. Don't do that. Use -egen, group()- with the -label- option.
>
> 2. See also
>
> FAQ     . . . . . . . . . . . . . . . . . . . . . . Creating group 
> identifiers
>        3/01    How do I create individual identifiers numbered
>                from 1 upwards?
>                http://www.stata.com/support/faqs/data/group.html
>
> 3. If you really must, look into -egen, concat()-, including
> its options.
>
> Nick
> n.j.cox@durham.ac.uk
>
> N�dia N. Sim�es
>
> >  How can I generate an identifier from three variables?
> > In my data I have a column for the house, one for the family
> > and one for the individual
> >
> > example:
> >
> > house     family   individual
> > 1                 1         1
> > 1                 1         2
> > 1                 1         3
> > 2                 1         1
> > 2                 1         2
> > ...
> >
> > and I would like to know how can I create an identifier per
> > individual such as:
> >
> > individual
> > 010101
> > 010102
> > 010103
> > 020101
> > ...
> *
> *   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/
>
> *
> *   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/
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.476 / Virus Database: 269.10.25/926 - Release Date: 
> 29-07-2007 23:14
*
*   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/