The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Bangladesh » Merging DHS household Survey data with SPA data (Merging DHS Survey data and SPA Facility Surveys data)
Merging DHS household Survey data with SPA data [message #28411] Mon, 01 January 2024 14:00 Go to next message
toukir86 is currently offline  toukir86
Messages: 7
Registered: November 2023
Hello everyone,
I am wondering about a topic. Is there any way to merge the survey dataset with the SPA dataset in STATA? Suppose I like to merge the BDHS17-18's Women data (IR) file with the Bangladesh 2017 SPA dataset's Facility dataset (FC).

Thanks in advance.
Re: Merging DHS household Survey data with SPA data [message #28433 is a reply to message #28411] Thu, 04 January 2024 15:53 Go to previous message
SaraDHS is currently offline  SaraDHS
Messages: 44
Registered: December 2020
There are multiple approaches to merging DHS and SPA data, and these are outlined in this report:

Your approach would depend on your research question. The simplest approach is to create regional estimates for the SPA and DHS variables that you are interested in and then merge the two regional-level datasets. You can do this in Stata by opening the regionally aggregated SPA dataset, and then using merge 1:1 region using IR_region.dta, if you have renamed the regionally aggregated DHS IR dataset IR_region.dta.

There are other more complicated approaches that you could use. You could assign a summary SPA value, estimated based on some defined service environment, to the DHS cluster or an individual or household. The most complicated approach would be to use geospatial estimates of DHS or SPA data to link the two. Each of these approached is described in the SAR above.

Best of luck!

Sara Riese, PhD Senior Demographic and Health Researcher, DHS Program
Previous Topic: Replicating BDHS 2011 Table 15.5.1 & 15.5.2 Table on Diabetes prevalence
Next Topic: HAZ, WAZ, and WHZ calculation to measure stunting, wasting, and underweight of children
Goto Forum:

Current Time: Fri Jun 21 01:23:07 Coordinated Universal Time 2024