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 |
Hai R
Messages: 15 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 #17933 is a reply to message #17871] |
Fri, 19 July 2019 07:23 |
Bridgette-DHS
Messages: 3203 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 |
Hai R
Messages: 15 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 #18032 is a reply to message #18018] |
Thu, 22 August 2019 08:43 |
lhuri
Messages: 16 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.
|
|
|
|
|
Goto Forum:
Current Time: Sun Dec 8 03:52:00 Coordinated Universal Time 2024
|