Hi Mohamed, proc report data=have;
column Final_Zone Type data_month, (leads appt test);
define Final_Zone / group 'Zone';
define Type / group 'Type';
define data_month / across;
define leads/ Analysis Sum noprint;
define Appt / Analysis Sum noprint;
define test / computed format=percent8.2 'Test';
compute test;
test = (Appt.SUM / leads.SUM);
endcomp;
run; Your approach is wright but i want test column under the month. Please pind the screen shot for reference. When we use column Final_Zone Type data_month, (leads appt test); this statement we need to add comma then it will show under the month.
... View more