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
anikhpg42@gmail.com is currently offline  anikhpg42@gmail.com
Messages: 38
Registered: December 2017
Location: Bangladesh
Member

Hi,
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,
Anik


ASIBUL ISLAM ANIK

[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: Details about KR file
Goto Forum:
  


Current Time: Fri Mar 29 01:45:55 Coordinated Universal Time 2024