Replicating table [message #29340] |
Sat, 01 June 2024 20:29 ![Go to next message Go to next message](/theme/default/images/down.png) |
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.
|
|
|
Re: Replicating table [message #29469 is a reply to message #29340] |
Mon, 24 June 2024 09:51 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
Janet-DHS
Messages: 805 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](/index.php?t=getfile&id=2336&private=0)
-
Attachment: 29340_2.png
(Size: 17.42KB, Downloaded 55 times)
-
Attachment: 29340_1.png
(Size: 93.36KB, Downloaded 55 times)
|
|
|