The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging Male with Birth data?
Merging Male with Birth data? [message #423] Sun, 12 May 2013 14:10 Go to next message
Seets is currently offline  Seets
Messages: 2
Registered: May 2013
Member
Hello,
I am using the Indian Birth data. I have merged the women's data successfully. Is there a way of doing this with the male data?
I am looking to have a merged dataset of births, with women's and male characteristics.

Please advice.
Re: Merging Male with Birth data? [message #464 is a reply to message #423] Wed, 22 May 2013 12:11 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member
For merging DHS datasets, please reference: http://www.measuredhs.com/data/Merging-Datasets.cfm
Re: Merging Male with Birth data? [message #25331 is a reply to message #423] Wed, 05 October 2022 13:30 Go to previous messageGo to next message
Sandipa is currently offline  Sandipa
Messages: 1
Registered: October 2022
Member
Hi,

Can someone help me with merging the child births with their parents information i.e. merging the IR, MR and BR file. I need information on the child and parental background information for my analysis. I checked the DHS forum for such a merge but I didn't find any great answer to this question. The merges are mainly concentrated within the household level i.e. PR file. I need my unit of observation as the child. And I need this information for both NFHS-4 and NFHS-5. I can append the two once I do the merging correctly. Below is the code I used. But I don't think that identifies correctly and uniquely the parents of the child.

IR file:

use "IAIR7BFL.dta", clear
gen in_IR=1
rename v001 hv001 /*Sample-specific cluster number*/
rename v002 hv002 /*Household number in cluster*/
rename v003 hvidx /*Household line number of woman respondent*/
gen mo_line=hvidx
sort hv001 hv002 mo_line

*kept all the variables I needed for the mother (ex: education, birth history etc)

MR file:

use "IAMR7BFL.dta", clear
gen in_MR=1
rename mv001 hv001
rename mv002 hv002
rename mv003 hvidx
gen fa_line=hvidx
sort hv001 hv002 fa_line

*kept all the variables I needed for the father (ex: education, birth history etc)

BR file:
use "IABR7BFL.dta", clear
keep if b5==1 /*Chlid is alive*/
gen in_BR=1
rename v001 hv001
rename v002 hv002
rename b16 hvidx
sort hv001 hv002 hvidx

*kept all the variables I needed for the child (ex: birth details etc)

Now how to uniquely match the child with their parents?


Re: Merging Male with Birth data? [message #25333 is a reply to message #25331] Wed, 05 October 2022 16:11 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member

Following is a response from DHS staff member, Tom Pullum:

The child records in the BR files already include almost all of the mother's information that is in the IR file. If you think some variables are missing and you still want to merge with the IR file, you match cases in the IR and BR with the same v024 v001 v002 v003 in both files. You keep if _merge==3.

Merging the BR and MR files is not a good idea. The first problem is that there was only a 1/6 subsampling of males from the PR file. 1/2 of the households in 1/3 of the clusters were selected for the men's survey. that means you could only match at most 1/6 of the children with their father. Second, you can only match with the father if both the child and the father were present the same household. You can find the child in the household by matching v024 v001 v002 v003 b16 in the BR file with hv024 hv001 hv002 hvidx in the PR file. The father's line number, if in the household, is hv114. You then merge hv024 hv001 hv002 hv114 with mv024 mv001 mv002 mv003 in the MR file. The code to merge children with fathers has been given elsewhere in the forum.

If you want children under 5, use the KR file rather than the BR file. If you use the BR file, the older children are less likely to be in the household. Both the KR and BR files include children who have died, and you will not find them in the household survey.
Previous Topic: Merging household level data set with men and women dataset
Next Topic: Merging KR with PR
Goto Forum:
  


Current Time: Fri Mar 29 11:18:25 Coordinated Universal Time 2024