The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Service Provision Assessment (SPA) » Replicating Indicators Tanzania 2015 SPA
Re: Replicating Indicators Tanzania 2015 SPA [message #13206 is a reply to message #12824] Tue, 03 October 2017 13:07 Go to previous message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
Please see the response from Senior Data Processing Specialist, Ms. Claudia Marchena:
Quote:

Indeed, SHARPSTORE, MEDSTORE, and HEMOGLOB are calculated variables as follows (the logic below follows variable names from the Inventory Questionnaire in Tanzania SPA 2014-15):

Footnote on table 3.5:
5 Sharps container observed in general outpatient service area, in area where HIV testing is done if facility does HIV testing, as well as in area where
minor surgery is done, if facility does minor surgeries
sharpstore=(Q710(6)=1 and
           ((Q806=1 and Q827(6)=1) or Q806 <> 1) and
                       ((Q1312=1 and Q1351(6)=1) or Q1312 <> 1) and
                       ((Q1406(1) in 1:3 and Q1451(6)=1) or !Q1406(1) in 1:3) and
                       ((Q1504=1 and Q1551(6)=1) or Q1504 <> 1) and
                       ((Q1627=1 and Q1651(6)=1) or Q1627 <> 1) and
                       ((Q1808=1 and Q1851(6)=1) or Q1808 <> 1) and
                       ((Q1913=1 and Q1951(6)=1) or Q1913 <> 1) and
                       (!poschar("ABF",Q2002) or (poschar("ABF",Q2002) and Q2051(6)=1)) and                      { poschar is a function that reads any value A or B or F stored in Q2002; ! means not }
                       ((Q102(15)=1 and Q2451(6)=1) or Q102(15) <> 1));


Footnote on table 3.5:
6 Waste receptacles observed in general outpatient service area, in area where HIV testing is done if facility does HIV testing, as well as in area where
minor surgery is done, if facility does minor surgeries
MEDstore=(Q710(4)=1 and
    ((Q806=1 and Q827(4)=1) or Q806 <> 1) and
                ((Q1312=1 and Q1351(4)=1) or Q1312 <> 1) and
                ((Q1406(1) in 1:3 and Q1451(4)=1) or !Q1406(1) in 1:3) and
                ((Q1504=1 and Q1551(4)=1) or Q1504 <> 1) and
                ((Q1627=1 and Q1651(4)=1) or Q1627 <> 1) and
                ((Q1808=1 and Q1851(4)=1) or Q1808 <> 1) and
                ((Q1913=1 and Q1951(4)=1) or Q1913 <> 1) and
               (!poschar("ABF",Q2002) or (poschar("ABF",Q2002) and Q2051(4)=1) ) and
                ((Q102(15)=1 and Q2451(4)=1) or Q102(15) <> 1));

Footnote on table 6.4:
1 Capacity to conduct any haemoglobin test in the facility
hemoglob=( (Q802B(1)=1 and Q802C(1)=1) OR                                                                                                  {hematology analyzer}
           (Q802B(2)=1 and Q802C(2)=1 and Q802B(3)=1 and Q802C(3)=1) or                                                 {hemocue and microcuvette}
           (Q802B(4)=1 and Q802C(4)=1 and Q802B(5)=1 and Q802C(5)=1 and Q802B(6)=1) or               {colorimeter or hemoglobinometer and drabkin's solution and pipette}
            Q802B(7)=1 or                                                                                                                                                       {litmus paper for hemoglobin test}
           Q1406(4)=1);

Quote:

Please note that the use of parenthesis is in the logic above (and how it translates into the software used by the User) is indispensable to get the conditions evaluated in the same way and thus be able to replicate results.


Best,
Claudia

 
Read Message
Read Message
Previous Topic: Understanding Tanzania 2014/15 SPA weights
Next Topic: ANC and labor and delivery client sampling in Malawi 2013-2014 SPA
Goto Forum:
  


Current Time: Sun Apr 28 20:14:13 Coordinated Universal Time 2024