Statalist


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

RE: st: Identifier from three variables


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: Identifier from three variables
Date   Sun, 29 Jul 2007 16:28:47 +0100

-egen, concat()- was mentioned in my previous post in this 
thread. 

I agree with Svend that there are advantages to "reversible"
identifiers, and that they are pretty much necessary for any
subsequent merging. 

Nick 
n.j.cox@durham.ac.uk 

Svend Juul
 
> Nádia wrote (via Nick):
>  
> 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
> ...
>  
> -------------------------------------------------------------
>  
> Nick immediately advised against creating a composite identifier.
> In my experience, it can sometimes be quite useful. Here Nádia could:
>  
>    egen id = concat(house-individual), format(%02.0f)
>  
> For this to work, there must be no missing values in the original
> identifiers. If there are, things get messy.

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