The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Service Provision Assessment (SPA) » Linking dataset in SPA_Ethiopia
Re: Linking dataset in SPA_Ethiopia [message #9420 is a reply to message #9416] Fri, 25 March 2016 10:50 Go to previous messageGo to previous message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dr. Wang responded:
Quote:

1) It is strange that provider id variable is not included in provider data and client data. It may have a different name and usually is labeled as "provider serial number".

2) yes, if you are merging provider data into facility data, you are dealing with one to many merging. In this cases, facility dataset is the master file and provider dataset is the using file.

3) Without access to the ESPA data, it is difficult to figure out the problem.
Please note when you merge provider data into facility data, the number of cases(facilities) in your master file (facility dataset) will proliferate because multiple provider records are associated with one facility. Maybe this causes the nth value no longer the same?



 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: merging SPA datasets: Kenya 2010
Next Topic: Kenya SPA 2010 - how to apply weights
Goto Forum:
  


Current Time: Wed Dec 11 23:36:17 Coordinated Universal Time 2024