The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in SPSS » Indonesia 2017 data set (m4: duration of breastfeeding)
Indonesia 2017 data set [message #17649] Thu, 02 May 2019 02:20 Go to next message
Hai R is currently offline  Hai R
Messages: 13
Registered: March 2018
Location: Brisbane
Member
Dear DHS team,

I would like to ask about Indonesia data set 2017. Variable m4 still have 0-30 beside 93,94,95,96,97,99 (as the only option for m4 based on the provided syntax). Where we should recode them (number 1 - 30?). I understand it is the total month of breastfeeding, however, it is more than 23 months, as I already limited the child age from 0-23 months only.

please, your kind help,

many thanks and warm regards
Re: Indonesia 2017 data set [message #17653 is a reply to message #17649] Thu, 02 May 2019 08:25 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1643
Registered: February 2013
Senior Member

Following is a response from our Research & Data Analysis Director, Tom Pullum:

You should treat those codes the same as out-of-range codes or NA (not applicable), and omit them from all calculations.

Re: Indonesia 2017 data set [message #17683 is a reply to message #17653] Mon, 06 May 2019 19:58 Go to previous messageGo to next message
Hai R is currently offline  Hai R
Messages: 13
Registered: March 2018
Location: Brisbane
Member
Many thanks Bridgette,

will do so,

warm regards
Re: Indonesia 2017 data set [message #17871 is a reply to message #17653] Sun, 30 June 2019 22:16 Go to previous messageGo to next message
Hai R is currently offline  Hai R
Messages: 13
Registered: March 2018
Location: Brisbane
Member
Hi Bridgette,

I have calculated the IYCF core indicator. However, I found sharp increased of continued breastfeeding at 1 year (19%) and 10% of exclusive breastfeeding. Is there any possibility that a revised data set to be published to replace the current one?

Many thanks and warm regards
Ha'i
Re: Indonesia 2017 data set [message #17933 is a reply to message #17871] Fri, 19 July 2019 07:23 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1643
Registered: February 2013
Senior Member
Following is a response from DHS Lead Nutrition Research Associate, Rukundo Benedict:

I re-ran the data and I get what is in the report. Below is the code I used to get my results.

use "C:\Users\39788\ICF\Analysis - Shared Resources\Data\DHSdata\IDKR71FL.DTA" 

*Generate weight variable**
gen wgt=v005/1000000
*Generate age, keep those <2 years
gen age=b19
keep if age<24
*keep only those children alive 
ta b5
keep if b5==1
*Generate age groups
recode age (0/1=1 "0-1")(2/3=2 "2-3")(4/5=3 "4-5")(6/8=4 "6-8")(9/11=5 "9-11")(12/17=6 "12-17")(18/23=7 "18-23"), gen (age_months)
**If drank from bottle with nipple (bottlefeeding)
gen bottle=0
replace bottle=1 if m38==1 
ta age_month bottle  [iw=wgt], row
*Important Note: for the other indicators, children must be the youngest child and living with mother
*keep only those living with mother
keep if b9==0
* finding the youngest child living with the mother
bysort v001 v002 v003: egen minbidx=min(bidx) 
* keep only children less than 2 years 
keep if age<24
ta bidx minbidx 
* need to drop those that are bidx==2 and minbidx==1
drop if bidx>minbidx
ta age_month [iw=wgt]
gen water=0
gen liquids=0
gen milk=0
gen solids=0
gen breast=0
*To determine if child is given water, sugar water, jiuce, tea or other  
replace water=1 if (v409>=1 & v409<=7)
                  
* If given other liquids
foreach xvar of varlist v409a v410 v410a v413*  {
replace liquids=1 if `xvar'>=1 & `xvar'<=7
}
                                                                                          
* If given powder/tinned milk, formula or fresh milk 
foreach xvar of varlist v411 v411a v412 v414p {
replace milk=1 if `xvar'>=1 & `xvar'<=7
}

*If currently breastfeeding
replace breast=1 if m4==95

*CBF at 1 year
gen CBFage=0
replace CBFage=1 if age>11 & age<16
ta CBFage
ta breast CBFage
ta CBFage breast [iw=wgt], row
Re: Indonesia 2017 data set [message #17938 is a reply to message #17871] Sat, 20 July 2019 01:27 Go to previous message
Hai R is currently offline  Hai R
Messages: 13
Registered: March 2018
Location: Brisbane
Member
Hi Bridgette,

many thanks,

I have re-run my analysis with your syntax, they are working well now.

My syntax are the same, except for the two indicators, I have slightly different approach, here is my syntax:

*3. Continued Breastfeeding at 1 year at children 12-15 months(CBF1)
recode age (0/5=0 "0-5") (6/8=1 "6-8")(9/11=2 "9-11")(12/15=3 "12-15")(16/23=4 "16-23"), gen (child_age2)
tab child_age2 [iw=rweight]

tab m4 [iw=rweight]
recode m4 (93/94=0 "No") (95=1 "Yes") (else=.) if child_age2==3, gen (CBF)
label variable CBF "Continued Breastfeeding at 1 year"
tab CBF [iw=rweight]


*4. Introduction of solid, semi-solid or soft foods (ISSSF) ; Proportion of infants 68 months of age who received solid, semi-solid or soft foods during the previous day
tab m39 [iw=rweight]
recode m39 (0=0 "No") (1/7=1 "Yes") (8=.) if child_age2==1, gen (ISSSF)
label variable ISSSF "Introduction of solid, semi-solid or soft foods"
tab ISSSF [iw=rweight]


many thanks for your advice,

warm regards
Ha'i
Previous Topic: Spss syntax to generate table 4.3 Ghana DHS 2014
Next Topic: complex sample
Goto Forum:
  


Current Time: Mon Jul 22 08:51:07 Eastern Daylight Time 2019