The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » IPUMS Demographic and Health Surveys (IPUMS-DHS)  » Merging DHS with IPUMS-DHS to get harmonized districts
Re: Merging DHS with IPUMS-DHS to get harmonized districts [message #18885 is a reply to message #18855] Thu, 05 March 2020 05:40 Go to previous messageGo to previous message
Niranjana is currently offline  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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Melogit and Weights
Next Topic: IPUMS DHS 2015
Goto Forum:
  


Current Time: Thu Mar 28 15:46:19 Coordinated Universal Time 2024