The DHS Program User Forum: Kenya » Table 5.5 Birth intervals

Home » Countries » Kenya » Table 5.5 Birth intervals

Show: Today's Messages :: Show Polls :: Message Navigator

Table 5.5 Birth intervals [message #28603]

Mon, 05 February 2024 08:03

sokiya
Messages: 80
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

Code: [Select all] [Show/ hide]

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!

Report message to a moderator

Re: Table 5.5 Birth intervals [message #28606 is a reply to message #28603]

Mon, 05 February 2024 13:14

Bridgette-DHS
Messages: 3230
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]".

Report message to a moderator

Re: Table 5.5 Birth intervals [message #28624 is a reply to message #28606]

Thu, 08 February 2024 01:55

sokiya
Messages: 80
Registered: May 2017
Location: Nairobi

Senior Member

Thanks so much for the guidance. I sincerely appreciate.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 5 19:45:30 Coordinated Universal Time 2025