| Issue with calculating full immunization rates in NFHS-5 (India) using KR file [message #31376] |
Fri, 05 September 2025 01:30 |
MohsinSiddiqui
Messages: 1
Registered: September 2025
|
Member |
|
|
Hi Team,
I am working with the NFHS-5 (India) KR file in Stata to calculate the percentage of children aged 1223 months who are fully immunized.
I filtered children aged 12-23.
I used the following vaccination variables
h2 (BCG)
h3, h5, h7 (pentavalent/DPT doses 1-3)
h4, h6, h8 (polio doses 1-3, excluding birth dose)
h9 (measles-rubella or measles-containing vaccine)
I used the following stata commands
1. Filter the Sample 12-23 months
keep if b5 == 1 & b19 >= 12 & b19 <= 23
2. Define Vaccination Receipt
gen bcg = (h2 == 1 | h2 == 2 | h2 == 3) if h2 < 8 & !missing(h2)
gen dpt1 = (h3 == 1 | h3 == 2 | h3 == 3) if h3 < 8 & !missing(h3)
gen dpt2 = (h5 == 1 | h5 == 2 | h5 == 3) if h5 < 8 & !missing(h5)
gen dpt3 = (h7 == 1 | h7 == 2 | h7 == 3) if h7 < 8 & !missing(h7)
gen pol1 = (h4 == 1 | h4 == 2 | h4 == 3) if h4 < 8 & !missing(h4)
gen pol2 = (h6 == 1 | h6 == 2 | h6 == 3) if h6 < 8 & !missing(h6)
gen pol3 = (h8 == 1 | h8 == 2 | h8 == 3) if h8 < 8 & !missing(h8)
gen measles = (h9 == 1 | h9 == 2 | h9 == 3) if h9 < 8 & !missing(h9)
3.Define Full Immunization
gen full_imm = (bcg == 1 & dpt1 == 1 & dpt2 == 1 & dpt3 == 1 & pol1 == 1 & pol2 == 1 & pol3 == 1 & measles == 1) ///
if !missing(bcg, dpt1, dpt2, dpt3, pol1, pol2, pol3, measles)
label define yesno 0 "Not fully immunized" 1 "Fully immunized"
label values full_imm yesno
4.Apply Sample Weights and Survey Design
gen wt = v005 / 1000000
svyset v021 [pweight=wt], strata(v023) vce(linearized) singleunit(centered)
However, my estimate is coming out to 62%, but the NFHS-5 report shows around 76%.
----------------------------------------------
full_imm | percentage lb ub
----------+-----------------------------------
Not full | 37.8 37.1 38.5
Fully im | 62.2 61.5 62.9
|
Total | 100.0
Could you help me with what i am missing?
Thank you very much for your guidance.
Best regards,
Mohsin Siddiqui
[Updated on: Fri, 05 September 2025 01:32] Report message to a moderator |
|
|
|
Members
Search
Help
Register
Login
Home
