The DHS Program User Forum - RDF feed
https://userforum.dhsprogram.com/index.php
Merge BR to PR
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=16733&th=7799#msg_16733
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!
]]>NZurlinden2019-02-25T17:10:25-00:00Re: Merge BR to PR
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=16837&th=7799#msg_16837
Following is a response from Senior DHS Stata Specialist, Tom Pullum:
You want to match hv001 hv002 hvidx in the PR file with v001 v002 b16 in the BR file. No need to involve hhid or v003. Things to look out for: hv000/v000 is not a unique identifier of a survey; and some surveys in some countries in Francophone Africa have sub-household identifiers.
The BR file includes all the children ever born. Some of them can be 30+ years old. Children with b16=0 or b16=. have died or are not in the same household as the mother. There are MANY such children if you use the BR file.
As a secondary matter I recommend reducing the PR file to the variables you need. Otherwise you will be carrying along a lot of duplicated information.
]]>Bridgette-DHS2019-03-07T17:56:48-00:00Re: Merge BR to PR
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=17719&th=7799#msg_17719
geoK2019-05-13T16:56:40-00:00