The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Mortality » Merging BR & IR Files PDHS 2017-18 (STATA 13)
Merging BR & IR Files PDHS 2017-18 (STATA 13) [message #21660] Sat, 05 December 2020 11:02 Go to next message
shujaat.smc@gmail.com is currently offline  shujaat.smc@gmail.com
Messages: 75
Registered: July 2020
Senior Member
Dear DHS representative,

In your response to my question about how to generate the Mother's Age at most recent birth, I used the IR file and create the variable accordingly. (STATA 13)


I watched a video on youtube in which the merging of two DHS files was done on v001 & v002. The tutor said, there should be no duplicates when we use these two variables simultaneously ie: (my stata command as the example below)

merge 1:m v001 v002 AgeofMOOm using "file location to be mereged"

However, before merging I checked for duplicates for V001 & V002 simultaneously (as taught in that tutorial) and found that there are duplicates.


On my attempt to do so using the following command: merge 1:m v001 v002 using "/Users/syed Hussain/Documents/Workig Directory for Stata/All Neonatal Data Asse sment/Merging Files /Merge Parent BR PK 6 Region Data .dta"


I got this message from STATA:

"variables v001 v002 do not uniquely identify observations in the master data"


Question: Kindly tell me how I should merge the mother's age at the time of most recent birth present in the IR file to my main file on which I am doing analysis (BR file) in presence of duplicates in v001 & v002.


Waiting for your response.


Best Regards

Dr. Hussain

[Updated on: Mon, 07 December 2020 08:53] by Moderator

Report message to a moderator

Re: Merging BR & IR Files PDHS 2017-18 (STATA 13) [message #21676 is a reply to message #21660] Mon, 07 December 2020 14:08 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2537
Registered: February 2013
Senior Member

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

You do not need to do a merge. The KR and BR files include the mother's age and her cmc of birth (v011). At the time of the child's birth (b3) the mother's age in months is b3-v011. You can convert that to single years of age with int((b3-v011)/12).

Re: Merging BR & IR Files PDHS 2017-18 (STATA 13) [message #21677 is a reply to message #21676] Mon, 07 December 2020 14:15 Go to previous message
shujaat.smc@gmail.com is currently offline  shujaat.smc@gmail.com
Messages: 75
Registered: July 2020
Senior Member
Dear Tom Pullum,

Thanks a lot.

Best Regards

Dr. Hussain
Previous Topic: Portion of Newborns that were weighted at time of Delivery
Next Topic: Days of Neonatal Death Not Matching to DHS Further Analysis Report
Goto Forum:
  


Current Time: Tue Jun 28 04:58:06 Coordinated Universal Time 2022