Simo,
If both variables are numeric you can do this:
. gen long id1 = Batch_nu*10 + hhid_nu
If both variables are strings you can do this:
. gen id2 = Batch_nu + hhid_nu
This command works with strings and numeric variables:
. egen id3 = group(Batch_nu hhid_nu)
Friedrich Huebler
--- Simo Hansen <[email protected]> wrote:
> Dear All,
> I have a household level data that includes a batch number and
> within each
> batch number household id numbers. It looks like in the following
> form:
>
> Batch_nu hhid_nu
> 10100025 1
> 10100025 2
> 10100025 3
> 10100031 1
> 10100031 2
> 10100031 3
> 10100037 1
> 10100037 2
> 10100037 3
> My question is that how I can create an unique identification
> number for
> each household using batch_nu and hhid_nu.
> Thank you.
> Best regards,
> Simo
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
*
* 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/
