Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 Gender float(age_grp no_currently_on_ART arv_dispensing)
"M"  5 1 1
"M"  6 1 1
"M"  6 1 1
"F"  4 1 1
"F"  5 1 1
"F"  4 1 1
"F"  5 1 1
"M"  5 1 1
"M"  4 1 1
"M"  4 1 1
"M"  5 1 1
"M"  3 1 1
"F"  4 1 1
"M"  4 1 1
"F"  4 1 1
"F"  5 1 1
"M"  3 1 1
"M"  4 1 1
"M"  3 1 1
"F"  3 1 1
"F"  3 1 1
"M"  2 1 1
"F"  3 1 1
"M"  4 1 1
"F"  3 1 1
"M"  4 1 1
"F"  7 1 1
"M"  9 1 2
"F"  7 1 1
"F"  8 1 2
"M"  8 1 2
"F"  9 1 1
"M"  9 1 1
"M"  9 1 2
"M" 10 1 1
"M"  9 1 3
"M"  7 1 1
"F" 10 1 3
"F" 11 1 1
"M"  9 1 2
end
label values age_grp age_grp
label def age_grp 2 "1-4yrs", modify
label def age_grp 3 "5-9yrs", modify
label def age_grp 4 "10-14yrs", modify
label def age_grp 5 "15-19yrs", modify
label def age_grp 6 "20-24yrs", modify
label def age_grp 7 "25-29yrs", modify
label def age_grp 8 "30-34yrs", modify
label def age_grp 9 "35-39yrs", modify
label def age_grp 10 "40-44yrs", modify
label def age_grp 11 "45-49yrs", modify
label values arv_dispensing arv_dispensing
label def arv_dispensing 1 "< 3 months", modify
label def arv_dispensing 2 " 3-5 months", modify
label def arv_dispensing 3 " > 6 months", modify
label var Gender "Gender"
Using the data above I would like to create a table output in this format, would be nice to export the file to xls format.
INDICATORS <1 Yr <1 Yr 1-4 Yrs 1-4 Yrs 5-9 Yrs 5-9 Yrs 10-14 Yrs 10-14 Yrs
Female Male Female Male Female Male Female Male
Number Currently on ART 0 0 0 0 0 0 0 0
ARV Dispensing <3 months 0 0 0 0 0 0 0 0
ARV Dispensing 3-5 Months 0 0 0 0 0 0 0 0
ARV Dispensing 6 Months or more 0 0 0 0 0 0 0 0