Print the sum of a column with PROC PRINT

[West26]

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.

[LaurieF · Accepted solution]

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;

[West26]

Thank you LaurieF