use "KEIR71FL.dta", clear

*** Health insurance ***
* Note: The different types of health insurance can be country specific. Please check the v481* variables to see which ones you need.
* In addition, some surveys report this for all women/men and some report it among those that have heard of insurance. Please check what the population of interest is for reporting these indicators.
//Health insurance - Social security
gen rc_hins_ss = v481c==1
label var rc_hins_ss "Health insurance coverage - social security"

//Health insurance - Other employer-based insurance
gen rc_hins_empl = v481b==1
label var rc_hins_empl "Health insurance coverage - other employer-based insurance"

//Health insurance - Mutual Health Organization or community-based insurance
gen rc_hins_comm = v481a==1
label var rc_hins_comm "Health insurance coverage - mutual health org. or community-based insurance"

//Health insurance - Privately purchased commercial insurance
gen rc_hins_priv = v481d==1
label var rc_hins_priv "Health insurance coverage - privately purchased commercial insurance"

//Health insurance - Other
gen rc_hins_other=0
	foreach i in e f g h x {
	replace rc_hins_other=1 if v481`i'==1
	} 
label var rc_hins_other "Health insurance coverage - other type of insurance"

//Health insurance - Any
gen rc_hins_any=0
	foreach i in a b c d e f g h x {
	replace rc_hins_any=1 if v481`i'==1
	}
label var rc_hins_any "Have any health insurance"

ta rc_hins_any [iw=v005/1000000]

use " KEIR72FL.DTA", clear

tab1 v481*,m

* Sequence as in table 14.10.1

gen ins1=100*v481c if v481<.
gen ins2=100*v481b if v481<.
gen ins3=100*v481a if v481<.
gen ins4=100*v481d if v481<.
gen ins5=100*v481e if v481<.
gen ins6=100*v481x if v481<.

label variable ins1 "National"
label variable ins2 "Employer"
label variable ins3 "Mutual"
label variable ins4 "Private"
label variable ins5 "Pre-payment"
label variable ins6 "Other"

gen none=100
replace none=0 if v481==0

tabstat ins* none [fweight=v005], statistics(mean)
tab v025 if v481<. [iweight=v005/1000000]