The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Service Provision Assessment (SPA) » Replicating table 6.4 and 6.6 of Bangladesh SPA 2017 (2017 SPA Bangladesh)
Replicating table 6.4 and 6.6 of Bangladesh SPA 2017 [message #22139] Fri, 05 February 2021 21:27 Go to previous message
shakim is currently offline  shakim
Messages: 10
Registered: January 2021
Member
Dear Bridgette and SPA experts,

I am trying to replicate table 6.4 of Bangladesh SPA 2017 report (page 106). I was able to match the percentage of combined iron and folic acid tablets but unable to match the percentage of iron tablet, folic acid tablet, and iron/folic acid tablet with the report. I have tried in the following way in STATA:

*iron tablet
gen iron=0
replace iron=1 if (Q1422_1==1 | (Q210==1 & Q906_03==1))

*folic acid tablet
gen folic=0
replace folic=1 if (Q1422_2==1 | (Q210==1 & Q906_02==1))

*iron or folic acid tablet
gen ir_fol=0
replace ir_fol=1 if (Q1422_1==1 | Q1422_2==2) | (Q210==1 & (Q906_02==1 | Q906_03==1))

Please also help me how can I prepare the the readiness score of table 6.6 (page 108) by combining 6 items.

Thanks for your attention.

 
Read Message
Read Message
Previous Topic: Bangladesh Health Facility Survey 2017
Next Topic: Aggregating data from facility to Province level
Goto Forum:
  


Current Time: Thu Dec 12 21:13:05 Coordinated Universal Time 2024