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 #29340] Sat, 01 June 2024 20:29 Go to previous message
foysal is currently offline  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.
 
Read Message
Read Message
Previous Topic: Afghanistan SPA 2017-2018 survey
Next Topic: Replicating table
Goto Forum:
  


Current Time: Sun Nov 3 08:07:28 Coordinated Universal Time 2024