The DHS Program User Forum: Merging data files » Merge Other Biomarkers with HH

Home » Data » Merging data files » Merge Other Biomarkers with HH (URGENT)

Show: Today's Messages :: Show Polls :: Message Navigator

Merge Other Biomarkers with HH [message #24767]

Thu, 07 July 2022 06:15

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

[Message index]

		Merge Other Biomarkers with HH By: mer99 on Thu, 07 July 2022 06:15
		Re: Merge Other Biomarkers with HH By: Janet-DHS on Mon, 11 July 2022 10:12

Previous Topic:	Struggling with merging Senegal KR data file to mother's file
Next Topic:	IR + MR or CR + IR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 29 18:18:57 Coordinated Universal Time 2024