The DHS Program User Forum: Service Provision Assessment (SPA) » 2019 Senegal SPA dataset merging issue

Home » Topics » Service Provision Assessment (SPA) » 2019 Senegal SPA dataset merging issue

Show: Today's Messages :: Show Polls :: Message Navigator

2019 Senegal SPA dataset merging issue [message #27824]

Fri, 06 October 2023 15:38

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

Report message to a moderator

[Message index]

		2019 Senegal SPA dataset merging issue By: kgeorg7 on Fri, 06 October 2023 15:38
		Re: 2019 Senegal SPA dataset merging issue By: SaraDHS on Mon, 09 October 2023 16:51

Previous Topic:	KEN SPA 2004-2005 RAW Variables
Next Topic:	How to create Facility Recode dataset from Facility Raw for BDHS 2017 SPA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 04:18:37 Coordinated Universal Time 2024