The DHS Program User Forum: Service Provision Assessment (SPA)

Home » Topics » Service Provision Assessment (SPA) » Replicating table (SPA survey)

Show: Today's Messages :: Show Polls :: Message Navigator

Replicating table [message #29340]

Sat, 01 June 2024 20:29

foysal
Messages: 9
Registered: August 2021

Member

Dear Sara and SPA experts,

I am currently working with the 2014/15 Tanzania SPA survey, aiming to create the variable: equipment for high-level disinfection (referenced in table 3.5) based on the footnotes and questionnaire. However, I am unable to match the percentages presented in the final report table.
My STATA code is:
gen wt=facwt/1000000

*Equipment for high level disinfection
gen hldis=0
replace hldis=1 if (q201==1 | q201==2) & ((q501a_3==1 & q501b_3==1) | (q501a_5==1 & q501b_5==1) | (q501a_6==1 & q501a_7==1 & q501b_7==1) | (q501a_9==1 & inrange(q502g_5,3,5)))
tab hldis [iw=wt]

Is there anything else I need to consider? Would it be possible to obtain the codes for this variable? I would greatly appreciate any assistance with this matter.

Thank you very much.

Report message to a moderator

Re: Replicating table [message #29469 is a reply to message #29340]

Mon, 24 June 2024 09:51

Janet-DHS
Messages: 893
Registered: April 2022

Senior Member

Following is a response from Senior Data Processing Specialist, Claudia Marchena:
Here is how to calculate to match the final report the "equipment for high-level disinfection".

Q201 in 1,2 & (

               ( Q501A(4)=1 & Q501B(4)=1) or (Q501A(5)=1 & Q501A(6)=1 & Q501B(6)=1) or (Q501A(9)=1 & Q502G(5) in 3,4,5,6)

              )

Below in bold font is the footnote #2 on the table referring to the calculation of "equipment for high-level disinfection". I am breaking the code as per the footnote. The only chemical that was not listed in the footnote was Cidex that is included in the code, I added it in red in the text below to denote it is not in the footnote.
Facility reports that some instruments are processed in the facility and Q201 in 1,2 &

the facility has an electric pot (( Q501A(4)=1 & Q501B(4)=1)

or other pot with heat source for high-level disinfection by boiling or high-level disinfection by steaming, or (Q501A(5)=1 & Q501A(6)=1 & Q501B(6)=1)

Below are screenshots from "Processing of instruments section" on Tanzania SPA 2014-15. I have highlighted the items that matches the footnote.

or else facility has chlorine, cidex, formaldehyde, or glutaraldehyde for chemical high level disinfection available somewhere in the facility on the day of the survey.

or (Q501A(9)=1 & Q502G(5) in 3,4,5,6)

Below are screenshots from "Processing of instruments section" on Tanzania SPA 2014-15. I have highlighted the items that matches the footnote.
/index.php?t=getfile&id=2336&private=0

Attachment: 29340_2.png
(Size: 17.42KB, Downloaded 96 times)
Attachment: 29340_1.png
(Size: 93.36KB, Downloaded 97 times)

Report message to a moderator

Previous Topic:	Afghanistan SPA 2017-2018 survey
Next Topic:	Replicating table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Dec 1 05:18:52 Coordinated Universal Time 2024