The DHS Program User Forum: IPUMS Demographic and Health Surveys (IPUMS-DHS) » Merging DHS with IPUMS-DHS to get harmonized districts

Home » Data » IPUMS Demographic and Health Surveys (IPUMS-DHS) » Merging DHS with IPUMS-DHS to get harmonized districts

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

Re: Merging DHS with IPUMS-DHS to get harmonized districts [message #18885 is a reply to message #18855]

Thu, 05 March 2020 05:40

Niranjana
Messages: 13
Registered: October 2019

Member

Hi Everyone,

I figured out how to merge the two datasets:


*Use IPUMS-DHS data to merge district information
use "$dropbox/raw_extracted/idhs_00001.dta"
gen id =_n
sort year caseid linenohhresp
by year caseid linenohhresp: gen newid = 1 if _n==1
replace newid = sum(newid)
replace newid = . if missing(caseid)
duplicates report newid
merge 1:m newid using "$dropbox/cleaning/brpanel.dta", force // this is the cleaned birth recode data I am using from DHS 
drop if _m==1

I hope this helps.

Best,
Niranjana

Report message to a moderator

[Message index]

		Merging DHS with IPUMS-DHS to get harmonized districts By: Niranjana on Mon, 02 March 2020 05:57
		Re: Merging DHS with IPUMS-DHS to get harmonized districts By: Niranjana on Thu, 05 March 2020 05:40
		Re: Merging DHS with IPUMS-DHS to get harmonized districts By: boyle014 on Tue, 10 March 2020 18:57
		Re: Merging DHS with IPUMS-DHS to get harmonized districts By: Niranjana on Fri, 13 March 2020 06:30
		Re: Merging DHS with IPUMS-DHS to get harmonized districts By: Hassen on Wed, 02 June 2021 06:47
		Re: Merging DHS with IPUMS-DHS to get harmonized districts By: boyle014 on Thu, 10 June 2021 18:28

Previous Topic:	Melogit and Weights
Next Topic:	IPUMS DHS 2015

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 25 01:27:57 Coordinated Universal Time 2024