The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Calculating malaria prevalence (Tanzania: Standard AIS, 2011-12)
Calculating malaria prevalence (Tanzania: Standard AIS, 2011-12) [message #11236] Mon, 21 November 2016 06:19 Go to previous message
NinaB is currently offline  NinaB
Messages: 1
Registered: November 2016
Location: Basel, Switzerland
Member
Hi,

I'm trying to reproduce the malaria prevalences (by mRDT and microscopy) for children 6-59 months which can be found in the Tanzania AIS 11/12 final report on page 157. I watched the DHS youtube videos on sampling and weighting and read some other threads in this forum. However, I was not able to get exactly the same numbers as in the report. I'm using the household member dataset (PR) and my stata code so far looks like this:

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

*Parasitemia (via mRDT) in children 6-59 months
                gen rdtmalpos=0
                replace rdtmalpos=(hml35==1) 
                lab var rdtmalpos "Parasitemia (via mRDT) in children 6-59 months"
	
				
*Creating weight variable
gen wgt=hv005/1000000 

*Survey setting the data
svyset [pw=wgt], psu(hv021) strata(hv023)

*Proportion of children 6-59 months old with malaria infection (microscopy) by Region
svy: mean micmalpos if hc1>=6 & hc1<=59 & hml33==0, over(hv024)

*Proportion of children 6-59 months old with malaria infection (mRDT) by Region
svy: mean rdtmalpos if hc1>=6 & hc1<=59 & hml33==0, over(hv024)



Does anyone have an idea what I'm doing wrong. Thanks for helping me.
Nina
 
Read Message
Read Message
Previous Topic: How to declare data survey with complex design by Stata
Next Topic: Barriers to the utilization of malaria preventive measures in Nigeria among pregnant women - Variabl
Goto Forum:
  


Current Time: Thu Mar 28 13:59:57 Coordinated Universal Time 2024