SPA survey [message #23500] |
Wed, 29 September 2021 00:13 ![Go to next message Go to previous message](/theme/default/images/down.png) |
foysal
Messages: 9 Registered: August 2021
|
Member |
|
|
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?
Sincerely,
Foysal
|
|
|