topic Re: how to sum vertically at the very bottom in SAS Programming

how to sum vertically at the very bottom

HitmonTran — Thu, 17 Dec 2020 02:44:53 GMT

Hi,

I need the total sum for each column displayed at the very bottom

data:
site  col1   col2  col3
A      2      3     6
B      2      4     7
C      2      5     8


want:
site   col1 col2 col3
A       2    3    6
B       2    4    7
C       2    5    8
Total   6    12   21

Re: how to sum vertically at the very bottom

Tom — Thu, 17 Dec 2020 04:01:51 GMT

proc print data=have ;
  var site col1-col3;
  sum col1-col3 ;
run;

Re: how to sum vertically at the very bottom

PeterClemmensen — Thu, 17 Dec 2020 05:17:12 GMT

Do you want this in a report or in a SAS data set?

Re: how to sum vertically at the very bottom

HitmonTran — Thu, 17 Dec 2020 18:00:17 GMT

I want this in a rtf report

Re: how to sum vertically at the very bottom

tarheel13 — Thu, 17 Dec 2020 20:13:34 GMT

I think this does what you need. https://communities.sas.com/t5/SAS-Programming/Proc-Report-Grand-Total/td-p/538641

ods rtf file="filepath";

/*proc report code goes here*/

ods rtf close;