The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Burkina Faso 2010 DHS Report
Burkina Faso 2010 DHS Report [message #14674] Fri, 27 April 2018 10:50 Go to next message
rhuang is currently offline  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
Re: Burkina Faso 2010 DHS Report [message #14691 is a reply to message #14674] Mon, 30 April 2018 08:51 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
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).

Re: Burkina Faso 2010 DHS Report [message #14694 is a reply to message #14691] Mon, 30 April 2018 09:16 Go to previous messageGo to next message
rhuang is currently offline  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
Re: Burkina Faso 2010 DHS Report [message #14696 is a reply to message #14694] Mon, 30 April 2018 09:31 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
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.
Re: Burkina Faso 2010 DHS Report [message #14697 is a reply to message #14696] Mon, 30 April 2018 09:33 Go to previous messageGo to next message
rhuang is currently offline  rhuang
Messages: 12
Registered: April 2017
Member
Thank you so much for the clarification!

-Rachel
Re: Burkina Faso 2010 DHS Report [message #14712 is a reply to message #14691] Tue, 01 May 2018 14:20 Go to previous messageGo to next message
rhuang is currently offline  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
Re: Burkina Faso 2010 DHS Report [message #14956 is a reply to message #14712] Mon, 21 May 2018 08:51 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
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

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


Current Time: Fri Mar 29 02:51:39 Coordinated Universal Time 2024