The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Service Provision Assessment (SPA) » merging SPA datasets: Kenya 2010
merging SPA datasets: Kenya 2010 [message #9074] Sat, 06 February 2016 14:59 Go to next message
catherine3h is currently offline  catherine3h
Messages: 10
Registered: February 2015
Location: United States
Member
I am conducting an analysis where I will need to merge three datasets from the Kenya SPA 2010: the ANC observations (KESR10AN), the provider interview (KESR10PV) and the facility/inventory dataset (KESR10FC). I am going to apply a hierarchical model to examine the predictors of providers offering a particular clinical service during ANC consultations, however, I am having trouble linking the datasets. I can merge the PV dataset and FC datasets because they have the common variable facility number. However, I cannot find a variable in the AN dataset that lists a unique provider ID for each consultation visit. How can I combine the AN and PV datasets? Thanks.
Re: merging SPA datasets: Kenya 2010 [message #9120 is a reply to message #9074] Fri, 12 February 2016 12:32 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
I am attaching 2 files (usually distributed with dataset). The Readme.doc file is generic for our SPA surveys. The KESP6B.DOC is specific to the Kenya 2010 SPA. The information contained in this document should answer your query. However, if it's not what you need, please feel free to post again. Thank you!
  • Attachment: KESP6B.DOC
    (Size: 29.00KB, Downloaded 601 times)
  • Attachment: README.DOC
    (Size: 36.50KB, Downloaded 563 times)
Re: merging SPA datasets: Kenya 2010 [message #9246 is a reply to message #9074] Fri, 26 February 2016 15:16 Go to previous messageGo to next message
catherine3h is currently offline  catherine3h
Messages: 10
Registered: February 2015
Location: United States
Member
Thank you for your message. I've reviewed these documents, however, I still cannot find the common variables to combine the AN and PV datasets as I described previously. Please advise. Thank you.
Re: merging SPA datasets: Kenya 2010 [message #9367 is a reply to message #9246] Mon, 21 March 2016 00:20 Go to previous message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
Response from data processing expert, Claudia Marchena:
Quote:

I don't know which program the user is using, I just opened data in SPSS. For AN I opened file KE10AN.SAV and for PV I opened data KE10PRV.SAV, to merge AN and PV the variables are FACIL and HLINE which are present in both files.

Please view the attachment with screenshots.
Previous Topic: Linking SPA & DHS data
Next Topic: Linking dataset in SPA_Ethiopia
Goto Forum:
  


Current Time: Thu Mar 28 11:33:18 Coordinated Universal Time 2024