The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Kenya » Table 5.5 Birth intervals
Table 5.5 Birth intervals [message #28603] Mon, 05 February 2024 08:03 Go to next message
sokiya is currently offline  sokiya
Messages: 76
Registered: May 2017
Location: Nairobi
Senior Member
Hi,
I am trying to replicate the results found in Table 5.5 Birth intervals using the code below
use "KEBR8AFL.dta", clear
//Group mother's age groups for birth interval table
recode v013 (1=1 "15-19") (2/3 = 2 "20-29") (4/5 = 3 "30-39") (6/7 = 4 "40-49"), gen(fe_age_int) label(fe_age_int_lab)
label var fe_age_int "Age groups for birth intervals table"

//Create birth interval, excluding first births and their multiples
gen fe_bord = bord if b0 < 2
replace fe_bord = bord - b0 + 1 if b0 > 1
recode fe_bord (1 =1 "1") (2/3 = 2 "2-3") (4/6 = 4 "4-6") (7/max = 7 "7+"), gen(fe_bord_cat) label(fe_bord_lab)
label var fe_bord_cat "Birth order categories"

//Birth interval, number of months since preceding birth
recode b11 (min/17= 1 "less than 17 months") (18/23 = 2 "18-23 months") ///
		  (24/35 = 3 "24-35 months") (36/47 = 4 "36-47 months") (48/59 = 5 "48-59 months") ///
		  (60/max = 6 "60+ months"), gen(fe_int) label(fe_int_lab)
label var fe_int "Months since preceding birth"
ta fe_int [fweight=v005] if fe_bord != 1

but there's a discrepancy in the estimates in the total row. Any help will be appreciated.

Thanks in advance!
Re: Table 5.5 Birth intervals [message #28606 is a reply to message #28603] Mon, 05 February 2024 13:14 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3043
Registered: February 2013
Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

This table should be restricted to births in the past 5 years. You can use the BR file, as you did, but add a line "keep if b19<60". Alternatively you can use the KR file. I would also recommend "[iweight=v005/1000000]" rather than "[fweight=v005]".
Re: Table 5.5 Birth intervals [message #28624 is a reply to message #28606] Thu, 08 February 2024 01:55 Go to previous message
sokiya is currently offline  sokiya
Messages: 76
Registered: May 2017
Location: Nairobi
Senior Member
Thanks so much for the guidance. I sincerely appreciate.
Previous Topic: Item V613 of the Recode
Next Topic: KDHS 2014 - Table 7.12 Need and demand for family planning among currently married women
Goto Forum:
  


Current Time: Sat Apr 27 05:42:49 Coordinated Universal Time 2024