The DHS Program User Forum: Other countries » Burkina Faso 2010 DHS Report

Home » Countries » Other countries » Burkina Faso 2010 DHS Report

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

Burkina Faso 2010 DHS Report [message #14674]

Fri, 27 April 2018 10:50

rhuang
Messages: 12
Registered: April 2017

Member

I am trying to re-create the table from the Burkina Faso 2010 DHS Report concerning the nutritional status of children. I am looking specifically at Tableau 11.12 (page 187). I am wondering which data set was used to generate this table? Was it the KR (children's recode) file or the PR (individual household member recode) file? I cannot seem to get the total number of children in the report to match with what I have generated (total number of children in report=6,994)

Can someone give me some direction on which data file and which variable was used to generate these height-for-age standard deviation cutoffs (<-2 s.d. and <-3 s.d.)?

Thanks,

Rachel

Report message to a moderator

Re: Burkina Faso 2010 DHS Report [message #14691 is a reply to message #14674]

Mon, 30 April 2018 08:51

Bridgette-DHS
Messages: 3199
Registered: February 2013

Senior Member

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

Yes, the stunting of children is taken from the PR file. You need to restrict to children who are de facto residents, that is, children for whom hv103=1. The following lines will give 6,994 weighted cases (rounded to the nearest integer).

Report message to a moderator

Re: Burkina Faso 2010 DHS Report [message #14694 is a reply to message #14691]

Mon, 30 April 2018 09:16

rhuang
Messages: 12
Registered: April 2017

Member

What about the data in the KR file concerning child height-for-age and weight-for-age z scores? Is this data appropriate to use for determining the amount of stunted children? Are these children also in the PR file? I guess what I am asking is what is the main difference between the two files (KR and PR)? I know that the PR file contains all data for all household members and that the KR file holds all data for children under 5 years of age, but then why is the number of children (6,532 in the KR file for variable hw70) with height-for-age and weight-for-age z-scores different among the PR and KR files?

Thanks,

Rachel

Report message to a moderator

Re: Burkina Faso 2010 DHS Report [message #14696 is a reply to message #14694]

Mon, 30 April 2018 09:31

Bridgette-DHS
Messages: 3199
Registered: February 2013

Senior Member

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

As has been stated in other postings, the PR file includes all children living in the household. It gives the most representative information about children in the household population. The KR file is limited to children whose mother is living and in the household. It does not include children whose mother has died or is living in a different household than the child. The children who are in the PR file but not the KR file tend to be relatively deprived and are more likely to be stunted, etc. However, if you want to relate stunting (etc.) to other characteristics of the child, or characteristics of the mother, it is necessary to use the KR file.

Report message to a moderator

Re: Burkina Faso 2010 DHS Report [message #14697 is a reply to message #14696]

Mon, 30 April 2018 09:33

rhuang
Messages: 12
Registered: April 2017

Member

Thank you so much for the clarification!

-Rachel

Report message to a moderator

Re: Burkina Faso 2010 DHS Report [message #14712 is a reply to message #14691]

Tue, 01 May 2018 14:20

rhuang
Messages: 12
Registered: April 2017

Member

I cannot seem to obtain that number of 6,994 children from the Burkina Faso 2010 DHS report from the PR data file that have height-for-age and weight-for-age z-score data. In the PR data file, I see that there are 7,315 children with non-missing data. When I remove the observations that have: height out of plausible limits, age in days out of plausible limits, flagged cases, and observations=9999, I see that the total number of children with height-for-age and weight-for-age z-scores is 6,883. Even when I run a simple tabulation with the household weight variable in STATA, I do not get 6,994 children which is what is reported in the DHS report. Am I missing something?

-Rachel

Report message to a moderator

Re: Burkina Faso 2010 DHS Report [message #14956 is a reply to message #14712]

Mon, 21 May 2018 08:51

Bridgette-DHS
Messages: 3199
Registered: February 2013

Senior Member

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

The 6994 is the weighted number of de facto children who have valid scores on hc70. The follow lines will give what you want.

gen stunted=0
replace stunted=1 if hc70<-200
replace stunted=. if hc70<-600 | hc70>600

tab stunted [iweight=hv005/1000000] if hv103==1

Report message to a moderator

Previous Topic:	DRC 2013-2014 employment occupation questions
Next Topic:	Rwanda 2005

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Nov 23 21:09:36 Coordinated Universal Time 2024