The DHS Program User Forum: Merging data files » How to merge a person-level data with a child-level data

Home » Data » Merging data files » How to merge a person-level data with a child-level data

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

Re: How to merge a person-level data with a child-level data [message #20011 is a reply to message #20008]

Tue, 15 September 2020 07:53

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

Is your "dataset A" the HR file? If so, it will be much easier if you use the PR file, which is already equivalent to a reshaped (long) HR file. You can then just merge the PR and BR files. In the BR file, the line number of the child is b16. This corresponds to hvidx in the PR file.

If you reshaped (long) the HR file, which as I said is not necessary, the person-level index you are asking about would be hvidx.

The BR file contains children of all ages as well as children who have died. Therefore when you do a PR/BR merge there will be many BR cases that are not in the PR file.

Report message to a moderator

[Message index]

		How to merge a person-level data with a child-level data By: ojh798 on Tue, 15 September 2020 02:28
		Re: How to merge a person-level data with a child-level data By: Bridgette-DHS on Tue, 15 September 2020 07:53
		Re: How to merge a person-level data with a child-level data By: ojh798 on Tue, 15 September 2020 15:13

Previous Topic:	Merging IR and PR 2016 UDHS
Next Topic:	Merging Couple File with KR File NFHS-4 (India)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Aug 27 13:32:20 Coordinated Universal Time 2025