The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Topics » Service Provision Assessment (SPA) » Replicating Indicators Tanzania 2015 SPA
Replicating Indicators Tanzania 2015 SPA [message #12824] Tue, 18 July 2017 16:04 Go to next message
ajhobbs is currently offline  ajhobbs
Messages: 1
Registered: July 2017
Member
I am working with the Tanzania 2015 SPA survey and having a hard time trying to replicate certain indicators from the tables in the report. The following indicators are where I am struggling:

Appropriate storage of sharps waste - Table 3.5, page 39
Appropriate storage of infectious waste - Table 3.5, page 39
Hemoglobin - Table 6.4, page 118

I think each of these indicators is using a calculated variable saved as part of the 2015 TSPA recode file (e.g. SHARPSTORE, MEDSTORE, HEMOGLOB). I would like to be able to understand how each of these calculated variables was created. Is there any information available on that?

Thank you!
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: 1115
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

Previous Topic: Understanding Tanzania 2014/15 SPA weights
Goto Forum:
  


Current Time: Wed Dec 13 02:31:14 Eastern Standard Time 2017