Merge Other Biomarkers with HH [message #24767] |
Thu, 07 July 2022 06:15 ![Go to next message Go to previous message](/theme/default/images/down.png) |
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
|
|
|