proc sql;
create table t1 as
select 'region' as VAR,
region as category,
'sales' as metric,
count(sales) as nr_obs,
sum(sales) as amnt format=best.
from sashelp.shoes
group by region;
quit;
proc sql;
create table t2 as
select 'region' as VAR,
region as category,
'net_sales' as metric,
count(sales) as nr_obs,
sum(sales-returns) as amnt
label='Net Sales Ratio'
from sashelp.shoes
group by region;
quit;
proc sql;
create table t3 as
select 'region' as VAR,
region as category,
'net_sales_Ratio' as metric,
count(sales) as nr_obs,
sum(sales-returns)/sum(sales) as amnt format=8.2
label='Net Sales Ratio'
from sashelp.shoes
group by region;
quit;
Data all;
length metric $100.;
set t1 t2 t3;
Run;
proc sort data=all;
by metric;
run;
options nobyline;
ods excel file='c:\temp\temp.xlsx' options(sheet_interval='none');
proc report data=all nowd;
by metric;
column metric var category nr_obs amnt;
define _all_ /display;
run;
ods excel close;
... View more
