Hello,
I don't know if this is the best area for your post (this is for graphics), but I think I have a simple solution for your issue. I don't know how well RBREAK works outside of the listing destination, but I don't think you even need to use PROC REPORT in this case:
proc sql;
create table tbl_AP as
select
Grll,
count(PI) as Total,
count (AR) as Inis,
calculated Inis / Calculated Total as Return_Rate
from db. where GROUP= 3
group by Grll
OUTER UNION CORR
select 'Total' as grll,sum(total) as total,sum(inis) as inis,sum(return_rate) as return_rate from (select Grll,
count(PI) as Total,
count (AR) as Inis,
calculated Inis / Calculated Total as Return_Rate
from db. where GROUP= 3 group by grll) ;
quit;
OUTER UNION CORR matches columns by their variable names. I take your original query and add it as an inline view for the second query and then aggregate across that using SQL. I don't know how you wanted return_rate to be aggregated (sum, mean, etc.) so you can change that as needed.
If all you wanted for the total row was to do the same query without grouping you would do the following:
proc sql;
create table tbl_AP as
select
Grll,
count(PI) as Total,
count (AR) as Inis,
calculated Inis / Calculated Total as Return_Rate
from db. where GROUP= 3
group by Grll
OUTER UNION CORR
select 'Total' as Grll,
count(PI) as Total,
count (AR) as Inis,
calculated Inis / Calculated Total as Return_Rate
from db. where GROUP= 3
;
quit;
... View more