The DHS Program User Forum: Merging data files » Merging Individual and HH Member Recode Files

Home » Data » Merging data files » Merging Individual and HH Member Recode Files

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

Re: Merging Individual and HH Member Recode Files [message #10574 is a reply to message #10524]

Thu, 11 August 2016 16:07

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Another response from Senior DHS Specialist, Shea Rutstein:

In 2012 and perhaps other years, there is an additional variable, hv002a, which identifies a separate household within the same dwelling (found during interviewing, such as another structure or the same structure in back with a separate entrance). This would seem to be the reason for duplicates.

From the individual survey data, hhid should match the hhid in the household data, then the specific household members record hvidx should match v003 from the individual file (not hv003 in the HH). Another way would be to create a variable by concatenating hvidx to the end of hhid in the household data file. This would match caseid in the individual file. Of course there are many more members of the household than interviewed women (only women 15-49 who slept the night before and were successfully interviewed are in the individual file).

I would NOT perform the matching on a pooled file. I would do it year by year and then pool.

Report message to a moderator

[Message index]

		Merging Individual and HH Member Recode Files By: amw289 on Tue, 26 July 2016 15:37
		Re: Merging Individual and HH Member Recode Files By: Bridgette-DHS on Wed, 27 July 2016 17:12
		Re: Merging Individual and HH Member Recode Files By: amw289 on Sun, 31 July 2016 12:02
		Re: Merging Individual and HH Member Recode Files By: Bridgette-DHS on Mon, 01 August 2016 12:04
		Re: Merging Individual and HH Member Recode Files By: amw289 on Tue, 02 August 2016 12:05
		Re: Merging Individual and HH Member Recode Files By: Bridgette-DHS on Thu, 11 August 2016 16:07
		Re: Merging Individual and HH Member Recode Files By: amw289 on Tue, 16 August 2016 10:02
		Re: Merging Individual and HH Member Recode Files By: Bridgette-DHS on Tue, 16 August 2016 12:13
		Re: Merging Individual and HH Member Recode Files By: amw289 on Tue, 16 August 2016 12:36
		Re: Merging Individual and HH Member Recode Files By: rayhangog@gmail.com on Thu, 25 January 2018 12:55
		Re: Merging Individual and HH Member Recode Files By: Bridgette-DHS on Sun, 28 January 2018 14:49
		Re: Merging Individual and HH Member Recode Files By: rayhangog@gmail.com on Sun, 28 January 2018 15:10

Previous Topic:	Merging Rwanda DHS 1992 without b16
Next Topic:	NFHS 4 Data (Merging of PR and KR data file)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jul 17 18:00:15 Coordinated Universal Time 2025