Calculating malaria prevalence (Tanzania: Standard AIS, 2011-12) [message #11236] |
Mon, 21 November 2016 06:19 ![Go to next message Go to previous message](/theme/default/images/down.png) |
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
|
|
|