The DHS Program User Forum: Dataset use in Stata » merging wealth index from Ethiopia DHS 2000 to women's file

Home » Data » Dataset use in Stata » merging wealth index from Ethiopia DHS 2000 to women's file

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

Re: merging wealth index from Ethiopia DHS 2000 to women's file [message #13321 is a reply to message #13319]

Wed, 18 October 2017 08:34

Bridgette-DHS
Messages: 3202
Registered: February 2013

Senior Member

Another response from one of our STATA experts, Tom Pullum:

If you look at hhid in BFWI31FL.dta and compare it with caseid in BFBR31FL.dta, you will see that hhid matches the first 12 (out of 15) characters in caseid. (The last 3 characters in caseid are a blank and the mother's line number). The following lines will do the merge if you change the paths to the data files. I am using an old version of the merge command, which I prefer.

use e:\DHS\DHS_data\BR_files\BFBR31FL.dta, clear
gen hhid=substr(caseid,1,12)
sort hhid
save e:\DHS\DHS_data\scratch\temp.dta, replace

use e:\DHS\DHS_data\WI_files\BFWI31FL.dta, clear
rename whhid hhid
sort hhid
merge hhid using e:\DHS\DHS_data\scratch\temp.dta
tab _merge
keep if _merge==3
drop _merge

Report message to a moderator

[Message index]

		merging wealth index from Ethiopia DHS 2000 to women's file By: alex on Wed, 20 March 2013 00:22
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Bridgette-DHS on Fri, 22 March 2013 13:47
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: alex on Mon, 25 March 2013 07:39
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Bridgette-DHS on Mon, 25 March 2013 08:29
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: acp49 on Tue, 17 October 2017 15:58
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Bridgette-DHS on Wed, 18 October 2017 08:34
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Hassen on Sat, 05 May 2018 07:11
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: cdt_8289 on Mon, 29 July 2013 14:57
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Bridgette-DHS on Mon, 12 August 2013 12:21
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Markos Mezmur on Thu, 26 March 2015 05:22
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Trevor-DHS on Sat, 11 April 2015 17:43
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Trevor-DHS on Tue, 17 October 2017 18:16

Previous Topic:	Hypertension in Nepal
Next Topic:	Keeping caseid in and keeping missing observations out when using Stata "collapse"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Dec 2 16:05:56 Coordinated Universal Time 2024