use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\KEPR8BFL.DTA", clear

lookfor insurance

tab1 sh27 sh28*,m

forvalues lc=1/6 {
gen col_`lc'=0 if sh27<. & hv102==1
}

* Construct separate variables for the columns of the table
replace col_1=100 if col_1==0 & sh28a==1
replace col_2=100 if col_2==0 & sh28b==1
replace col_3=100 if col_3==0 & sh28c==1
replace col_4=100 if col_4==0 & sh28x==1
replace col_5=100 if col_5==0 & sh27==0 | sh27==8
replace col_6=100 if col_6==0 & sh27==1

label variable col_1 "NHIF"
label variable col_2 "Priv/commercial"
label variable col_3 "Community based"
label variable col_4 "Other"
label variable col_5 "DK"
label variable col_6 "Any"

gen     age3=1
replace age3=2 if hv105>=15
replace age3=3 if hv10v>=65
label define age3 1 "0-14" 2 "15-64" 3 "65+"
label values age3 age3

* Get the table with tabstat.  Note the use of fweight
tabstat col_1-col_6 [fweight=hv005], statistics(mean) format(%6.2f) by(hv025)
tabstat col_1-col_6 [fweight=hv005], statistics(mean) format(%6.2f) by(hv270)

* Can get the frequencies as follows
tab age3  if col_1<. [iweight=hv005/1000000]
tab hv025 if col_1<. [iweight=hv005/1000000]
tab hv270 if col_1<. [iweight=hv005/1000000]