The DHS Program User Forum: Merging data files » Merging Birth and Household Recodes

Home » Data » Merging data files » Merging Birth and Household Recodes

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

Re: Merging Birth and Household Recodes [message #9518 is a reply to message #9498]

Thu, 07 April 2016 14:23

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

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

To merge the BR (or KR) file with the household file, you need to use the cluster id, household id, and line number. In the BR (or KR) file, the line number of the child, if in the household, is b16.

The following lines will work for either the DRC 2007 survey or the DRC 2013-14 survey. Just change the paths and add in the other variables you want to have in the merged file.

There are a few surveys from other countries where there is a sub-household id that must also be matched on. The best way to find that is to see whether hhid (a string) corresponds with hv001 and hv002. If there is something else embedded in hhid, you must extract it with the substring command, and also extract it from caseid in the IR/BE/KR file, and include it in the sort and merge lines. However, these two DRC surveys do not include sub-households.

* MERGE THE BR AND PR FILES FROM THE 2007 DRC SURVEY

use e:\DHS\DHS_data\PR_files\CDPR50FL.dta, clear
keep hhid hv001 hv002 hvidx
sort hv001 hv002 hvidx
save e:\DHS\DHS_data\scratch\temp.dta, replace

use e:\DHS\DHS_data\BR_files\CDBR50FL.dta, clear
list caseid v001 v002 v003 b16 if _n<=20, table clean
keep caseid v001 v002 v003 b16
rename v001 hv001
rename v002 hv002
rename b16 hvidx
sort hv001 hv002 hvidx
merge hv001 hv002 hvidx using e:\DHS\DHS_data\scratch\temp.dta

* This match works fine

* MERGE THE BR AND PR FILES FROM THE 2013-14 DRC SURVEY

use e:\DHS\DHS_data\PR_files\CDPR61FL.dta, clear
keep hhid hv001 hv002 hvidx
sort hv001 hv002 hvidx
save e:\DHS\DHS_data\scratch\temp.dta, replace

use e:\DHS\DHS_data\BR_files\CDBR61FL.dta, clear
list caseid v001 v002 v003 b16 if _n<=20, table clean
keep caseid v001 v002 v003 b16
rename v001 hv001
rename v002 hv002
rename b16 hvidx
sort hv001 hv002 hvidx
merge hv001 hv002 hvidx using e:\DHS\DHS_data\scratch\temp.dta

* This match works fine

Report message to a moderator

[Message index]

		Merging Birth and Household Recodes By: cbdolan on Tue, 05 April 2016 09:47
		Re: Merging Birth and Household Recodes By: Bridgette-DHS on Thu, 07 April 2016 14:23
		Re: Merging Birth and Household Recodes By: cbdolan on Thu, 07 April 2016 16:14
		Re: Merging Birth and Household Recodes By: Bridgette-DHS on Fri, 08 April 2016 13:27
		Re: Merging Birth and Household Recodes By: Bridgette-DHS on Fri, 15 April 2016 07:29
		Re: Merging Birth and Household Recodes By: Bridgette-DHS on Fri, 15 April 2016 07:34
		Re: Merging Birth and Household Recodes By: cbdolan on Fri, 15 April 2016 11:16

Previous Topic:	Couples and HIV merge in STATA
Next Topic:	Merging Children with Household

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Dec 22 16:33:26 Coordinated Universal Time 2024