The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Calculation of in utero, infant mortality, under_5 mortality, vaccination coverage & Birth Cohort (construction of variables )
Calculation of in utero, infant mortality, under_5 mortality, vaccination coverage & Birth Cohort [message #29272] Fri, 17 May 2024 02:31 Go to previous message
Atazonomics is currently offline  Atazonomics
Messages: 4
Registered: April 2024
Member

I want to calculate infant mortality defined as a child who ides during in utero + first 12 month of birth, infant mortality1 defined as a child dies within 12 months of her birth , under_5 mortality (dies before 60th month or within 5 years of birth), Month-Year Birth Cohort and Vaccination coverage from using the BR file of Ivoire coast, Uganda and Nigeria ( i am using various rounds but not later earlier than 4). First of all i would to seek clarity on b6 vs. b7 and v008 vs. v008a.

I generate my variables in stata as describe below: Kindly advise me if this is the way to go.



gen age_months = v008 - b3
gen under_five = age_months <= 60 & age_months >= 0

gen infant_mortality if b7 <= 12 & under_five <= 12 [iweight=v005/1000000]
gen under5_mortality if b7 <= 60 & under_five <= 60 [iweight=v005/1000000]

*age (in utero + first 12 months of birth )
age_inutero = 9
age_utero_1st_12month = age_months + age_inutero

*Cohort (month-year)
egen cohort = group(b1 b2)

*Renaming vaccines
rename h2 bcg
rename h3 dpt1
rename h4 polio1
rename h5 dpt2
rename h6 polio2
rename h7 dpt3
rename h8 polio3
rename h9 measles1

* Define vaccine
local vaccines "bcg dpt1 polio1 dpt2 polio2 dpt3 polio3 measles1"

* Recode vaccine variables to binary: 1 = received and 0 = not received
foreach v in `vaccines' {
* Recode 0 as 0, 1-3 as 1, ignore 8 (don't know)
recode `v' (0 = 0 "1/2/3" = 1) (8 = .), generate(received_`v')
}

* Aggregate/sum vaccinations received
egen total_vaccinated = rowtotal(received_bcg received_dpt1 received_polio1 received_dpt2 received_polio2 received_dpt3 received_polio3 received_measles1)

* Indicators for various levels of vaccination coverage
* None of the basic vaccinations received
gen none_received = total_vaccinated == 0

* All basic vaccinations received
gen all_received = total_vaccinated == 8

* At least 50% of basic vaccinations received (at least 4 out of 8)
gen at_least_half_received = total_vaccinated >= 4

* At most 50% of basic vaccinations received (4 or fewer out of 8)
gen at_most_half_received = total_vaccinated <= 4

Thank you very much .

Luke
 
Read Message
Read Message
Read Message
Previous Topic: Early childhood development
Next Topic: About BMI of Mother
Goto Forum:
  


Current Time: Thu Dec 12 16:10:39 Coordinated Universal Time 2024