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: 746
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: 746
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
Hassen
Messages: 112
Registered: April 2018
Location: Ethiopia,Africa
Senior Member
Thank you Trevor!!

Hassen Ali(Chief Public Health Professional Specialist)
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 messageGo to next message
alohciN is currently offline  alohciN
Messages: 13
Registered: March 2019
Member
Hi

Have you received any solution for this question?
Re: calculating height for age for children in Ghana [message #22491 is a reply to message #11443] Sat, 20 March 2021 01:29 Go to previous messageGo to next message
amazia is currently offline  amazia
Messages: 8
Registered: March 2021
Member
Hi

I am trying to check the impact of water sanitation and hygiene on child health(diarrhea, stunting, wasting ). Should i use the PR file and how to select only the de facto children.
Should i use PR file only or other files too for merging ? As i want to find relationship between child health and other household characteristics (Water, Sanitation, mother age & education, father age & education, number of households, nutritional knowledge of mother, decision making of mother, breastfeeding). I need assistance regarding which file to use for above variables and which variables do i need to generate and which are already available in data files.
Re: calculating height for age for children in Ghana [message #22494 is a reply to message #11362] Sat, 20 March 2021 03:44 Go to previous messageGo to next message
amazia is currently offline  amazia
Messages: 8
Registered: March 2021
Member
why we use the de facto children
Re: calculating height for age for children in Ghana [message #22495 is a reply to message #22491] Sat, 20 March 2021 03:57 Go to previous messageGo to next message
alohciN is currently offline  alohciN
Messages: 13
Registered: March 2019
Member
The KR file provides information on the height for age z score (hw70).
Re: calculating height for age for children in Ghana [message #22496 is a reply to message #22495] Sat, 20 March 2021 04:02 Go to previous messageGo to next message
amazia is currently offline  amazia
Messages: 8
Registered: March 2021
Member
Thank you.
But in this thread above it is mentioned to use PR file for stunting, wasting etc. Can you please clarify
Re: calculating height for age for children in Ghana [message #22497 is a reply to message #22496] Sat, 20 March 2021 04:09 Go to previous messageGo to next message
alohciN is currently offline  alohciN
Messages: 13
Registered: March 2019
Member
Both the PR and KR file recorded the height for age z scores. In the KR file, it's labelled hw70 and in the PR (hc70). You can use either one depending on your research. You should check the DHS program.com to see how to calculate stunting and wasting.

Hope this is helpful.

Goodluck!

Kind Regards,
Nichola

[Updated on: Sat, 20 March 2021 04:09]

Report message to a moderator

Re: calculating height for age for children in Ghana [message #22508 is a reply to message #22497] Mon, 22 March 2021 10:49 Go to previous message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 746
Registered: January 2013
Senior Member
As mentioned by Nichola, you can use either the PR file or the KR file, but you should be aware of the difference. The PR file is the main file and contains entries for all usual household members plus visitors who stayed overnight. The KR file is a restricted subset of the children, limited to children whose mothers were interviewed. If you are using the PR file this includes both de jure and de facto household members, and you need to select for one of these two groups. Both are valid groups of the population and either could be used, however, as the children are weighed and measured for the anthropometry, de facto members are more likely to be available for measurement than de jure members as they were physically in the household the night before the survey (the de jure, non-de facto children are less likely to be measured). In practice most household members are both de jure and de facto - there is usually a 90-95% overlap between these two groups. You do have to select one of the two groups though as not selecting the group would include double counting of the population (effectively counting something like 105% of the population as some people can be de jure members in one household and de facto members in another household).

For most analyses of stunting and wasting we recommend that you use the PR file, however, the data on diarrhea that you mention is only available in the KR file, so for this analysis you will need to use the KR file. When using the KR file, you don't need to worry about whether you use de jure or de facto as the women's file is restricted to de facto women and the KR file includes the children of these women. If you want to use the water and sanitation indicators you would need to link the water and sanitation data from the HR file to the KR file (using the cluster number and household number as the keys for merging).
Previous Topic: Child Health and WASH
Next Topic: ANC
Goto Forum:
  


Current Time: Wed May 12 09:40:09 Coordinated Universal Time 2021