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: 1667
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: 1667
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 messageGo to next 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
Re: Indonesia 2017 data set [message #17980 is a reply to message #17933] Wed, 07 August 2019 11:32 Go to previous messageGo to next message
lhuri is currently offline  lhuri
Messages: 9
Registered: December 2014
Location: Indonesia
Member
Dear Bridgette,

I'd like to ask why the number of "mothers who ever breastfed" is different between my result (6394 using IR file; 6456 using KR file), English version of IDHS 2017 report (6284), and Indonesian version of IDHS 2017 (6291).

I tried a few approaches including the one instructed by the guideline ( https://www.dhsprogram.com/Data/Guide-to-DHS-Statistics/inde x.htm#t=Initial_Breastfeeding.htm).
For further reference, the number is listed in Table 11.1 on page 210 (Indonesian ver) and 191 (English ver). Here are the links to both reports.
IDHS 2017 English (https://dhsprogram.com/pubs/pdf/FR342/FR342.pdf)
IDHS 2017 Indonesian (http://sdki.bkkbn.go.id/files/buku/2017IDHS.pdf)

Apologies if I have missed anything. Looking forward to your kind assistance.
Thank you,
Lhuri
Re: Indonesia 2017 data set [message #18018 is a reply to message #17980] Sat, 17 August 2019 14:21 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1667
Registered: February 2013
Senior Member

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

The following lines will match the 6284 in table 11.1 of the DHS report:

tab m4_1 if b19_01<24 [iweight=v005/1000000]
label list M4_1

tab m4_1 if b19_01<24 & m4_1~=94 [iweight=v005/1000000]

The youngest child is the one with subscript _1 or _01, and "last two years" is given by "b19_01<24". I suspect that you were not using b19, which uses information about the day of birth, not just the month of birth. It is now the preferred way to get the age of the child in months. 94 is the code for m4="never breastfed".

We have found other discrepancies between the version of the report on our website and the version on the BKKBN website. I cannot explain these differences. Perhaps the Indonesian report was prepared from a slightly different version of the data files.

Sometimes there is a discrepancy between one of our reports and what's on StatCompiler. When that happens we recommend the StatCompiler estimates.

Re: Indonesia 2017 data set [message #18032 is a reply to message #18018] Thu, 22 August 2019 08:43 Go to previous message
lhuri is currently offline  lhuri
Messages: 9
Registered: December 2014
Location: Indonesia
Member
Dear Bridgette and Tom,

Thanks for explaining, that's very helpful. Sorry, my previous numbers (6394 and 6456) were irrelevant as I excluded some missing data from related questions and those came from the unweighted count of 0-24 months babies, so please ignore them.

I now have got the same figure as the report (6284) using your commands in IR file. I don't think age in month or days makes the difference. This is because I previously used v222 instead of b19 but now I get the same result too (6284) with the commands below:
tab m4_1 if v222<24 & m4_1~=94 [iweight=v005/1000000]
or
svy: tab m4_1 if v222<24 & m4_1~=94, count

However, if age in days is the preferred variable, I'll use b19 from now on.


My further questions would be:
1. I notice that with the command that you gave me, 4.5 of 6284 babies were of unknown breastfeeding status, meaning that 4.5 mothers answered "don't know" if they ever breastfed their babies. Is that correct? If yes, shouldn't they be excluded from the ever-breastfed count?

2. Should I use IR file for breastfeeding analysis? This is because when I ran your command in KR file (the dataset recommended by the guide https://www.dhsprogram.com/Data/Guide-to-DHS-Statistics/inde x.htm#t=Initial_Breastfeeding.htm) the result is different, which is 6398. For further reference, I modified it into the command below to match the variable names:
tab m4 if b19<24 & m4~=94 [iweight=v005/1000000]

3. I tried to get the percentage of babies who received prelacteal feed using the commands below, but neither gave 43.9% as shown in the report (IDHS 2017, English ver, table 11.1, p 191). Kindly explain further or let me know if I ran the wrong commands.
Command 1: 44.70%
tab m55_1 if b19_01<24 [iweight=v005/1000000]

Command 2: 44.67%
keep if m4_1~=94
keep if m4_1~=98
keep if m4_1~=99
tab m55_1 if b19_01<24 [iweight=v005/1000000]

Thank you.

Previous Topic: Data selection in SPSS
Goto Forum:
  


Current Time: Tue Sep 17 23:46:52 Eastern Daylight Time 2019