The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merge Other Biomarkers with HH (URGENT)
Merge Other Biomarkers with HH [message #24767] Thu, 07 July 2022 06:15 Go to next message
mer99 is currently offline  mer99
Messages: 1
Registered: July 2022
Member
Good evening,

I am trying to merge all Other Biomarkers dataset (from men, children and women) from Malawi 2015-2016 into the Household Dataset. I have used append to unify all four Other Biomarkers datasets, and then merged them into the HH dataset by using the following code:

gen mcluster = hv001
gen mnumber = hv002
gen m01 = hv003

sort mcluster mnumber m01

* merge mother's characteristics into PR file
merge m:1 mcluster mnumber m01 using "`secondary'", keep(master match)


However, all I get are duplicates and I am not sure at all of what I am doing wrong. If anyone could help me with this I would be quite grateful. Thank you!

[Updated on: Thu, 07 July 2022 06:15]

Report message to a moderator

Re: Merge Other Biomarkers with HH [message #24785 is a reply to message #24767] Mon, 11 July 2022 10:12 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 658
Registered: April 2022
Senior Member
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

In the PR file, hv003 is the line number of the household respondent. It is the same for everyone in the household because it identifies the one person who answered the questions in the household interview. The line number of individuals in the household is hvidx. For children, the line number of the mother is given by hv112. I can't be more specific because you didn't say what survey you are using that has an "Other Biomarkers" file.
Previous Topic: Struggling with merging Senegal KR data file to mother's file
Next Topic: IR + MR or CR + IR
Goto Forum:
  


Current Time: Thu Mar 28 14:21:59 Coordinated Universal Time 2024