The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Bangladesh » Exact stunting rate with exact observation number
Exact stunting rate with exact observation number [message #15080] Wed, 30 May 2018 12:58 Go to previous message is currently offline
Messages: 33
Registered: December 2017
In order to find the stunting rate among children under age 5 using BDHS 14 data, I have used the following Stata command.
I used this command both in KR & PR dataset. But the total observation number is not exactly matching with the BDHS-14 report.

Prevalence of Stunting in 2014 (Children under age 5)

My estimation,
Using KR file, 36.24 % (N = 6965)
Using PR file, 36.09 % (N = 7256)

From BDHS'14 Report
36.1 % (N = 7318)

Here, my question is, how can I obtain the same prevalence rate and same observation for calculating child stunting rate?
Where is my mistakes, that I've made in my Stata command?
I have to get the exact observations and the exact stunting rate.

Stata command for stunting (just for the KR file)

*SVY command
gen strata=v023
gen psu=v021
gen sampwt=v005/1000000
svyset psu [pw=sampwt], strata (strata)

//child stunting calculation
codebook hw70
tab hw70 if hw70>9990,m
tab hw70 if hw70>9990, m nolabel
gen HAZ=hw70
replace HAZ=. if HAZ>=9996
gen stunted=.
replace stunted=0 if HAZ~=.
replace stunted=1 if HAZ<-200

svy: tab stunted

Best regards,


[Updated on: Wed, 30 May 2018 13:15]

Report message to a moderator

Read Message
Read Message
Read Message
Previous Topic: Creating a variable for disease
Next Topic: How to calculate mother's age at most recent birth (last birth) in BDHS 2011
Goto Forum:

Current Time: Tue Apr 7 17:24:59 Eastern Daylight Time 2020