The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Service Provision Assessment (SPA) » SPA survey
SPA survey [message #23500] Wed, 29 September 2021 00:13 Go to previous message
foysal is currently offline  foysal
Messages: 9
Registered: August 2021
Dear Sara,
Hope you are well.
I want to create a variable named quality assurance activities (o=no, 1=yes) using Malawi SPA 2013-14. I have tried with the following codes in STATA:

tab sw=facwt/10000000
(83 missing values generated)

tab q440 [iw=sw],m

routine qa activities freq. percent
yes 472.936149 48.41
no 496.102203 50.78
don't know 7.9616701 0.81
total 977.000022 100.00

tab q441 [iw=sw],m

official records of qa activities in past year freq. percent
yes 276.25236 28.28
no records not maintained 196.683789 20.13
. 504.063873 51.59
total 977.000022 100.00

tab q442 [iw=sw],m

official records of qa activities in past year-observed freq. percent
observed 132.525358 13.56
reported, not seen 143.727002 14.71
. 700.747661 71.72
total 977.000022 100.00

From the variable q442, it is clear to me that only 13.56% facilities routinely carries out quality assurance activities and had documentation of a recent quality assurance activity. But my question refers to the percentage of facilities having no quality assurance activities. Will I count all missing facilities (n=700.747661) in q442 as "having No quality assurance activities" (i.e. merge with category "reported, not seen") rather than as missing values?
If I count all missing values and merge with category 2 (reported, not seen) then the percentage of facilities having no quality assurance activities would be 86.44%. Is it correct?
If I consider all missing facilities as "No" category, then would it be draw any misleading conclusion particularly in statistical modelling?
I would appreciate any help with this matter?


Read Message
Read Message
Read Message
Read Message
Previous Topic: Replicating Table
Next Topic: Senegal SPA district and arrondissement information
Goto Forum:

Current Time: Mon Jul 15 04:39:39 Coordinated Universal Time 2024