The DHS Program User Forum: Merging data files » Creating unique household id in Women's data

Home » Data » Merging data files » Creating unique household id in Women's data

Show: Today's Messages :: Show Polls :: Message Navigator

Re: Creating unique household id in Women's data [message #11561 is a reply to message #11533]

Tue, 10 January 2017 16:49

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

Quote:

In IR files, v001 is the cluster number; v002 is the household number (within v001) and v003 is the woman's line number (within v001 and v002). Together, v001 and v002 identify the household; v001 and v002 and v003 identify the individual woman. In IAIR42FL.dta, caseid is a character string that includes v001, v002, and v003. To get a household id, you can remove the last three columns (which give v003) from caseid. That is, use this line in Stata:

gen hhid=substr(caseid,1,12)

Report message to a moderator

[Message index]

		Creating unique household id in Women's data By: priyoma on Mon, 09 January 2017 09:59
		Re: Creating unique household id in Women's data By: Bridgette-DHS on Tue, 10 January 2017 16:49
		Re: Creating unique household id in Women's data By: priyoma on Thu, 12 January 2017 03:08
		Re: Creating unique household id in Women's data By: Bridgette-DHS on Fri, 13 January 2017 07:55

Previous Topic:	Child's weight in Kg (1 decimal) variable in SAS
Next Topic:	Merging mother's data with children's data in SAS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Dec 22 11:33:50 Coordinated Universal Time 2024