Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: RE: Identifier from three variables


From   "Rafael Osorio" <rafael.osorio@undp-povertycentre.org>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: RE: Identifier from three variables
Date   Mon, 30 Jul 2007 09:45:51 -0300

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index