The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Inseticide-treated net (malaria) - Tchad 2014
Inseticide-treated net (malaria) - Tchad 2014 Tue, 10 January 2017 07:43
 fewerling Messages: 19Registered: November 2016 Location: Brazil Member
Dear all,

We are trying to reproduce the % of pregnant women that slept under a inseticide-treated net in the previous night for Tchad 2014 (Table 11.7 in the country report).
We are using the following codes to calculate the results:

** IR dataset **
gen itnwm=.
replace itnwm=0 if v213==1
recode itnwm (0=1) if inrange(ml101,1,2)
svyset v021 [pweight=v005]
svy: prop itnwm

We found an estimate of 22.6% and a weighted sample size of 2,388, however the results in the report are 34.7% and sample size 1,572.

The table mention that the results are restricted to women that slept in the household the night before, but we checked and the variable v213 is already restricted to this group:

** PR dataset **
ta hml18 if hv104==2

pregnancy status from |
individual file | Freq. Percent Cum.
-------------------------+---------------------------------- -
not pregnant, don't know | 15,469 86.09 86.09
pregnant | 2,500 13.91 100.00
-------------------------+---------------------------------- -
Total | 17,969 100.00

. ta hml18 if hv104==2 & hv103==1

pregnancy status from |
individual file | Freq. Percent Cum.
-------------------------+---------------------------------- -
not pregnant, don't know | 15,259 86.12 86.12
pregnant | 2,460 13.88 100.00
-------------------------+---------------------------------- -
Total | 17,719 100.00

** IR dataset **
. ta v213

currently |
pregnant | Freq. Percent Cum.
-------------+-----------------------------------
no or unsure | 15,259 86.12 86.12
yes | 2,460 13.88 100.00
-------------+-----------------------------------
Total | 17,719 100.00

Are we missing any restriction to the denominator? We use the same code for other surveys and it seems to work.

Thank you!
Best wishes,
Fernanda
Re: Inseticide-treated net (malaria) - Tchad 2014 [message #11556 is a reply to message #11553] Tue, 10 January 2017 10:45
 Bridgette-DHS Messages: 2307Registered: February 2013 Senior Member
Following is a response from DHS Senior Research Associate, Cameron Taylor:
Quote:

Thank you for your question and your code. You are correct in that the Tchad data does require an extra restriction for this indicator. In this survey mosquito net questions were only asked to households that were not selected for the men's questionnaire. So you need to add the restriction hv027==0 to your tabulation. You can read more about the sampling (Ã‰CHANTILLONNAGE) on page 7 and 8 in the final report.

I tried to replicate your code on other surveys and I am not matching denominators. I would suggest you re-examine your code for other surveys since you should be using the PR file to replicate this indicator. Here is the code you can modify for TChad 2014-15

```use "TDPR71FL.DTA", clear
gen itn=(hml12==1|hml12==2)
gen wt= hv005/1000000
tab itn if hv103==1 & hv104==2 & hml18==1 & hml16>=15 & hml16<=49 & hv027==0 [iweight=wt]
```

Re: Inseticide-treated net (malaria) - Tchad 2014 [message #11558 is a reply to message #11556] Tue, 10 January 2017 11:48
 fewerling Messages: 19Registered: November 2016 Location: Brazil Member
It worked. Thank you!
 Previous Topic: Variables representative at the new province level for DRC (2013/14) Next Topic: Zimbabwe 2010-2011 couples data
Goto Forum:

Current Time: Sat Jun 19 05:12:13 Coordinated Universal Time 2021