| Re: Replicating table in DR Congo SPA 2017-18 [message #23330 is a reply to message #23324] |
Tue, 24 August 2021 15:02   |
foysal
Messages: 9
Registered: August 2021
|
Member |
|
|
Dear Sara,
Thanks a lot for your help. I was able to match only the "high level disinfection" and "x ray machine" variable with the report table. The other variables codes as well as the output is given below:
gen sw=facwt/1000000
*Electricity
gen ect=0
replace ect=1 if q340==1 & q341==1
replace ect=1 if regexm(q343, "A") & q345==1 & q346==1
replace ect=1 if regexm(q343, "B") & q345==1 & q346==1
replace ect=1 if regexm(q343, "D") & q345==1
replace ect=1 if regexm(q343, "C")
tab ect [iw=sw]
ect Freq. Percent Cum.
------------+-----------------------------------
0 | 460.671274 33.38 33.38
1 | 919.328581 66.62 100.00
------------+-----------------------------------
Total | 1,379.9999 100.00
where in the report the percentage is 65 (table 3.3).
*Sterilization
gen ster=0
replace ster=1 if (q201==1 | q201==2) & ((q501a_03==1 & q501b_03==1) | (q501a_05==1 & q501b_05==1) | (q501a_06==1 & q501a_07==1 & q501b_07==1))
tab ster [iw=sw]
ster | Freq. Percent Cum.
------------+-----------------------------------
0 | 1,168.4817 84.67 84.67
1 | 211.518143 15.33 100.00
------------+-----------------------------------
Total | 1,379.9999 100.00
the final report table percentage is 14 (table 3.7.1).
Please help me to get the same percentage as the tables.
Regards,
Foysal
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
