Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Fwd: Constructing Household IDs

From   Chamara Anuranga <>
Subject   Re: st: Fwd: Constructing Household IDs
Date   Wed, 30 Jan 2013 12:53:40 +0530

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


On Wed, Jan 30, 2013 at 12:27 PM, Andrea Smurra
<> 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:
> *
> *
> *
*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index