## Print the sum of a column with PROC PRINT

Solved
Occasional Contributor
Posts: 19

# Print the sum of a column with PROC PRINT

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.

Accepted Solutions
Solution
‎01-24-2017 06:50 AM
Super Contributor
Posts: 268

## Re: Print the sum of a column with PROC PRINT

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;``````

All Replies
Solution
‎01-24-2017 06:50 AM
Super Contributor
Posts: 268

## Re: Print the sum of a column with PROC PRINT

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;``````
Occasional Contributor
Posts: 19

## Re: Print the sum of a column with PROC PRINT

Thank you LaurieF
☑ This topic is solved.