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

Merging DHS with IPUMS-DHS to get harmonized districts [message #18855]

Mon, 02 March 2020 05:57

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

Report message to a moderator

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:

Code: [Select all] [Show/ hide]

*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

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

Tue, 10 March 2020 18:57

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

Report message to a moderator

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

Fri, 13 March 2020 06:30

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,

Report message to a moderator

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

Wed, 02 June 2021 06:47

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)

Report message to a moderator

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

Thu, 10 June 2021 18:28

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat May 10 08:44:29 Coordinated Universal Time 2025