The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merge BR to PR (Merge BR to PR files for all survey rounds in Africa)
Merge BR to PR [message #16733] Mon, 25 February 2019 12:10 Go to previous message
NZurlinden is currently offline  NZurlinden
Messages: 2
Registered: February 2019
I work with all survey rounds in Africa. I want to merge the BR files to the PR files, but many children from BR are not merged to PR. I have looked at all posts in this forum related to merges, but have not found any solution to my problem.
From BR, I use caseid (and change it to hhid by stripping the last two characters), v003 (respondent's line number) and b16 (child's line number). From PR, I use hhid, hv003 (respondent's line number), and hvidx (child's line number). (Additionally, I have a unique identifier for the survey round). I exclude all cases with b16==. or b16==0 from the BR files.
I merge the BR to the PR files using the unique identifiers mentioned above.
I have around 2 mio children in my BR files. However, only around 1 mio are merged to the PR files.
I merged the two files only using hhid (dropping any duplicates), and most observations were merged hence, the problem is most likely not hhid.
I need to merge the BR to the PR files, because there are some variables that are not in the PR files, such as whether the child is a twin (b0), and the preceding birth interval (b11).
Does anyone have experience with merging BR to PR files, some possible solutions, or explanations why the merge does not work for so many children? Any hint would be much appreciated!
Many thanks!
Read Message
Read Message
Read Message
Previous Topic: Merging Malawi MIS 2017 Datasets
Next Topic: How to merge DLHS 4-Village data and DLHS 4-EW data
Goto Forum:

Current Time: Fri Apr 3 05:54:41 Eastern Daylight Time 2020