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: 13
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: 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
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: 78
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 messageGo to next message
Niranjana is currently offline  Niranjana
Messages: 13
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,
Re: Merging DHS with IPUMS-DHS to get harmonized districts [message #22906 is a reply to message #18908] Wed, 02 June 2021 06:47 Go to previous messageGo to next message
Hassen
Messages: 121
Registered: April 2018
Location: Ethiopia,Africa
Senior Member
Dear Professor Elizabeth Boyle, How are you? I want to merge EDHS dataset (2019 Ethiopia Mini-DHS) into pooled IPUMS data (pooled data from 2011 & 2016 Ethiopia DHS using children as unit of analysis), so How can I do this? Importantly, I need to merge ETKR81DT Dataset into pooled IPUMS-DHS data (2011 & 2016 EDHS Data). Children is my unit of Analysis! I kindly request your response as soon as possible!
With Kind Regards, Hassen


Hassen Ali(Chief Public Health Professional Specialist)
Re: Merging DHS with IPUMS-DHS to get harmonized districts [message #22955 is a reply to message #22906] Thu, 10 June 2021 18:28 Go to previous message
boyle014 is currently offline  boyle014
Messages: 78
Registered: December 2015
Location: Minneapolis
Senior Member
Dear Hassen,

Thank you for your query. In general, it is not easy to combine IPUMS DHS with the original DHS data. If you come up with a good strategy for doing this, I hope you will share it on the Forum.

We are working to incorporate all the DHS data into IPUMS DHS, but it is a time-consuming process!


Professor Elizabeth Boyle
Sociology & Law, University of Minnesota, USA
Principal Investigator, IPUMS-DHS
Previous Topic: Melogit and Weights
Next Topic: IPUMS DHS 2015
Goto Forum:
  


Current Time: Thu Oct 3 08:57:51 Coordinated Universal Time 2024