The DHS Program User Forum: India

Home » Countries » India » Malaria

Show: Today's Messages :: Show Polls :: Message Navigator

Malaria [message #14331]

Fri, 23 March 2018 14:20

fewerling
Messages: 19
Registered: November 2016
Location: Brazil

Member

Dear,

We are now analyzing the India 2015 survey and the variables that indicate if the individual slept under a mosquito net in the last night are intriguing. All variables (ml10 in the KR dataset, ml101, ml0_* and v461 in the IR dataset) are indicating that no one slept under a mosquito net. Is this correct?

Thank you,
Fernanda Ewerling

International Center for Equity in Health
Pelotas, Brazil

Report message to a moderator

Re: Malaria [message #14450 is a reply to message #14331]

Fri, 06 April 2018 13:50

Bridgette-DHS
Messages: 3199
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

Sorry for the delay with this reply. The information about mosquito nets is in the household survey, i.e. in the HR or PR files. Open the PR file and enter "describe hml*" and you will get what you need.

It would be good if the empty variables in the other files, such as ml101, included "na-" at the beginning of the variable label. That's often done when, for one reason or another, a decision is made to leave a variable empty. I have no idea why the relevant information was not copied into the other files.

Report message to a moderator

Re: Malaria [message #14484 is a reply to message #14450]

Wed, 11 April 2018 15:14

fewerling
Messages: 19
Registered: November 2016
Location: Brazil

Member

Dear Bridgette and Tom,

We found the information in the PR dataset, however we are strugglig to merge it into the KR dataset. We need to do so because we work with batch analyses and our standard code use information from the KR dataset.
Which id should we use to procced with this merge (PR to KR dataset)?

Also, even though the dataset informs who slept under a treated net, the variables that indicates if the net was treated or not (variables hml10_1-7) are all'na' in the HR dataset. StatCompiler provides estimates on the % of households that have at least one treated net, but we don't know where this information came from. Can you help use here too?

Thanks for your help.

Best regards,
Fernanda Ewerling

Report message to a moderator

Re: Malaria [message #14500 is a reply to message #14484]

Fri, 13 April 2018 08:02

Bridgette-DHS
Messages: 3199
Registered: February 2013

Senior Member

Following is a response from DHS Senior Research Associate, Cameron Taylor:

If you are wanting to calculate ITN Ownership you would need to use the HR file. This is because the unit of analysis is the household. When you see hml10_1 that is net treatment information about net 1, hml10_2 is the net treatment information about net 2, etc. It is broken into separate variables because each row in the dataset is a household.

If you are wanting to calculate ITN Use you need to use the PR file. This is because the unit of analysis is people so the information is about the net that person slept under the previous night. I have included the information below how to calculate children <5 sleeping under an ITN the previous night in the PR file and ITN ownership in the HR file.

Please be cautious when analyzing data that is in a PR/KR merge. There are kids in the PR file for whom we don't have information in the KR file. Remember that the information in the KR file is only from children <5 of interviewed mothers. If the mother wasn't interviewed we don't have that information. For example we might know if they slept under an ITN the previous night but we don't have information about their fever history etc.

*ITN USE in PR FILE
use PRfile.dta
g wt = hv005/1000000

**ITN used the night before the survey
g itn=(hml12==1)
lab var itn "ITN used the night before the survey"

* Proportion of children under 5 years old who slept under an ITN the previous night
tab itn if hv103==1 & hml16<5 [iweight=wt]


*ITN OWNERSHIP in HR File
use HRfile.dta
g wt = hv005/1000000

egen ITNinHH = rowmax(hml10_1-hml10_7)
replace ITNinHH=0 if ITNinHH==.

* Proportion of households with at least one ITN
tab ITNinHH [iweight=wt]

Report message to a moderator

Re: Malaria [message #14505 is a reply to message #14500]

Fri, 13 April 2018 16:18

fewerling
Messages: 19
Registered: November 2016
Location: Brazil

Member

Dear Bridgette,

Thanks for your answer. Based on that we changed our codes to calculate ITN use by children using the PR dataset in all surveys.

However, we are still concerned about the India 2015 dataset.
Variable hml12 is all zero in the PR dataset, indicating that no one slept under a mosquito net. However, a tabulate of variable hml19 showed that 4.4% slept under an ever-treated net. The other apparent problem is that these informations are available for only 350,797 individuals (PR dataset contains 2.8 million individuals), and this is not a subsample indicator. It is not clear, and apparently there is an error in the datasets for these variables. Can you please check that?

Best,
Fernanda

Report message to a moderator

Re: Malaria [message #14527 is a reply to message #14505]

Tue, 17 April 2018 08:01

Bridgette-DHS
Messages: 3199
Registered: February 2013

Senior Member

Following is a response from Senior Data Processing Specialist, Mianmian Yu:

The definition of ITN went through plenty of revisions when the survey was carried out, and the survey actually collected information on LLIN instead of ITN. Partly for this reason, the existing version of data files have had HML10 as not applicable, which then made HML12 as not applicable. We have decided to populate HML10, and HML12 will be updated accordingly. A new version of the data files will be released soon. Meanwhile, we suggest data users to use HML6 for analyses on ITN. This variable's first category "pretreated, permanent treatment" refers to ITN/LLIN.

As for the total number of persons in HML19, please note that the survey collected net use related information for up to four household members ( Page 14 of Household Questionnaire), which are only a subset of listed household members.

Report message to a moderator

Re: Malaria [message #14948 is a reply to message #14527]

Fri, 18 May 2018 16:02

fewerling
Messages: 19
Registered: November 2016
Location: Brazil

Member

Dear,

We have just analyzed the data from the latest release of the India datasets (73), and we are still having trouble with the inseticide treated net variables.

All variables related to malaria (ml*) have information for 350,797 individuals in the PR dataset, however 1,094,964 have a mosquito net in the household.

For example, all individuals that have information for hv227 (has mosquito net) should also have information on hml1 (number of mosquito nets). However, there is 957,070 individuals that reported they have mosquito nets but info on hml1 (and all other hml variables) is missing:

. use "IAPR73FL.DTA" ,clear
. ta hml1 hv227, m

number of | has mosquito bed net
mosquito | for sleeping
bed nets | no yes | Total
-----------+----------------------+----------
0 | 212,903 0 | 212,903
1 | 0 38,531 | 38,531
2 | 0 43,760 | 43,760
3 | 0 26,482 | 26,482
4 | 0 14,896 | 14,896
5 | 0 7,230 | 7,230
6 | 0 3,266 | 3,266
7 | 0 3,729 | 3,729
. | 1,561,176 957,070 | 2,518,246
-----------+----------------------+----------
Total | 1,774,079 1,094,964 | 2,869,043

The same happens for the HR dataset:
. use "IAHR73FL.DTA" ,clear
. ta hml1 hv227, m

number of | has mosquito bed net
mosquito | for sleeping
bed nets | no yes | Total
-----------+----------------------+----------
0 | 43,459 0 | 43,459
1 | 0 8,820 | 8,820
2 | 0 9,029 | 9,029
3 | 0 4,791 | 4,791
4 | 0 2,419 | 2,419
5 | 0 1,050 | 1,050
6 | 0 430 | 430
7 | 0 434 | 434
. | 333,689 197,388 | 531,077
-----------+----------------------+----------
Total | 377,148 224,361 | 601,509

We are wondering why these individuals (957,070 that reported having mosquito nets) do not have these other information. We double checked pages 13-14 in the Household questionnaire and they show that the number of individuals alswering some questions (like hml1) should not be different from hv227. Could you please clarify it?

Report message to a moderator

Re: Malaria [message #15075 is a reply to message #14948]

Wed, 30 May 2018 10:30

Bridgette-DHS
Messages: 3199
Registered: February 2013

Senior Member

Following is a response from DHS Senior DHS Data Processing Specialist, Mianmian Yu:

Thanks for your question. We have investigated your observation and noticed that the variable HML1 was not populated fully due to an unexpected interruption at the stage of recode construction. A correction on this has been implemented and will be released in a new version of the recode data.

Report message to a moderator

Previous Topic:	District level Individual panel data
Next Topic:	Final Estimates of Stunting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 25 01:15:56 Coordinated Universal Time 2024