The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Nambia DHS 2013 - merging problem
Nambia DHS 2013 - merging problem [message #11882] Fri, 24 February 2017 05:45 Go to next message
Christian Bommer is currently offline  Christian Bommer
Messages: 13
Registered: June 2015
Member
Dear DHS team,

I tried to merge data from the individual recode (IR) file to the household recode (HR) file from Namibia DHS 2013 using Stata 14. The merging works in the sense that all individuals from the IR file find a match but 3177 households are not matched. The response rate of women as reported in the final report was above 90%, so this shouldn't be the reason. I am facing similar problems when merging the HR file to the birth recode (BR) file or when first appending the IR file and the men recode (MR) file and then merging both to the HR file. Oddly, when I tried to merge the HR file to the household member (PR) file it worked without problems (i.e. every household member has a match). Here is my Stata code:

local imported_vars v024 v025 v026 // just an example

use "NMHR61FL.dta", clear

rename hv001 v001
rename hv002 v002

merge 1:m v001 v002 using "NMIR61FL.dta", keepusing(`imported_vars') // apparently not all households are in individual dataset


Could you please tell me where my mistake is?

Kind regards
Christian
Re: Nambia DHS 2013 - merging problem [message #11884 is a reply to message #11882] Fri, 24 February 2017 11:23 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

Remember that the IR file consists only of women age 15-49. If there is no woman in that age range in the household, you will not get a match between the HR and IR file. In NMHR61FL.dta, hv010 is the number of eligible women in the household. This number is 0 in 2889 (29.33%) of the households. Taking into account the response rate for the women, 3177 unmatched households seems about right.

Re: Nambia DHS 2013 - merging problem [message #11887 is a reply to message #11884] Sat, 25 February 2017 10:20 Go to previous message
Christian Bommer is currently offline  Christian Bommer
Messages: 13
Registered: June 2015
Member
Great, thank you for your reply!
Previous Topic: Dominican Republic - DHS 2013 - Variable sh75a?
Next Topic: Jordan 2012, ethical approval
Goto Forum:
  


Current Time: Thu Mar 28 14:39:35 Coordinated Universal Time 2024