The DHS Program User Forum: Merging data files » STATA codes to merge women and household datasets

Home » Data » Merging data files » STATA codes to merge women and household datasets

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

Re: STATA codes to merge women and household datasets [message #16073 is a reply to message #16025]

Thu, 01 November 2018 17:20

boyle014
Messages: 78
Registered: December 2015
Location: Minneapolis

Senior Member

Hi priyoma,

Thanks for the query. You've uncovered a temporary weakness with the system when using household members as the unit of analysis--the Household Number (HHID) variable is not available for selection.

To put all the household members' education on each woman's record in IPUMS DHS, you would first create a woman's data file (extract) with all the other variables you need. Then you would go back into the system, select household members as the unit of analysis and create a second extract with the additional variables. You would then merge the files on the HHID variable.

We are in the process of fixing this now. HHID and a few other technical variables will become available for household members extracts next week. We will be adding them when we release a new set of samples from Afghanistan, Angola, Burundi, Lesotho, Myanmar, Namibia, and Senegal. I will post again when that process is complete.

Professor Elizabeth Boyle
Sociology & Law, University of Minnesota, USA
Principal Investigator, IPUMS-DHS

Report message to a moderator

[Message index]

		STATA codes to merge women and household datasets By: Mrinal on Fri, 26 January 2018 11:53
		Re: STATA codes to merge women and household datasets By: Bridgette-DHS on Mon, 29 January 2018 20:05
		Re: STATA codes to merge women and household datasets By: Mrinal on Tue, 30 January 2018 03:28
		Re: STATA codes to merge women and household datasets By: boyle014 on Thu, 01 February 2018 11:14
		Re: STATA codes to merge women and household datasets By: Mrinal on Mon, 05 February 2018 01:07
		Re: STATA codes to merge women and household datasets By: boyle014 on Mon, 05 February 2018 13:08
		Re: STATA codes to merge women and household datasets By: Gowokani on Wed, 18 April 2018 18:52
		Re: STATA codes to merge women and household datasets By: boyle014 on Fri, 20 April 2018 14:00
		Re: STATA codes to merge women and household datasets By: priyoma on Tue, 23 October 2018 17:18
		Re: STATA codes to merge women and household datasets By: boyle014 on Thu, 01 November 2018 17:20
		Re: STATA codes to merge women and household datasets By: Isabelle on Sun, 11 August 2019 08:48
		Re: STATA codes to merge women and household datasets By: Bridgette-DHS on Fri, 23 August 2019 13:40
		Re: STATA codes to merge women and household datasets By: Isabelle on Sat, 24 August 2019 09:56
		Re: STATA codes to merge women and household datasets By: Bridgette-DHS on Tue, 03 September 2019 15:37
		Re: STATA codes to merge women and household datasets By: vpatil on Sun, 26 April 2020 00:54

Previous Topic:	SPA 2012-2017 Senegal
Next Topic:	sample weights in women file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Nov 4 07:17:57 Coordinated Universal Time 2025