The DHS Program User Forum: Service Provision Assessment (SPA)

Home » Topics » Service Provision Assessment (SPA) » KEN SPA 2004-2005 RAW Variables

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

KEN SPA 2004-2005 RAW Variables [message #27702]

Fri, 22 September 2023 15:13

IHME
Messages: 11
Registered: October 2017

Member

Hello,

In reviewing the raw facility file KEFCM5AFLSP.DTA, we found some variables that don't appear to be included in the combined/recoded FAC file (KEFC5BFLSR.DTA). Can you provide more information about whether/where the variables a1521_9 and a1521_11 appear in the recoded file?

Thank you,
Jessica Mihalik
IHME

Report message to a moderator

Re: KEN SPA 2004-2005 RAW Variables [message #27720 is a reply to message #27702]

Mon, 25 September 2023 17:01

Janet-DHS
Messages: 893
Registered: April 2022

Senior Member

Following is a response from Senior Data Processing Specialist, Claudia Marchena:

I have identified a match between the raw and the recode for the variables you are looking for, assuming these variables are the ones from the Delivery and Newborn Service Section (I believe the infection control items are for the Delivery and Newborn Service Section inside the Inventory Questionnaire). Here are my findings:

• A1521_9 "Hand-washing soap" from KEFCM5AFLSP is found in the recode in variable V531C ((KEFC5BFLSR).

• A1521_11 "Water for hand washing" from KEFCM5AFLSP.DTA is found in the recode file in three variables, V531A, V531A1, and V531B (KEFC5BFLSR), because it is constructed by recoding it together with I522. Adding these three variables together will get the sum of A1521_11.

As you continue with your analysis, please reference the Excel map file (within the .zip file you downloaded) for details on recoding of the variables between the raw and the recode data files. In this case it was difficult to find, because in this file (KEFCM5AFLSP) the variable was named "A1521" but it is named I521A(9) in the Excel mapping file (like it is in the instrument/questionnaire).

/index.php?t=getfile&id=2155&private=0

Attachment: message #27702.png
(Size: 11.47KB, Downloaded 196 times)

[Updated on: Tue, 26 September 2023 14:43] by Moderator

Report message to a moderator

Re: KEN SPA 2004-2005 RAW Variables [message #27740 is a reply to message #27720]

Wed, 27 September 2023 14:13

IHME
Messages: 11
Registered: October 2017

Member

Hi Janet and Claudia,

Thank you so much for this research and for finding the match, I appreciate your help!

Jessica Mihalik

[Updated on: Wed, 27 September 2023 14:28]

Report message to a moderator

Re: KEN SPA 2004-2005 RAW Variables [message #27741 is a reply to message #27740]

Wed, 27 September 2023 14:29

IHME
Messages: 11
Registered: October 2017

Member

There is one more group of variables I haven't been able to locate in any of the recoded files or the Excel map file- the geolocation variables (latdir, latdeg, latdec, longdir, longdeg, and longdec). Are these available in the recoded version?

Thank you,

Jessica

Report message to a moderator

Previous Topic:	Variable Labels for 2019 Senegal SPA data
Next Topic:	2019 Senegal SPA dataset merging issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 03:29:25 Coordinated Universal Time 2024