Re: Replicating Indicators Tanzania 2015 SPA [message #13206 is a reply to message #12824] |
Tue, 03 October 2017 13:07 |
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
|
|
|