Re: st: Fwd: Constructing Household IDs

[Andrea Smurra <andrea.smurra@theigc.org>]

Thanks to all,

Nigussie, your method is definitely the most creative as it does not 
require anything more than gen and some algebra, thanks for your support.
I ended up following Chamara method using the following command

gen str3 z=string(x, "%003,0f")

and then

gen hhid=state+district +...

Problem solved,
Thank you all very much

Andrea


Il 30/01/2013 14:20, nigussie Tefera ha scritto:
> Dear Andrea,
> Suppose each of them stand with a three digits identifiers, i.e. state has a maximum of three digits numerical values and so no. Simply, suppose you have 343 for sss, 213 for DDD, 567 for TTT … and at last you have 143 for HHH. So if you want to generate unique household id identifier of the form 343213567143, you can write the following simple command.
> gen double hhid=10^9*sss+10^6*DDD+10^3*TTT+HHH
> Note that 10^”x” could vary depending on the number of maximum digits that either of them have....
> Best
> Nigussie
>
> ----- Original Message -----
> From: Chamara Anuranga <kcanuranga@gmail.com>
> To: statalist@hsphsun2.harvard.edu
> Cc:
> Sent: Wednesday, January 30, 2013 10:23 AM
> Subject: Re: st: Fwd: Constructing Household IDs
>
> check all identifier variable and check the maximum length.
> state may be maximum 2 digits
> district may be 3 digits etc.
> add leading zeros to id variables base on maximum number
>
> format state %02.0f
> format district %03.0f
>
> here % to represent format, 0 to represent leading zero and .0 is no
> decimal places and f mean fix format
>
> then convert the variable to string.
>
> tostring state district,replace usedis
>
> then combine each string part using generate command
> gen hhid=state+district
>
> Thanks,
> Chamara
>
>
>
>
>
>
> On Wed, Jan 30, 2013 at 12:27 PM, Andrea Smurra
> <andrea.smurra@theigc.org> wrote:
> > Hello Statalists,
> > I am working with an household survey which doesn't have household IDs.
> > Each household is identified by a series of variables (State, district,
> > township, ..., household number).
> > Within each state, the numbering of districts always starts from the integer
> > 1, the same for towns within each district and so on up to the household in
> > each ward.
> > I tried to build unique HH identifier with the command "group", but I'd like
> > to build a HH ID which looks like SSSDDDTTT...HHH
> > where SSS is the state identifier (with the correct number of zeros appended
> > when necessary (i don't know how to do it)), DDD is the District identifier
> > and so on. I'm using STATA 12 for windows 7. I'm sure it will be an easy
> > task for an expert statalist, but I am still a beginner.
> > Thanks
> > Andrea
> >
> >
> > *
> > *  For searches and help try:
> > *  http://www.stata.com/help.cgi?search
> > *  http://www.stata.com/support/faqs/resources/statalist-faq/
> > *  http://www.ats.ucla.edu/stat/stata/
> *
> *  For searches and help try:
> *  http://www.stata.com/help.cgi?search
> *  http://www.stata.com/support/faqs/resources/statalist-faq/
> *  http://www.ats.ucla.edu/stat/stata/
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/statalist-faq/
> *   http://www.ats.ucla.edu/stat/stata/


--
Andrea Smurra
In-Country Economist
The International Growth Centre

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/