The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Malawi prevalence at national, regional, & cluster scale
Malawi prevalence at national, regional, & cluster scale [message #15401] Thu, 12 July 2018 16:29 Go to previous message
Ansmi25 is currently offline  Ansmi25
Messages: 1
Registered: July 2018
Member
Hello. I am trying to calculate malaria prevalence at national, region, and cluster scales. I noticed that when I calculate regions by microscopy my values are slightly different than those presented in the Malawi MIS 2017 final report. Could someone please assist me in understanding why my values are different (Freq: 266.7, 1060.2, & 1151.6)? I'd also appreciate any guidance on how to correctly code by cluster.


-------
*Parasitemia (vis RDT) in children 6-59 months
cap gen rdtmalpos=0
cap replace rdtmalpos=(HML35==1)
cap lab var rdtmalpos "Parasitemia (via RDT) in children 6-59 months"

*Parasitemia (vis microscopy) in children 6-59 months
cap gen micmalpos=0
cap replace micmalpos=(HML32==1)
cap lab var micmalpos "Parasitemia (via microscopy) in children 6-59 months"

*Weighting
gen wgt = hv005/1000000

*Proportion of children 6-59 months old with malaria infection (RDT)
tab rdtmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml35==0|hml35==1) [iweight=wgt]
tab micmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml32==0|hml32==1) [iweight=wgt]

*RDT by region
tab rdtmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml35==0|hml35==1) & hv024==1 [iweight=wgt]
tab rdtmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml35==0|hml35==1) & hv024==2 [iweight=wgt]
tab rdtmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml35==0|hml35==1) & hv024==3 [iweight=wgt]

*Mic by region
tab micmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml32==0|hml32==1) & hv024==1 [iweight=wgt]
tab micmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml32==0|hml32==1) & hv024==2 [iweight=wgt]
tab micmalpos if hc1>=6 & hc1<=59 & hv103==1 & hml33==0 &(hml32==0|hml32==1) & hv024==3 [iweight=wgt]
 
Read Message
Read Message
Previous Topic: Table 12.2 - Mosquito nets sourch (ANGOLA, IIMS 2015-2016)
Next Topic: 2014 Malawi MIS Survey
Goto Forum:
  


Current Time: Thu Mar 28 19:37:10 Coordinated Universal Time 2024