DATA Step, Macro, Functions and more

Print the sum of a column with PROC PRINT

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
Accepted Solution

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: 252

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;

View solution in original post


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

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 127 views
  • 1 like
  • 2 in conversation