In addition, -egen, concat()- works either way,
and even with a combination of numeric and string
inputs. The result is always string.
Incidentally, with -egen, group()- you would
usually like to add the -label- option. However,
Simo's dataset might be really big, in which
case -egen, concat()- might offer the better choice.
Nick
[email protected]
Friedrich Huebler
> 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)
Simo Hansen
> > 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.
*
* 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/
