topic Print the sum of a column with PROC PRINT in SAS Programming

Print the sum of a column with PROC PRINT

West26 — Tue, 24 Jan 2017 02:23:36 GMT

INPUT DATA

VAR1 VAR2

ABC 30

BBC 40

CNE 20

BRE 10

OUTPUT DATA

INPUT DATA

VAR1 VAR2

ABC 30

BBC 40

CNE 20

BRE 10

VAR2TOTAL 100

Only the VAR2 result has to be displayed with PROC PRINT, ALONG WITH TEXT 'VAR2TOTAL'

Thank you.

Re: Print the sum of a column with PROC PRINT

LaurieF — Tue, 24 Jan 2017 10:08:41 GMT

There may be a a way with the new things that have been added to proc print, but I'm not up with all of them.

But you can do it with proc report. Try this:

proc report data=source nowd;
cols var1 var2;
define var1 / group;
define var2 / sum;
rbreak after / summarize;
compute after;
   var1 = 'VAR2TOTAL';
   endcomp;
run;

Re: Print the sum of a column with PROC PRINT

West26 — Tue, 24 Jan 2017 11:51:26 GMT

Thank you LaurieF