The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in SPSS » analysis of data of children
analysis of data of children [message #1513] Wed, 05 March 2014 15:18 Go to previous message
Messages: 5
Registered: February 2014
Location: Netherlands
I am involved in a national food security survey implemented by SETSAN, the governmental agency for food security in Mozambique. The sample design of the survey is similar to the sample of the Mozambican DHS 2011 (and the Kyrgyz DHS). In order to test my analysis plan for SPSS complex samples I am trying to replicate some figures in the sampling errors chapter in the report of the recent Kyrgyz DHS. This works well for household and women related variables, but I fail to reproduce the figures related to nutritional status of the under-five children, e.g. height-for-age (% <-2SD). I wonder what I do wrong and hope you can give me some advice.
I used file KYKR60FL.SAV. Regarding the CS analysis plan, I used V022 for strata, V001 for clusters and V005 for sample weight; estimation method was WR. I was in doubt about which variable to use to calculate the prevalence of low height-for-age (H/A<-2SD): HW5 or HW70, but decided to use HW70 because it uses WHO 2006 as reference and excludes cases with values out of plausible limits. Then I computed a new dichotomous variable with value 1 for H/A < -200 and value 0 for H/A>= -200, and recoded 9996-9998 to missing. This resulted in 4016 valid cases (plausible values) out of a total of 4363 cases (of which 293 are missing: 120 user missing and 173 system missing). To compute the frequencies of low height-for-age (<2SD) I use Complex Samples with the above defined analysis plan, then use Frequencies, and use variable V024 (Region) for Subpopulations to compute the prevalence and error for the provinces.

The first thing that strikes me is that the Kyrgyz DHS report mentions 4337 cases for the analysis of the height-for-age variable, which is much more than the number of 4016 cases with valid anthropometric indices that I arrived at myself. Secondly, and probably not surprisingly, my estimates and errors do not correspond with the figures in the Kyrgyz report, particularly for the provinces.

I wonder what I did wrong. Did I use the wrong data file, or the wrong variable (HW70), or was the recoding of HW70 not correct? Was the CS plan of analysis correct (for example, was it appropriate to use V022 for sample weight)?

I would be very happy if you could help me out. It is important to us because we have to present figures at province level besides at national level and (national) urban/rural, and would like to compare our data with those of the Mozambique DHS 2011.

Thank you very much in advance.
Read Message
Read Message
Previous Topic: Antenatal care vs infant mortality -Kenya
Next Topic: Merge household and child datasets in spss
Goto Forum:

Current Time: Fri Sep 24 01:47:18 Coordinated Universal Time 2021