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 Fri, 05 February 2021 21:27
 shakim Messages: 2Registered: 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.

Re: Replicating table 6.4 and 6.6 of Bangladesh SPA 2017 [message #22213 is a reply to message #22139] Fri, 12 February 2021 18:32
 Bridgette-DHS Messages: 2277Registered: February 2013 Senior Member

Following is a response from Senior SPA Specialist, Rajendra Dangol:

Here are the variables used in table 6.4 and logic in CsPro:

```if (Q1422(1)=1 or Q1422(3)=1) or (Q210=1 & (Q906(3)=1 or Q906(4)=1)) then col605=1; xtab(t605,rwt); endif; {iron}
if (Q1422(2)=1 or Q1422(3)=1) or (Q210=1 & (Q906(2)=1 or Q906(4)=1)) then col605=2; xtab(t605,rwt); endif; {folic acid}
if (Q1422(3)=1 or (Q210=1 & Q906(4)=1)) then col605=3; xtab(t605,rwt); endif; {combined iron and folic acid}
if col605 in 1:3 then col605=4; xtab(t605,rwt); endif; {if at least one of the above 3 is true: Column 4 of table 6.4}
```

Here are the variables used in table 6.6 and logic in CSPro

```haveanc=(Q102(5)=1 & Q1401 in 1:31);
if haveanc then
cntanc=0;
if Q1410=1 or Q1412=1 then col604a=1; col1=1; xtab(t604A,rwt); xtab(t604B,rwt); cntanc=cntanc+1; endif; {guideline}
if PROVANCT1 then col604a=2; col2=1; xtab(t604A,rwt); xtab(t604B,rwt); cntanc=cntanc+1; endif;  {ever training}
if (Q1421A(1)=1 & Q1421B(1)=1) or (Q1421A(2)=1 & Q1421B(2)=1 & Q1421A(3)=1 & Q1421B(3)=1) then
col604a=3; col3=1; xtab(t604A,rwt); xtab(t604B,rwt); cntanc=cntanc+1; endif; {BP}
if HEMOGLOB then col604a=4; col4=1; xtab(t604A,rwt); xtab(t604B,rwt); cntanc=cntanc+1; endif; {Hemoglobin}
if Q837B(1)=1 or Q1406(2)=1 or Q1420(4)=1 then col604a=5; col5=1; xtab(t604A,rwt); xtab(t604B,rwt); cntanc=cntanc+1; endif; {Urine protien}

if ( (Q1422(1)=1 or Q1422(3)=1) or (Q210=1 & (Q906(3)=1 or Q906(4)=1)) or
(Q1422(2)=1 or Q1422(3)=1) or (Q210=1 & (Q906(2)=1 or Q906(4)=1)) or
(Q1422(3)=1 or (Q210=1 & Q906(4)=1)) ) then col604a=6; col6=1;
xtab(t604A,rwt); xtab(t604B,rwt); cntanc=cntanc+1; endif; {combined iron + folic acid}

if cntanc = 6 then col604a=8; xtab(t604A,rwt); xtab(t604B,rwt); endif;  {all six items}
endif;
```
 Previous Topic: Bangladesh Health Facility Survey 2017 Next Topic: Aggregating data from facility to Province level
Goto Forum:

Current Time: Sun May 16 14:35:48 Coordinated Universal Time 2021