Hello ,

I have been using tabout to output summaries for 2 X 2 tables quite well. Now a new need has come where I will need to output summaries of more variables at a go, for example county X Active_age_1_F, Active_age_4_F , Active_age_9_F , Active_age_14_F , Active_age_19_F....

gen Active_age_1_F = 1 if Age<1 & status=="Active" & Gender_1 =="Female"
gen Active_age_4_F = 2 if Age>=1 & Age<5 & status=="Active" & Gender_1 =="Female"
gen Active_age_9_F = 3 if Age>=5 & Age<10 & status=="Active" & Gender_1 =="Female"
gen Active_age_14_F = 4 if Age>=10 & Age<15 & status=="Active" & Gender_1 =="Female"
gen Active_age_19_F = 5 if Age>=15 & Age<20 & status=="Active" & Gender_1 =="Female"
gen Active_age_24_F = 6 if Age>=20 & Age<25 & status=="Active" & Gender_1 =="Female"
gen Active_age_29_F = 7 if Age>=25 & Age<30 & status=="Active" & Gender_1 =="Female"
gen Active_age_34_F = 8 if Age>=30 & Age<35 & status=="Active" & Gender_1 =="Female"
gen Active_age_39_F = 9 if Age>=35 & Age<40 & status=="Active" & Gender_1 =="Female"
gen Active_age_44_F = 10 if Age>=40 & Age<45 & status=="Active" & Gender_1 =="Female"
gen Active_age_49_F = 11 if Age>=45 & Age<50 & status=="Active" & Gender_1 =="Female"
gen Active_age_50_F = 12 if Age>=50 & status=="Active" & Gender_1 =="Female"


tabout region Active_age_1_M using "P:\Stata\Output\Viraload\eidregimenanalysis.x ls" , c(freq) append

I will need help on which function to use to have an excel output that has summaries of the individual columns using my categorization of county.