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  |
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  |
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 |
|
|
|
|
|
Goto Forum:
Current Time: Tue Nov 26 08:05:19 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
