| Merge BR to PR [message #16733] |
Mon, 25 February 2019 12:10  |
NZurlinden
Messages: 2
Registered: February 2019
|
Member |
|
|
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!
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
