The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Kenya » KDHS 2022: Table 11.12 Micronutrient supplementation and deworming among children
KDHS 2022: Table 11.12 Micronutrient supplementation and deworming among children [message #28232] Mon, 04 December 2023 10:56 Go to next message
sokiya is currently offline  sokiya
Messages: 78
Registered: May 2017
Location: Nairobi
Senior Member
Hi,
I am trying to replicate in the column "Percentage given vitamin A supplements in last 6 months" in Table 11.12 using the code below taken from DHS GitHub repository

use "$KEKR8AFL.dta", clear
**** child's age ****
gen age = v008 - b3


//Received Vit. A supplements
recode h33m (98=.), gen(h33m2)
recode h33d (98=15), gen(h33d2)
recode h33y (9998=.), gen(h33y2)
*gen nt_ch_micro_vas= h34==1 | (int((v008a - (mdy(h33m2,h33d2,h33y2) + 21916) )/30.4375) < 6) 
gen nt_ch_micro_vas= h34==1 | (int((mdy(v006,v016,v007) - mdy(h33m2,h33d2,h33y2) )/30.4375) < 6)
replace nt_ch_micro_vas=. if !inrange(age,6,59) | b5==0
label values nt_ch_micro_vas yesno 
label var nt_ch_micro_vas "Children age 6-59 mos given Vit. A supplements"

with no success. Any help will be greatly appreciated.
Re: KDHS 2022: Table 11.12 Micronutrient supplementation and deworming among children [message #28245 is a reply to message #28232] Tue, 05 December 2023 11:06 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 members, Tom Pullum and Keith Purvis:

You need to use b19, rather than v008-b3, for age in months.

There is NOT a problem with the DHS construction of this indicator. To construct it, you use the interval since the date on the health card, and you ALSO use h34, which is based on a separate question about whether there was a vitamin A supplement in the past 6 months. The Stata code below will match the 4th and 5th columns in Table 11.12 of the Kenya 2022 final report.

* Construct indicator for Vitamin A supplement in the past 6 months, children under 5
* Table 11.12, Kenya 2022 DHS Survey

use "...KEKR8BFL.DTA", clear 

gen vas=0 if b5==1 & b19>=6 & b19<=59 
label variable vas "Received Vitamin A supplement"

replace h33d=15 if h33d==98
replace h33m=.  if h33m==98
replace h33y=.  if h33y==9998

replace vas=1 if vas==0 & h33>=1 & h33<=3 & (mdy(v006,v016,v007)-mdy(h33m,h33d,h33y)<6*30.4375)
replace vas=1 if vas==0 & h34==1

tab v190 vas [iweight=v005/1000000], row




[Updated on: Thu, 07 December 2023 11:09]

Report message to a moderator

Re: KDHS 2022: Table 11.12 Micronutrient supplementation and deworming among children [message #28309 is a reply to message #28232] Mon, 11 December 2023 12:29 Go to previous message
sokiya is currently offline  sokiya
Messages: 78
Registered: May 2017
Location: Nairobi
Senior Member
Thanks so much for the guidance. I am sincerely grateful.
Previous Topic: Average number of school years
Next Topic: Merging Aggregate Group Data with V613 Responses
Goto Forum:
  


Current Time: Fri Nov 22 19:29:23 Coordinated Universal Time 2024