The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Merging children from PR file with Mothers from IR file
Merging children from PR file with Mothers from IR file [message #13577] Wed, 22 November 2017 10:39 Go to next message
zshanawan is currently offline  zshanawan
Messages: 1
Registered: November 2017
Member
Hi, i am trying to merge children from PR file with their mothers from IR file in which can not be done successfully by using cluster id and household id because in some cases there are more than 1 woman (mother) from PR file living in same household. In IR file these mothers have different line numbers but same household number. Please suggest me any way out of merging this kind of data set.

Regards
Re: Merging children from PR file with Mothers from IR file [message #13707 is a reply to message #13577] Mon, 11 December 2017 13:48 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1485
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

To do this merge, you match hv001, hv002, hvidx in the PR file with v001, v002, v003 in the IR file.
Previous Topic: Postnatal checkup:Rwanda DHS 2014-15
Next Topic: Percent of postpartum women with unmet need for contraception
Goto Forum:
  


Current Time: Mon Oct 22 17:25:17 Eastern Daylight Time 2018