The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Service Provision Assessment (SPA) » Replicating table (SPA Survey)
Replicating table [message #29368] Fri, 07 June 2024 14:16 Go to next message
foysal is currently offline  foysal
Messages: 9
Registered: August 2021
Member
Dear Sara and SPA experts,

I am currently working with the Nepal SPA Survey 2021 dataset and am attempting to create several variables from Table 3.8.2. Despite my efforts, I have been unable to match the percentages reported in the final survey report. Below is my STATA code:

gen wgt=facwt/1000000

*Any sterilization equipment
gen ster=0
replace ster=1 if (q201==1 | q201==2) & ((q501a_1==1 & q501b_1==1) | (q501a_3==1 & q501b_3==1) | (q501a_6==1))
tab ster [iw=wgt]

**Safe final disposal of sharp waste
recode sharpwaste 9=.
recode sharpwaste (1=1 "available") (0=0 "not available"), gen (swaste)
label variable swaste "Safe final disposal of infectious waste"
tab swaste [iw=wgt],m

**Safe final disposal of healthcare waste
recode medwaste 9=.
recode medwaste (1=1 "available") (0=0 "not available"), gen (mwaste)
label variable mwaste "Safe final disposal of infectious waste"
tab mwaste [iw=wgt],m

***Appropriate storage of healthcare waste
recode medstore 9=.
recode medstore (1=1 "available") (0=0 "not available"), gen (mstore)
label variable mstore "Appropriate storage of infectious waste"
tab mstore [iw=wgt],m

***IP and health care waste management guidelines
gen guide=0
replace guide=1 if q610==1 & q611==1
tab guide [iw=wgt]

***Appropriate storage of sharp waste
recode sharpstore 9=.
recode sharpstore (1=1 "available") (0=0 "not available"), gen (sstore)
label variable sstore "Appropriate storage of infectious waste"
tab sstore [iw=wgt],m

***Equipment for high level disinfection (HLD)
recode hldequip 9=.
recode hldequip (1=1 "available") (0=0 "not available"), gen (hilvldis)
label variable hlequip "Equipment for high level disinfection (HLD)"
tab hlequip [iw=wgt],m

Additionally, I have a query regarding the variable "Improved water source" in the Haiti SPA 2017-18 dataset. Here is the STATA code I used, but the percentages do not match the report (Table 3.3):
gen water=0
replace water=1 if inlist(q330,1,2,10) | (inlist(q330,3, 4, 5, 7, 9) & inlist(q331, 1, 2))
tab water [iw=wgt]
label var water "improved water source"
tab water [iw=wgt],m

Could you please provide guidance on the correct steps to create these variables? Specifically, I am interested in understanding the criteria and coding used to derive these variables to ensure they align with the percentages reported in the final documents.

Many thanks
Re: Replicating table [message #29414 is a reply to message #29368] Thu, 13 June 2024 06:52 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 899
Registered: April 2022
Senior Member
Following is a response from Senior Data Processing Specialist, Claudia Marchena:

Regarding Haiti SPA 2017-18 for "Improved water source":

Q330 in 1,2,10,12 or (Q330 in 3,4,5,7,9 & Q331 in 1,2)
Note from Claudia: category 12 in Q330 is included in the code. This country specific category was confirmed by the Implementing Agency as applicable. Unfortunately, it is missing in the footnote for table 3.3.
/index.php?t=getfile&id=2328&private=0

Regarding your question about Nepal SPA a response will be posted next week.
  • Attachment: image002.png
    (Size: 86.95KB, Downloaded 169 times)
Re: Replicating table [message #29448 is a reply to message #29368] Thu, 20 June 2024 10:46 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 899
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)
Re: Replicating table [message #29505 is a reply to message #29368] Sun, 30 June 2024 19:51 Go to previous messageGo to next message
foysal is currently offline  foysal
Messages: 9
Registered: August 2021
Member
Dear DHS User Forum,

I would like to extend my appreciation to Rajendra Dangol for his invaluable assistance, which has greatly helped resolve most issues I encountered while working with the Nepal SPA Survey 2021 dataset.

However, I am facing an issue with specific variables in the dataset. Firstly, I am unable to locate the variable "appropriate storage of sharp waste." Could someone confirm if this variable is not available in the Nepal SPA 2021 dataset? Additionally, I am uncertain about the availability of the variable "Equipment for high-level disinfection" in the dataset.

Furthermore, I am curious to know if the variable "safe final disposal of health care waste" in the Nepal dataset is analogous to the variable "safe final disposal of infectious waste" used in surveys from other countries.

Could someone kindly provide further clarification on these variables?

Thank you in advance for your assistance and guidance.

Best regards,

Foysal
Re: Replicating table [message #29541 is a reply to message #29505] Wed, 03 July 2024 15:18 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 899
Registered: April 2022
Senior Member
Following is a response from DHS SPA Specialist, Rajendra Dangol:

1. ***Appropriate storage of healthcare waste
if MEDSTORE then cntit=cntit+1; row305=6; xtab(t3051,rwt); xtab(t3052,rwt); endif;
Please look for variable MEDSTORE, also sending frequency below.
/index.php?t=getfile&id=2344&private=0

2. ***Equipment for high level disinfection (HLD)
Please look for variable HLDEQUIP, also sending frequency below. FYI, it was not present in final report.
Item HLDEQUIP: Facility has good high level disinfection (HLD) equipment
Value Set HLDEQUIP_VS1: Facility has good high level disinfection (HLD) equipment
______________________________ _____________________________ _____________
Categories Frequency CumFreq % Cum %
_______________________________ _____________________________ _____________
0 No 583 583 37.0 37.0
1 Yes 993 1576 63.0 100.0
_______________________________ _____________________________ _____________
Total 1576 1576 100.0 100.0

3. Regarding query "Furthermore, I am curious to know if the variable "safe final disposal of health care waste" in the Nepal dataset is analogous to the variable "safe final disposal of infectious waste" used in surveys from other countries." I think they are not exactly the same but I am not sure about this. You may need to ask one of the SPA country managers to confirm this. In Nepal we have used it a bit differently as the country-specific definition which is given below:

**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)

Hope this helps,

Kind regards,
Rajendra
  • Attachment: image.png
    (Size: 11.29KB, Downloaded 122 times)

[Updated on: Fri, 05 July 2024 13:26]

Report message to a moderator

Previous Topic: Replicating table
Next Topic: Provider/staff listing form
Goto Forum:
  


Current Time: Sat Dec 7 18:29:00 Coordinated Universal Time 2024