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)
| Newborn birthweight calculation for Ethiopian 2000, 2005, 2011 and 2016 DHS [message #20059] |
Tue, 22 September 2020 08:44  |
id709nvz
Messages: 43
Registered: March 2019
|
Member |
|
|
Dear All,
I am considering the Ethiopian DHS collected in 2000, 2005, 2011 and 2016.
How do I can create a variable measuring newborn birthweight in each survey round in stata?
It would be good if the variable is categorized as stunting, normal, wasting etc
I then would like to combine them to study intergenerational effects of better healthcare services by the mothers.
.....................
Thank you in advance!
|
|
|
|
|
|
| Re: Newborn birthweight calculation for Ethiopian 2000, 2005, 2011 and 2016 DHS [message #20081 is a reply to message #20073] |
Wed, 23 September 2020 13:24  |
id709nvz
Messages: 43
Registered: March 2019
|
Member |
|
|
Thank you for your reply and suggestion.
I just looked at the survey reports in each round. Basically,
those (stunting, wasting, underweight and overweigh)are the indicators I would like to have in my analysis.
How can I create (in stata) Stunting, based on a child's height and age, Wasting,
based on a child's weight and height, Underweight, based on weight and age for each Ethiopian DHS round?
Kind regards
|
|
|
|
| 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 |
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
|
|
|
|
|
|
| Re: Newborn birthweight calculation for Ethiopian 2000, 2005, 2011 and 2016 DHS [message #20128 is a reply to message #20109] |
Mon, 28 September 2020 10:15 |
Shireen-DHS
Messages: 140
Registered: August 2020
Location: USA
|
Senior Member |
|
|
Hello,
In this case you should use KR file instead of PR file and no need to merge PR and IR. The stunting, wasting, underweight variables in the KR are hw70, hw71, hw73 and can be coded the same way I showed you for the PR file but without the hv103 condition. The KR file is the file for children under five that are the children of interviewed defacto women. So the characteristics of their mothers are in the file, for example her education v106 or her body mass index (bmi) v445. Please check the Guide to DHS Statistics on the description of women's bmi : https://www.dhsprogram.com/Data/Guide-to-DHS-Statistics/inde x.htm#t=Nutritional_Status.htm%23Percentage_of_women_bybc-2& amp;rhsearch=v444&rhtocid=_14_9_1
If you use the KR file the unit of analysis is the child not the women, which I believe is your research interest.
Best,
Shireen
The DHS Program
|
|
|
|
| Re: Newborn birthweight calculation for Ethiopian 2000, 2005, 2011 and 2016 DHS [message #20129 is a reply to message #20128] |
Mon, 28 September 2020 10:45 |
id709nvz
Messages: 43
Registered: March 2019
|
Member |
|
|
Dear Shireen
Thank you very much for your reply.
I was somehow not clear with what I want (in my earlier questions). I have thought of the same thing.
let me be precise, my causal variable of interest is asked to women and not of anyone. Thus, I use combined IR files across survey (2000, 2005, 2011 and 2016).
Initially, I studied the effect of my causal variable on some characteristics of mother's for instance BMI using combined IR files only. Now I like to extend the analysis to see intergenerational effects of the variable on child growth measures (stunting, wasting and so on). In my view, to get my causal variable of interest in the KR files it must be merged with combined IR files isn't it?
So, I should first link the mothers in IR with children's in KR files. (again I am using all Ethiopian DHS survey, because my causal policy wasn't in place before 2011, I am using a sort of Diff in Diff analysis where post intervention is 2011 and 2016)
Could you please kindly suggest how to do that in stata linking mothers in IR with that of children with BMI measures?
Thanks for sharing your knowledge.
|
|
|
|
| Re: Newborn birthweight calculation for Ethiopian 2000, 2005, 2011 and 2016 DHS [message #20130 is a reply to message #20129] |
Mon, 28 September 2020 10:53 |
Shireen-DHS
Messages: 140
Registered: August 2020
Location: USA
|
Senior Member |
|
|
Hello,
If your unit of analysis is the women, you can can use the IR file and have the information of the child's stunting, wasting, and underweight in hw70_1, hw71_1, and hw72_1. This would be for the most recent birth. So need to merge. The information about the children is in the IR file but with underscore to indicate which child. I advise that you read more about file structure in the Guide to DHS statistics Chapter 1 but especially this section ( https://www.dhsprogram.com/Data/Guide-to-DHS-Statistics/inde x.htm#t=Organization_of_DHS_Data.htm)
Good luck.
Best,
Shireen
The DHS Program
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sun Dec 22 20:30:13 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
