The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Newborn birthweight calculation for Ethiopian 2000, 2005, 2011 and 2016 DHS (I want to calculate newborn birthweight in each survey round and combine them for my analysis)
Re: Newborn birthweight calculation for Ethiopian 2000, 2005, 2011 and 2016 DHS [message #20105 is a reply to message #20059] Fri, 25 September 2020 11:03 Go to previous messageGo to previous message
Shireen-DHS is currently offline  Shireen-DHS
Messages: 140
Registered: August 2020
Location: USA
Senior Member
Hello,

For calculating these indicators you can use code from our code share library posted on GitHub.
These indicators are part of Chapter 11 on Nutrition and can be found in the NT_CH_NUT.do file. However, before using this code please read the readme file and the main file for each chapter.
This is the link: https://github.com/DHSProgram/DHS-Indicators-Stata

For the surveys in the year 2000 and 2005, there are variables you will need to merge from another file because these older surveys used a different reference standard. We now use the 2006 WHO Child Growth Standards for these indicators. Please read about these changes in the "Changes over time" section for these indicators that is described in our Guide to DHS statistics: https://www.dhsprogram.com/Data/Guide-to-DHS-Statistics/inde x.htm#t=Nutritional_Status.htm

Therefore for the 2000 survey (ETPR41FL.dta) and 2005 survey (ETPR51FL.dta) please run the following merge code first to get the hc70-72 variables you need.

*merge code to merge HW and PR files. Please do the same for the ETHW51FL.dta merge with ETPR51FL.dta
use ethw41fl.dta, clear
rename hwhhid hhid
rename hwline hvidx
merge 1:1 hhid hvidx using etpr41fl.dta


Then using the PR files for all the surveys you can calculate stunting, underweight, and wasting as follows. This code was copied from the NT_CH_NUT.do on the GitHub site.

bel var nt_ch_sev_stunt "Severely stunted child under 5 years"

//Stunted
gen nt_ch_stunt= 0 if hv103==1
replace nt_ch_stunt=. if hc70>=9996
replace nt_ch_stunt=1 if hc70<-200 & hv103==1
label values nt_ch_stunt yesno
label var nt_ch_stunt "Stunted child under 5 years"


//Wasted
gen nt_ch_wast= 0 if hv103==1
replace nt_ch_wast=. if hc72>=9996
replace nt_ch_wast=1 if hc72<-200 & hv103==1
label values nt_ch_wast yesno
label var nt_ch_wast "Wasted child under 5 years"


//Underweight
gen nt_ch_underwt= 0 if hv103==1
replace nt_ch_underwt=. if hc71>=9996
replace nt_ch_underwt=1 if hc71<-200 & hv103==1
label values nt_ch_underwt yesno
label var nt_ch_underwt "Underweight child under 5 years"

gen wt=hv005/1000000

*to check the indicators with the final report
tab1 nt_ch_stunt nt_ch_wast nt_ch_underwt [iw=wt]

Hope this help. Please also refer to the links I provided for this and other inquires.

Best,
Shireen Assaf
The DHS Program
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Adding father's information to child information
Next Topic: Information on indicator variables on child health.
Goto Forum:
  


Current Time: Mon Apr 29 05:08:28 Coordinated Universal Time 2024