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 next 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]
Re: Malawi prevalence at national, regional, & cluster scale [message #15461 is a reply to message #15401] Tue, 24 July 2018 23:41 Go to previous message
Liz-DHS
Messages: 1381
Registered: February 2013
Senior Member
A response from senior malaria expert, Cameron Taylor:
Quote:

Dear user,
Thank you for providing code with your question. It is greatly appreciated!

Everything looks correct with the code but with malaria microscopy you need to include hml32==6 since there were some tests that were undetermined but they still should be included in the number of children tested (or the denominator of the indicator).
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|hml32==6) [iweight=wgt]
Let us know if you have additional questions

Cameron
Previous Topic: Table 12.2 - Mosquito nets sourch (ANGOLA, IIMS 2015-2016)
Next Topic: 2014 Malawi MIS Survey
Goto Forum:
  


Current Time: Thu Nov 15 12:38:42 Eastern Standard Time 2018