use "...KEIR8AFL.DTA", clear

* Construct table 5.12, teenage pregnancy for Kenya 2022 DHS survey
* Two columns can be constructed without the pregnancy history
* Two columns require the pregnancy history

* v201: number of live births
* v213: currently pregnant


gen ever_birth=0
replace ever_birth=100 if v201>0

gen curr_preg=0
replace curr_preg=100 if v213==1


* ever_loss and ever_preg require the use of p32_*
label list P32_01

*remove leading zeros
rename *_0* *_*

gen nlosses=0
forvalues lp=1/20 {
replace nlosses=nlosses+1 if p32_`lp'>1 & p32_`lp'<.
}

gen ever_loss=0
replace ever_loss=100 if nlosses>0

gen ever_preg=0
replace ever_preg=100 if p32_1<. | v213==1

label variable ever_birth "Ever had a live birth"
label variable ever_loss  "Ever had a pregnancy loss"
label variable curr_preg  "Currently pregnant"
label variable ever_preg  "Ever pregnant"

local lcovars v012 v025 v106 v190
foreach lc of local lcovars {
tabstat ever_birth ever_loss curr_preg ever_preg [fweight=v005] if v013==1, statistics(mean) by(`lc') format(%6.1f)
}