The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Vaccination coverage using 2013 ndhs data set: Nigerian & dhs
Vaccination coverage using 2013 ndhs data set: Nigerian & dhs [message #9143] Mon, 15 February 2016 15:09 Go to next message
Eminent Ben is currently offline  Eminent Ben
Messages: 3
Registered: February 2016
Location: Ile-Ife osun state Nigeri...
Member
Please how can I generate child vaccination coverage from kids recode such that the coverage will be 1-no vaccination 2-partial vaccination and 3-full vaccination
Thanks
Re: Vaccination coverage using 2013 ndhs data set: Nigerian & dhs [message #9705 is a reply to message #9143] Mon, 09 May 2016 09:56 Go to previous messageGo to next message
kjacob is currently offline  kjacob
Messages: 7
Registered: May 2016
Location: Kilifi
Member
First generate the vaccinated and not vaccinated group by each vaccine, e.g for BCG

gen bcg_vac=.
replace bcg_vac=0 if (h2==.|h2==0 | h2==3 |h2==8 |h2==9)
replace bcg_vac=1 if (h2==1|h2==2)

label define bcg_vac 0 "not vaccinated" 1 "vaccinated",modify
label values bcg_vac bcg_vac

for measles

gen measles_vac=.
replace measles_vac=0 if (h9==.|h9==0|h9==3|h9==8|h9==9)
replace measles_vac=1 if (h9==1|h9==2)

label define measles_vac 0 "not vaccinated" 1 "vaccinated",modify
label values measles_vac measles_vac


do the same for all vaccines (dpt1-3, opv1-3 e.t.c.)


Combine the vaccinated (all that are vaccinated either by vaccination date on card or reported by mother)

For example in the case above (bcg and measles)

gen vaccination_status=.
replace vaccination_status=0 if (bcg_vac==0 & measles_vac==0)*****add the other vaccines and separate them using &
replace vaccination_status=1 if (bcg_vac==1 | measles_vac==1)*****add the other vaccines and separate them using |
replace vaccination_status=1 if (bcg_vac==1 & measles_vac==1)*****add the other vaccines and separate them using &

label define vaccination_status 0 "not vaccination" 1 "partial vaccination" 2 "full vaccination", modify
label values vaccination_status vaccination_status





JK
Re: Vaccination coverage using 2013 ndhs data set: Nigerian & dhs [message #9715 is a reply to message #9705] Mon, 09 May 2016 21:20 Go to previous messageGo to next message
owraza is currently offline  owraza
Messages: 31
Registered: December 2013
Location: Tehran
Member
There is a minor typo in what kjacob has written and running these line as it is, will produce error.

kjacob wrote on Mon, 09 May 2016 18:26
First generate the vaccinated ...

gen vaccination_status=.
replace vaccination_status=0 if (bcg_vac==0 & measles_vac==0)*****add the other vaccines and separate them using &
replace vaccination_status=1 if (bcg_vac==1 | measles_vac==1)*****add the other vaccines and separate them using |
replace vaccination_status=1 if (bcg_vac==1 & measles_vac==1)*****add the other vaccines and separate them using &

label define vaccination_status 0 "not vaccination" 1 "partial vaccination" 2 "full vaccination", modify
label values vaccination_status vaccination_status


Looking at third last line,

Quote:
replace vaccination_status=1 if ...

It should be written as:
replace vaccination_status = 2 if ...

Re: Vaccination coverage using 2013 ndhs data set: Nigerian & dhs [message #15265 is a reply to message #9715] Wed, 20 June 2018 16:09 Go to previous message
krishn28_ssh is currently offline  krishn28_ssh
Messages: 5
Registered: June 2018
Location: India
Member
I have tried to calculate vaccination result from India DHS 2015-16 but not get appropriate result
following is the processes that i went through-


*vaccination
use "IABR73FL", clear
*First generate the vaccinated and not vaccinated group by each vaccine, e.g for BCG

*for BCG
gen bcg_vac=.
replace bcg_vac=0 if (h2==.|h2==0|h2==8 |h2==9)
replace bcg_vac=1 if h2==1
replace bcg_vac=3 if (h2==2|h2==3)
label define bcg_vac 0 "not vaccinated" 1 "partial vaccinated" 3 "full vaccinated",modify
label values bcg_vac bcg_vac



*for DPT1
gen DPT1_vac=.
replace DPT1_vac=0 if (h3==.|h3==0|h3==8 |h3==9)
replace DPT1_vac=1 if h3==1
replace DPT1_vac=3 if (h3==2|h3==3)
label define DPT1_vac 0 "not vaccinated" 1 "vaccinated" 3 "full vaccinated",modify
label values DPT1_vac DPT1_vac

*for polio 1
gen polio1_vac=.
replace polio1_vac=0 if (h4==.|h4==0 |h4==8 |h4==9)
replace polio1_vac=1 if h4==1
replace polio1_vac=3 if (h4==2|h4==3)
label define polio1_vac 0 "not vaccinated" 1 "vaccinated" 3 "full vaccinated",modify
label values polio1_vac polio_vac

*for DPT2
gen DPT2_vac=.
replace DPT2_vac=0 if (h5==.|h5==0|h5==8 |h5==9)
replace DPT2_vac=1 if h5==1
replace DPT2_vac=3 if (h5==2|h5==3)
label define DPT2_vac 0 "not vaccinated" 1 "vaccinated" 3 "full vaccinated",modify
label values DPT2_vac DPT2_vac

*for polio 2
gen polio2_vac=.
replace polio2_vac=0 if (h6==.|h6==0 |h6==8 |h6==9)
replace polio2_vac=1 if h6==1
replace polio2_vac=3 if (h6==2 |h6==3)
label define polio2_vac 0 "not vaccinated" 1 "vaccinated" 3 "full vaccinated",modify
label values polio2_vac polio2_vac

*for DPT3
gen DPT3_vac=.
replace DPT3_vac=0 if (h7==.|h7==0 |h7==8 |h7==9)
replace DPT3_vac=1 if h7==1
replace DPT3_vac=3 if (h7==2|h7==3 )
label define DPT3_vac 0 "not vaccinated" 1 "vaccinated" 3 "full vaccinated",modify
label values DPT3_vac DPT3_vac

*for polio 3
gen polio3_vac=.
replace polio3_vac=0 if (h8==.|h8==0 |h8==8 |h8==9)
replace polio3_vac=1 if h8==1
replace polio3_vac=3 if (h8==2|h8==3)
label define polio3_vac 0 "not vaccinated" 1 "vaccinated" 3 "full vaccinated",modify
label values polio3_vac polio3_vac

*for measles

gen measles_vac=.
replace measles_vac=0 if (h9==.|h9==0 |h9==8 |h9==9)
replace measles_vac=1 if h9==1
replace measles_vac=3 if (h9==2|h9==3)

label define measles_vac 0 "not vaccinated" 1 "vaccinated" 3 "full vaccinated",modify
label values measles_vac measles_vac


*Combine the vaccinated (all that are vaccinated either by vaccination date on card or reported by mother)


gen vaccination_status=.
replace vaccination_status=0 if (bcg_vac==0 & measles_vac==0 & DPT1_vac==0 & polio1_vac==0 & DPT2_vac==0 & polio2_vac==0 & DPT3_vac==0 & polio3_vac==0)
replace vaccination_status=1 if (bcg_vac==1 & measles_vac==1 & DPT1_vac==1 & polio1_vac==1 & DPT2_vac==1 & polio2_vac==1 & DPT3_vac==1 | polio3_vac==1)
replace vaccination_status=3 if (bcg_vac==3 & measles_vac==3 & DPT1_vac==3 & polio1_vac==3 & DPT2_vac==3 & polio2_vac==3 & DPT3_vac==3 & polio3_vac==3)

label define vaccination_status 0 "not vaccination" 1 "partial vaccination" 3 "full vaccination", modify
label values vaccination_status vaccination_status


krishna
Previous Topic: Measuring postnatal care for baby (M70)
Next Topic: Immunization
Goto Forum:
  


Current Time: Sun Mar 7 07:23:21 Coordinated Universal Time 2021