calculating height for age for children in Ghana [message #11335] |
Mon, 05 December 2016 18:00 |
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 #22491 is a reply to message #11443] |
Sat, 20 March 2021 01:29 |
chande
Messages: 12 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 #22508 is a reply to message #22497] |
Mon, 22 March 2021 10:49 |
Trevor-DHS
Messages: 802 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).
|
|
|