The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in SPSS » Calculating cases for IYCF
Re: Calculating cases for IYCF [message #15198 is a reply to message #15172] Fri, 15 June 2018 06:10 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2446
Registered: February 2013
Senior Member
Following is a response from Senior Data Processing Specialist, Ladys Ortiz:

The main difficulty with this table is identifying the last child living with the mother. There are very few cases where the youngest child under age 2 is not leaving with their mother. Those few cases are the ones preventing you to match your number with table 11.3. If the youngest child (MIDX=1) is not leaving with the mother or is not alive, we should check if the next to last child (MIDX=2) is alive and living with the mother and so on.

I'm attaching the SPSS syntax and the output for table 11.3 (the % using bottle with nipple is not included in this syntax).
These are the steps I follow to identify the last child alive and living with the mother:

a) I used the women data file (IR) identify the last child living with the mother
b) I create a small data file with the mother id variables + the flag variable
c) I merge the file in point b) with the children data file (KR).
d) Select children alive and age = 0-23 month
e) Create my variables and do table
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Selecting one child per mother
Next Topic: Postnatal care utilization variable in 2015-2016 MDHS dataset
Goto Forum:
  


Current Time: Wed Dec 8 20:16:36 Coordinated Universal Time 2021