The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Service Provision Assessment (SPA) » Creating some variables (SPA)
Re: Creating some variables [message #23379 is a reply to message #23375] Tue, 31 August 2021 09:20 Go to previous message
SaraDHS is currently offline  SaraDHS
Messages: 46
Registered: December 2020
Member
Dear ashraf,

The definition provided in the footnotes is:
Facility reports that some instruments are processed in the facility, and the facility has an electric pot or other pot with heat source for high-level disinfection by boiling or high-level disinfection by steaming, or else facility has chlorine, formaldehyde, CIDEX, or glutaraldehyde for chemical high-level disinfection available somewhere in the facility on the day of the survey.

Let's look at the dataset, questionnaire and your code:

replace hlvlds=1 if (q201==1 | q201==2) /// Facility reports that some instruments are processed in the facility. Good, this is correct.
& ((q501a_3==1 & q501b_3==1) /// As described in the questionnaire, q501a_3 and q501b_3 are asking about an electric dry heat stabilizer. This is not included in the definition. An electric pot, boiler, or steamer is q501a_4.
| (q501a_5==1 & q501b_5==1) | (q501a_6==1) | /// Again, look at the questionnaire and the data set and correct your code. Does q501_5 have both a and b? Is the definition saying "facility has functioning other pot OR heat source"? Because that is what your code is telling Stata.
inrange (q502g_5,3,5)) ///If you use q502g you need to also use q501a_9, which says that the facility uses any chemicals for HLD, then define which chemicals fall within the definition.

If you correct your code according to the definition and the dataset, you will get the same % as in the final report.

Best,
Sara


Sara Riese, PhD Senior Demographic and Health Researcher, DHS Program
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Replicating table 3.3 and 3.7 in Tanzania SPA 2014-15
Next Topic: Creating two variable
Goto Forum:
  


Current Time: Wed Nov 13 12:33:19 Coordinated Universal Time 2024