The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Service Provision Assessment (SPA) » Replicating table (SPA Survey)
Re: Replicating table [message #29448 is a reply to message #29368] Thu, 20 June 2024 10:46 Go to previous messageGo to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 893
Registered: April 2022
Senior Member
Following is a response from DHS SPA Specialist, Rajendra Dangol:

Please find below my CsPro logic used to produce the said indicators and some notes where applicable. Hope this helps.

Thank you,
Rajendra

*Any sterilization equipment
if ANYCAP then        cntit=cntit+1; row305=19; xtab(t3051,rwt); xtab(t3052,rwt); endif; 
(Note: variable ANYCAP can be found in the data dictionary/structure)

**Safe final disposal of sharp waste
SHARPWASTEcs= (Q600 in 5,7,9,10,11,13,14,15,16,18,20);
if SHARPWASTEcs then  cntit=cntit+1; row305=3; xtab(t3051,rwt); xtab(t3052,rwt);  endif;
(Note: This is country-specific in Nepal SPA, we have defined this variable a bit differently for the final report)
  
**Safe final disposal of healthcare waste
MEDWASTEcs  = (Q601 in 5,7,9,10,11,13,14,15,16,18,20) or 
              (Q601=1 & Q600 in 5,7,9,10,11,13,14,15,16,18,20); 
if MEDWASTEcs then    cntit=cntit+1; row305=4; xtab(t3051,rwt); xtab(t3052,rwt);  endif; 
(Note:  This is country-specific in Nepal SPA, we have defined this variable a bit differently for the final report)

***Appropriate storage of healthcare waste
if MEDSTORE then      cntit=cntit+1; row305=6; xtab(t3051,rwt); xtab(t3052,rwt);  endif;

***IP and health care waste management guidelines
if Q611=1 or Q504=1 then cntit=cntit+1; row305=18; xtab(t3051,rwt); xtab(t3052,rwt); endif;
 
***Appropriate storage of sharp waste
if SHARPSTORE then    cntit=cntit+1; row305=5; xtab(t3051,rwt); xtab(t3052,rwt);  endif;
(Note: It was not presented in the final table)

***Equipment for high level disinfection (HLD)
if HLDequip = 1 then
    row305=2; xtab(t3051,rwt); xtab(t3052,rwt);
endif;
(It was not presented in the final table)
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Replicating table
Next Topic: Provider/staff listing form
Goto Forum:
  


Current Time: Thu Nov 28 20:36:54 Coordinated Universal Time 2024