The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » Trend analysis for Nutritional status of children
Trend analysis for Nutritional status of children [message #16951] Thu, 14 March 2019 09:45 Go to previous message
Sasmita is currently offline  Sasmita
Messages: 3
Registered: February 2019
Location: China
Dear DHS experts,

I am doing a trend analysis of Nepal DHS data on the nutrition status of under 5 years in different waves from 2001-2016. I merged PR and KR file as I am interested to see both children and maternal-related variables. I am using SPSS.

Problem 1
While working for the data analysis, I could replicate the exact figure from the report for stunting only for the year 2016 data. And could not find a similar figure as in report for other waves (2001, 2011, 2016) with similar consideration. for example, I get 2485 instead of 2475 in 2011 and 5258 instead of 5262 in 2006. I have tried many times and I am taking into consideration:-
a) sample weight variable (HV005/1000000)
b) selected de facto children using HV103

Syntax used for Stunting.

recode hc70 (lo thru -201 = 1) (-200 thru 9990 = 0 ) (else=sysmis) into stunting.
variable labels stunting "Stunting".
value labels stunting 0 "Not stunted" 1 "Stunted".
formats stunting (f1.0).

compute wgt = hv005/1000000.
weight by wgt.

compute filter_$=(hc70 < 9990 & hv103=1).
variable labels filter_$ 'hc70 < 9990 & hv103=1 (FILTER)'.
value labels filter_$ 0 'Not Selected' 1 'Selected'.
formats filter_$ (f1.0).
filter by filter_$.

frequencies stunting.

Problem 2 :
a)Should I merge the HW file to PR file then only merge the combined file to KR file? Or merge HW file with merged datasets of KR and PR file?

I would be grateful if you can share the ideas for solving these issues. I am struggling with this difference in figures.

Thank you.

[Updated on: Thu, 14 March 2019 09:54]

Report message to a moderator

Read Message
Read Message
Read Message
Previous Topic: BMI India 2015
Next Topic: Food security- South Africa DHS 2016
Goto Forum:

Current Time: Wed Aug 17 09:02:32 Coordinated Universal Time 2022