The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » Additional information on Cambodia DHS 2014 report and data set
Re: 'age in month of children' variable on child development in Cambodia DHS 2014 report and data set [message #15423 is a reply to message #15389] Tue, 17 July 2018 12:04 Go to previous messageGo to previous message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 787
Registered: January 2013
Senior Member
There are a number of issues:
1) Data were collected for children age 3-5 years (36-71 months), but are presented for children age 36-59 months, so you need tyo select only those cases.
2) You are looking at the HW1 series of variables for age in months, but this is only for children weighed and measured, and I believe that was just a subsample of the full sample, so you won't find age for all children there.
3) You are setting your variable age_36_59 to 1 if any of the children in the HW1 series is age 36-59. Rather you need to identify the correct child. If you look at the questionnaire at the end of the report you will see in filter 570 that based on Q217 the youngest child age 3, 4 or 5 years was selected.

Below I am providing some code for correctly setting the age of the child and selecting the cases used in the tabulation:
* Open the dataset.
get file='KHIR73FL.SAV'.

* Age of youngest child age 3-5.
* Create a vector of the date of birth variables from the birth history.
vector B3 = B3$01 to B3$20.
* Select the birth date of the index child, based on S570A.  If 1 uses B3$01, if 2 uses B3$02, etc.
if (not sysmis(S570A)) birthdate = B3(S570A).
* calculate the age of the child.
compute age = v008 - birthdate.
compute agegroup = trunc(age/12).
variable labels agegroup 'Age in months'.
value labels agegroup 3 '36-47' 4 '48-59' 5 '60-71'.

* filter for children age 36-59 months.
use all. 
compute filter_$=(age < 60). 
filter by filter_$. 

* weight the data.
compute wgt = v005/1000000.
weight by wgt.

* check the counts.
freq agegroup.
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: seeking help variable
Next Topic: Combining twins into single delivery events
Goto Forum:
  


Current Time: Thu Mar 28 10:42:50 Coordinated Universal Time 2024