The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » Nutritional status of children (Height-for-age)
Nutritional status of children (Height-for-age) Wed, 20 December 2017 17:29
 rhuang Messages: 12Registered: April 2017 Member
Hello,

I am trying to re-create Table 11.1 (Page 149) in the Rwanda 2014-2015 DHS report. I am specifically looking at the height-for-age variable and I am trying to figure out which variable was used in the Rwanda 2014-2015 data set to obtain these results. I was using the variable hw5 (in the KR: Children's recode data file) which measures the height/age standard deviation (from the reference mean) but I noticed that when I did a quick tabulation of this variable that the total number of children was only 3,524 while in the report the total number of children is 3,813. I did recode the variables=9998 to missing so that these would be eliminated from my calculations. Where is this 3,813 number of children coming from? Or am I using the wrong variable?

I am trying to calculate the percentage of children stunted (<-2 s.d.) and severely stunted (<-3 s.d.) based on this data, which the report suggests is 37.9% of children and 13.5% of children respectively.

Thank you,

Rachel
Re: Nutritional status of children (Height-for-age) [message #14665 is a reply to message #13771] Thu, 26 April 2018 12:49
 Hope Messages: 7Registered: April 2018 Member
Hello,

@Rachel, did you find the solution to the unmatching numbers? I am asking because I think I am in the same situation now. For you, I think you could have used the PR recode file instead of the KR file.

In my case, I would like to get the total percentage of stunted children as mentioned in the Rwanda DHS 2015.
I used the variable HC70 which is in the PR recode file (I read somewhere on the forum that DHS uses the household member recode file for calculation of child anthropometry).

The total number of children in the report is indeed 3813. But when I check the total number of children for the variable HC70 in the PR file, it is 3825.
Thus, the percentage I am getting for stunted children is 37.5% which is slightly different from the one reported of 37.9%. If I calculate stunting per the two categories, severely stunted and moderately stunted I get the same percentage (13.5%) for severely stunted as the one in the report. When I add up the % of severe (13.5%) and moderate stunting (24.1%) I obtained, I get a prevalence of 37.6%. So the mismatch (of around 0.3 to 0.4%) is coming from the calculation of moderately stunted children.

Please members clarify for me where I am getting it wrong.

Thanks,
Hope
Re: Nutritional status of children (Height-for-age) [message #14668 is a reply to message #14665] Thu, 26 April 2018 14:36
 rhuang Messages: 12Registered: April 2017 Member
Hope,

I was using the KR file and the same variable but in that file it is called hw70, because I needed those other variables related to children. It is odd that the number of children with height-for-age data differs in the children's recode (KR file) and the personal recode (PR file).

Looking at the data in the PR file, I can see that if you define moderate stunting (based on hc70/100) as <=-2 standard deviations then you should get that result that 37.93% of children are moderately stunted. Granted, these tables are not using weights (I presume), so the percentage values could differ based on whether or not you are using weights.

-Rachel
Re: Nutritional status of children (Height-for-age) [message #14676 is a reply to message #14668] Fri, 27 April 2018 14:29
 Hope Messages: 7Registered: April 2018 Member
Rachel,

Thank you for clarifying for me. I now obtained the same percentage as in the DHS report! In the tables, the weights are not considered indeed.

Hope it helps also!

Hope

[Updated on: Fri, 27 April 2018 14:31]

Report message to a moderator

Re: Nutritional status of children (Height-for-age) [message #15259 is a reply to message #14676] Wed, 20 June 2018 05:58
 Hope Messages: 7Registered: April 2018 Member
In case, someone else reads this thread, I am posting this message to correct a mistake above:

To estimate the number of stunted children correctly as in the DHS report,
1. You have to use the weight variable (HV005/1000000)
2. You have to select de facto children using HV103.

In the message above, I had obtained the same percentage of stunted children (37.9%) as in Table 11.1 of Rwanda DHS 2014-15, but the denominator I had was 3825 instead of 3813 (reported).
After taking into account de facto children, I came up with the same percentage and also the same denominator as in the DHS report.

Check Trevor response here for the exact code to use: https://userforum.dhsprogram.com/index.php?t=msg&th=7084 &#msg_15090
Re: Nutritional status of children (Height-for-age) [message #15310 is a reply to message #15259] Wed, 27 June 2018 16:22
 Liz-DHS Messages: 1351Registered: February 2013 Senior Member
Thank you for your post Hope.
Re: Nutritional status of children (Height-for-age) [message #15699 is a reply to message #14665] Sat, 01 September 2018 08:15
 rrutayisire Messages: 2Registered: August 2018 Location: Kigali Member

Hello,
Hello, dear Hope. I am Reverien Rutayisire. Please, if you have time, can you show me how to calculate (compute) using Stata or SPSS the stunting prevalence rate using the 2005 Rwanda Demographic and Health Survey dataset? I thank you in advance, dear Hope. I need urgently to know how it was calculated given that it was before the 2006 WHO Standards.

Reverien
Re: Nutritional status of children (Height-for-age) [message #15749 is a reply to message #15699] Mon, 10 September 2018 12:42
 Liz-DHS Messages: 1351Registered: February 2013 Senior Member