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 next message
shakim is currently offline  shakim
Messages: 2
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.

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 Go to previous message
Bridgette-DHS is currently online  Bridgette-DHS
Messages: 2166
Registered: 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: Tue Mar 2 15:39:00 Coordinated Universal Time 2021