The DHS Program User Forum: Merging data files » 2014 Kenya DHS merging household and men's datafile

Home » Data » Merging data files » 2014 Kenya DHS merging household and men's datafile

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

Re: 2014 Kenya DHS merging household and men's datafile [message #10141 is a reply to message #10140]

Thu, 30 June 2016 09:35

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Senior DHS Stata Specialist, Tom Pullum has provided the following Stata syntax:

use MRfile, clear
rename mv001 hv001
rename mv002 hv002
rename mv003 hvidx
sort hv001 hv002 hvidx
save MRtemp.dta, replace

use PRfile, clear
sort hv001 hv002 hvidx
merge hv001 hv002 hvidx using MRtemp.dta
tab _merge
keep if _merge==3
drop _merge

Report message to a moderator

[Message index]

		2014 Kenya DHS merging household and men's datafile By: laura on Thu, 30 June 2016 08:57
		Re: 2014 Kenya DHS merging household and men's datafile By: Bridgette-DHS on Thu, 30 June 2016 09:10
		Re: 2014 Kenya DHS merging household and men's datafile By: laura on Thu, 30 June 2016 09:12
		Re: 2014 Kenya DHS merging household and men's datafile By: Bridgette-DHS on Thu, 30 June 2016 09:35
		Re: 2014 Kenya DHS merging household and men's datafile By: laura on Thu, 30 June 2016 10:11
		Re: 2014 Kenya DHS merging household and men's datafile By: laura on Thu, 30 June 2016 11:02
		Re: 2014 Kenya DHS merging household and men's datafile By: Bridgette-DHS on Thu, 07 July 2016 10:11

Previous Topic:	Merging DHS Files
Next Topic:	Merging data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Nov 4 14:02:30 Coordinated Universal Time 2025