The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging BR file with PR file for NFHS-4 round(India) (Merging BR and PR)
Re: Merging BR file with PR file for NFHS-4 round(India) [message #17856 is a reply to message #17839] Wed, 26 June 2019 20:25 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1959
Registered: February 2013
Senior Member

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

You are getting a large number of unmatched cases because you do not have any restrictions on age. The cases with _merge=1 are household members who do not appear in the birth histories--obviously the great majority of household members. The cases with _merge=2 are "children" in the birth histories who can be up to 30-34 years old, and not in the same household as their mother. If the child is missing on b16, it is because he/she has died. If b16 is =, then the child is living but not in the household.

It would be reasonable to impose an age limit such as 4 or 14 or 17 and to omit children who have died.

I don't see anything wrong with your Stata code.

Read Message
Read Message
Read Message
Read Message
Previous Topic: Merging IR and BR
Next Topic: Merge WI to KR in Mali
Goto Forum:

Current Time: Tue Oct 20 05:13:12 Eastern Daylight Time 2020