2019 Senegal SPA dataset merging issue [message #27824] |
Fri, 06 October 2023 15:38 ![Go to next message Go to previous message](/theme/default/images/down.png) |
kgeorg7
Messages: 8 Registered: August 2022
|
Member |
|
|
Hi there,
In an attempt to obtain the 'urban/rural variable' at the facility level, for the 2019-Senegal-SPA-Provider dataset, I tried merging it with the 2019-Senegal-SPA-Facility dataset, using the facility identifier variable (facil). The 'facil' variable uniquely identifies facilities across the datasets, allowing to merge them. However, all the rural observations have missing values for the 2019-Senegal-SPA-Provider variables. Thus, it appears that only urban facility providers were included in the 2019-Senegal-SPA-Provider dataset, and I was wondering if this was by design? This is particularly confusing given that within the 2012-Senegal-SPA-Provider-Recode dataset, both, urban and rural observations are present.
I'm using a simple Stata code, as seen below:
use "SPA\2019\SNFP8ADTSP\SNFP8AFLSP.dta", clear
merge m:1 facil using "SPA\2019\SNFC8ADTSP\SNFC8AFLSP.dta"
Any help would be much appreciated!
Thank you in advance,
Kevin
|
|
|