|Trend analysis for Nutritional status of children [message #16951]
||Thu, 14 March 2019 09:45
Registered: February 2019
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.
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_$.
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.
[Updated on: Thu, 14 March 2019 09:54]
Report message to a moderator