The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Service Provision Assessment (SPA) » SPA variables
SPA variables [message #23354] Thu, 26 August 2021 14:09 Go to previous message
rhythm is currently offline  rhythm
Messages: 2
Registered: August 2021
I would like to create some variables using SPA surveys.
*Malawi SPA 2013-14: X ray machine (table 3.7.1)
gen wt=facwt/1000000
gen xm=0
replace xm=1 if (q881a_1==1 & q881b_1==1) | (q881a_2==1 & q881b_2==1)
tab xm [iw=wt]
With this codes, the % is 6.97, but in the report the % is 5.
*Nepal SPA 2015: Full blood count with differentials (table 3.7.3)
gen wt=facwt/1000000
keep if factype==inrange(factype,1,7) | inrange(factype,12,14)
gen fblcn=0
replace fblcn=1 if ((q834==1 & q835==1) | (q802eb_1==1 & q802ec_1==1 & q802eb_2==1 & q802eb_3==1 & q802ec_3==1))
tab fblcn [iw=wt]
With this codes, the % is 73.52, but in the report the % is 66.9.
According to the footnotes, and questionnaire it looks like I am using right variables, but due to some reasons I am not getting the same % as the final report tables.
I would greatly appreciate any help with this matter.

Many thanks
Read Message
Read Message
Read Message
Read Message
Previous Topic: Creating two variable
Next Topic: About one SPA variable
Goto Forum:

Current Time: Sat Oct 16 16:24:01 Coordinated Universal Time 2021