The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Kenya » IYCF - MAD indicator
IYCF - MAD indicator [message #28829] Sat, 16 March 2024 05:58 Go to next message
geoK is currently offline  geoK
Messages: 56
Registered: May 2014
Senior Member
Hello, I am trying to replicate the indicator Minimum Acceptable Diet (childre 6-23 months) using the latest DHS survey round (2022). The indicator should be 30.7% (Table 11.8 Final Report), while I am getting roughtly half of it by using the GitHub code.

Specifically, I run the !NTmain.do code where I deactivate those commands for creating indicators I am not interested in (as i only want to get MAD). I therefore only use KEKR8BFL.dta file and the NT_IYCF.do file.

The discrepancy I observe seems to me to be due to the miscalculation of the denominator: I get almost double the cases (Number of all children age 6-23 months) and about 15% MAD.

Do I have to necessarely run all the do files included in the Chap11_NT/DHS8/ repository to get the right figures, or could the mismatch be due to something else?

Many thanks!

[Updated on: Sun, 17 March 2024 13:27]

Report message to a moderator

Re: IYCF - MAD indicator [message #28846 is a reply to message #28829] Mon, 18 March 2024 15:42 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

I recommend that you try what you said--run the entire Main program even though you don't want all the indicators. It is quite possible that something is buried in the code for an earlier indicator that affects your results for MAD. Please let us know if you still have this discrepancy after trying that.
Re: IYCF - MAD indicator [message #28847 is a reply to message #28846] Mon, 18 March 2024 16:00 Go to previous messageGo to next message
geoK is currently offline  geoK
Messages: 56
Registered: May 2014
Senior Member
Hello and thanks for the answer. I did try running the entire code after posting here, but unfortunately I still get the same discrepancies. I am probably doing something wrong, but I am running out of ideas.

Any further advice on how to match the report numbers?

Thanks again for your time and assistance.

[Updated on: Wed, 20 March 2024 04:34]

Report message to a moderator

Re: IYCF - MAD indicator [message #28955 is a reply to message #28847] Wed, 03 April 2024 04:06 Go to previous messageGo to next message
geoK is currently offline  geoK
Messages: 56
Registered: May 2014
Senior Member

Dear Staff,
as I am still struggling with this same issue, I was wondering if I could get some assistance please. Many thanks!
Re: IYCF - MAD indicator [message #28959 is a reply to message #28955] Wed, 03 April 2024 08:46 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
Following is a response from Senior DHS staff member, Tom Pullum:

Sorry you are having difficulty. It appears that there was some subsampling for the questions on diet. If you enter "tab m55,m" , for example, you will see that many children do not have a response (from the mother) for "anything other than breast milk". I propose that you use the following lines to identify the youngest child age 0-23 months living with the mother AND with an IYCF response:
use "...KEKR8BFL.DTA", clear 
sort v001 v002 v003 bidx
egen sequence=seq() if b9==0 & b19>=6 & b19<=23 & m55<., by(v001 v002 v003)
gen in_sample=1 if sequence==1
tab in_sample [iweight=v005/1000000]

Please let us know if this does not give a match.

[Updated on: Wed, 03 April 2024 08:53]

Report message to a moderator

Re: IYCF - MAD indicator [message #28963 is a reply to message #28959] Wed, 03 April 2024 10:35 Go to previous messageGo to next message
geoK is currently offline  geoK
Messages: 56
Registered: May 2014
Senior Member
Many thanks for your quick response and for the help here! I'll try this and let you know if works.

Best regards
Re: IYCF - MAD indicator [message #29004 is a reply to message #28959] Wed, 10 April 2024 03:02 Go to previous message
geoK is currently offline  geoK
Messages: 56
Registered: May 2014
Senior Member
Thanks again for the suggestions here. This worked! Best regards
Previous Topic: KDHS 2022 Table 17.1 Experience of physical violence by any perpetrator
Next Topic: KDHS 2022 Gender Based Violence Indicators
Goto Forum:
  


Current Time: Tue Nov 26 00:17:14 Coordinated Universal Time 2024