The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Merge BR to PR (Merge BR to PR files for all survey rounds in Africa)

Show: Today's Messages :: Show Polls :: Message Navigator

Re: Merge BR to PR [message #16837 is a reply to message #16733]

Thu, 07 March 2019 12:56

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

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.

Report message to a moderator

[Message index]

		Merge BR to PR By: NZurlinden on Mon, 25 February 2019 12:10
		Re: Merge BR to PR By: Bridgette-DHS on Thu, 07 March 2019 12:56
		Re: Merge BR to PR By: geoK on Mon, 13 May 2019 12:56

Previous Topic:	Merging Malawi MIS 2017 Datasets
Next Topic:	How to merge DLHS 4-Village data and DLHS 4-EW data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 12 06:38:25 Coordinated Universal Time 2025