| Merging DHS household Survey data with SPA data [message #28411] |
Mon, 01 January 2024 14:00  |
toukir86
Messages: 10
Registered: November 2023
|
Member |
|
|
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  |
SaraDHS
Messages: 46
Registered: December 2020
|
Member |
|
|
Hello,
There are multiple approaches to merging DHS and SPA data, and these are outlined in this report: https://dhsprogram.com/pubs/pdf/SAR10/SAR10.pdf
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
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
