The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » calculating height for age for children in Ghana
calculating height for age for children in Ghana [message #11335] Mon, 05 December 2016 18:00 Go to next message
sammy nyarko
Messages: 5
Registered: December 2016
Location: Ghana
Member
Good evening all
I am currently working on the relationship between child health and dwelling characteristics. in other to find this relationship i merged both the HR and KR recode files. in my analysis of child health, i used the anthropocentric indicators (height for age, weight for age, and weight for height). i would really appreciate it, if i can get help on calculating the anthropocentric indicators. it tried using the commands below in STATA but did not follow the tables in the DHS report for Ghana.

***height_for_age_z_score (new_who)***
tostring hw70, gen (h_w)
destring h_w, gen (HAZ)
drop h_w
tab HAZ
replace HAZ=. if HAZ==9996 |HAZ==9998
gen height_for_age= HAZ/100

***weight_for_age_z_score (new_who)***
tostring hw71, gen (h_w)
destring h_w, gen (WAZ)
drop h_w
tab WAZ
replace WAZ=. if WAZ==9996 |WAZ==9998
gen weight_for_age= WAZ/100

***weight_for_height_z_score (new_who)***
tostring hw72, gen (h_w)
destring h_w, gen (WHZ)
drop h_w
tab WHZ
replace WHZ=. if WHZ==9996 |WHZ==9998
gen weight_for_height= WHZ/100



***classifications***
fre weight_for_age
drop if weight_for_age ==.
tab weight_for_age
gen underweight = weight_for_age < -2
tab underweight
drop if weight_for_height ==.
tab weight_for_height
tab height_for_age
fre height_for_age
gen wasted = weight_for_height < -2
tab wasted
gen stunted = height_for_age < -2


after running the commands above my unweighted "tab stunted" was 19.19, while the "tab stunted [iweight=wgt]" was 17.97. instead of 18.8 reported in the DHS report.

Any help?
Re: calculating height for age for children in Ghana [message #11362 is a reply to message #11335] Fri, 09 December 2016 11:41 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 669
Registered: January 2013
Senior Member
You need to use the anthropometric data from the PR file. See variables HC70 - HC72. Also make sure that you select only the de facto children.
Re: calculating height for age for children in Ghana [message #11389 is a reply to message #11362] Sat, 10 December 2016 07:51 Go to previous messageGo to next message
sammy nyarko
Messages: 5
Registered: December 2016
Location: Ghana
Member
the you very much. but can you help me with the calculation of stunting, wasting and underweight?

i would be happy if you send me the STATA commands too.
Re: calculating height for age for children in Ghana [message #11443 is a reply to message #11389] Wed, 21 December 2016 16:54 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 669
Registered: January 2013
Senior Member
See the below code:
use "GHPR70FL.DTA", clear
* create variable for stunting and set it to missing
gen stunted = .
* set to 0 (Not stunted) if it has a valid measure
replace stunted = 0 if hc70 < 9990
* set to 1 (Stunted) if it is less than -2 SD (data are stored with two implied decimal places, and thus appear as -200)
replace stunted = 1 if hc70 < -200
* tabulate stunting for children under age 60 months who stayed in the household the previous night and have valid measures
tab stunted if hc1 < 60 & hv103==1 & hc70 < 9990 [iw=hv005/1000000]

You would use the same approach for wasting and underweight.
Re: calculating height for age for children in Ghana [message #11466 is a reply to message #11443] Wed, 28 December 2016 18:37 Go to previous messageGo to next message
sammy nyarko
Messages: 5
Registered: December 2016
Location: Ghana
Member
Thank you very much!!
Re: calculating height for age for children in Ghana [message #14969 is a reply to message #11466] Tue, 22 May 2018 17:43 Go to previous messageGo to next message
sadya2018@gmail.com
Messages: 98
Registered: April 2018
Location: Ethiopia, in Africa
Senior Member
Thank you Trevor!!

Hassen Ali Hamza (BSc in Public Health,Master of Public Health Candidate)
Re: calculating height for age for children in Ghana [message #17873 is a reply to message #11335] Mon, 01 July 2019 11:05 Go to previous message
alohciN is currently offline  alohciN
Messages: 7
Registered: March 2019
Member
Hi

Have you received any solution for this question?
Previous Topic: Height for weight Z score for child
Next Topic: Vaccination (Table 10.4) - SADHS 2016
Goto Forum:
  


Current Time: Mon Oct 14 02:39:10 Eastern Daylight Time 2019