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
Merging DHS with IPUMS-DHS to get harmonized districts [message #18855] Mon, 02 March 2020 05:57 Go to next message
Niranjana is currently offline  Niranjana
Messages: 10
Registered: October 2019
Member
Hi Everyone,

I am working with rounds 1 & 2 of DHS women's module from India. I recently found out that IPUMS - DHS has harmonized all districts in the country across all waves, I was hoping to merge the district information with my already cleaned master data that I have been working on. Is there anyway to go about this? Thank you.

Best,
Niranjana
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 next message
Niranjana is currently offline  Niranjana
Messages: 10
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
Re: Merging DHS with IPUMS-DHS to get harmonized districts [message #18904 is a reply to message #18885] Tue, 10 March 2020 18:57 Go to previous messageGo to next message
boyle014 is currently offline  boyle014
Messages: 73
Registered: December 2015
Location: Minneapolis
Senior Member
Dear Niranjana,

Great that you created this workaround.

In general, I'd recommend using IPUMS DHS for all the variables though. You can search by DHS variable name, so it's pretty easy to find the variables you need for your analysis. If you select on "My Data," it's also easy to quickly add any variables if you miss a couple in the first pass.

Good luck with your research!


Professor Elizabeth Boyle
Sociology & Law, University of Minnesota, USA
Principal Investigator, IPUMS-DHS
Re: Merging DHS with IPUMS-DHS to get harmonized districts [message #18908 is a reply to message #18904] Fri, 13 March 2020 06:30 Go to previous message
Niranjana is currently offline  Niranjana
Messages: 10
Registered: October 2019
Member
Dear Prof. Boyle,

The reason behind the work around was that I have been working on the DHS dataset for several months now and downloading all variables from IPUMS-DHS would be a bit time consuming in the site's current format and would require me to rewrite existing code to match the variable names.

I have a question with regards to the districtia variable from the 1992-93 wave of Indian IPUMS-DHS -- I cannot find any codebook on the district names. For example, I know for certain that districts 201, 202.. belong to the state of Andhra Pradesh but for me to be able to plot this spatially in GIS I need the names of the District. Do you know where in the IPUMS data repository I could find that information? Thank you.

Best regards,
Previous Topic: What becomes of DHS weights after region harmonization by IPUMS-DHS
Goto Forum:
  


Current Time: Fri Apr 10 00:47:16 Eastern Daylight Time 2020