The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » Household data on Burkina Faso
Household data on Burkina Faso [message #9749] Thu, 12 May 2016 13:08 Go to next message is currently offline
Messages: 7
Registered: November 2015
Location: Bangladesh
Dear forum members,

I am currently working on the Burkina Faso household data (bfpr70SV)from MIS 2014. My study is related to utilization of mosquito net.
The bfpr70 dataset contains 39529 cases, however the published report says that the survey was conducted on 7600 women from 6500 households. Thus it is causing certain confusions. I would like to know if-

1) 39539 is the summation of all men, women and children surveyed from those 6500 households.

2) bfpr70 is the right dataset to analyse to measure the prevalence of mosquito nets utilization in BF regardless of age (adult/children) and gender (men/women).

Thanks in advance for your reply!

Re: Household data on Burkina Faso [message #9897 is a reply to message #9749] Fri, 03 June 2016 16:16 Go to previous message
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
Malaria expert, Cameron Taylor responded as follows:

Hi Nile,
Hopefully I can better clarify your question.

1) The dataset BFPR70 is the "person" recode meaning that it is information about all household members. So you are correct that 39,529 is the total number of people surveyed from the 6,500 households
2) To answer your second question, if you are wanting to look at ITN usage by the entire population you are correct in using the BFPR70 file.

If this is what you are interested in you should use the indicator "Proportion of the population who slept under an ITN the previous night".
Numerator: Number of individuals who slept under an ITN the previous night
Denominator: Total number of individuals who spent the previous night in surveyed households

When examining the denominator closely you will see that the denominator is limited to individuals who spent the previous night in surveyed households. This is because the Person Recode (PR) file contains information about everyone recorded in the household schedule. So this is anyone who usually lives in the household (de jure) OR stayed there the night before (de facto). However, we only have ITN utilization data on those who stayed in the household the night before the survey (de facto). When we calculate this indicator we are going to have to make sure we restrict the PR data to only those who slept in the household the previous night. (variable hv103= slept last night)

To calculate this in Stata you could use the following code
use " BFPR70FL.DTA"
g wgt = hv005/1000000
g itn=(hml12==1|hml12==2)
tab itn if hv103==1 [iweight=wgt]

If run correctly you should see that 67% (n=37,340) of the de facto population slept under an ITN the previous night in Burkina Faso (2014 MIS).

You will see that another user had a very similar question using the Nigeria 2013 dataset

Previous Topic: DHS 2011 Mozambique - Distribution of Samples by Region (Province)
Next Topic: Pakistan DHS 2006-2007
Goto Forum:

Current Time: Thu Jun 20 11:04:17 Coordinated Universal Time 2024