Generating Column Totals

Overview

To produce column totals for numeric variables, you can list the variables to be summed in a SUM statement in your PROC PRINT step.
General form, SUM statement:
SUM variable(s);
where variable(s) is one or more numeric variable names, separated by blanks.
The SUM statement in the following PROC PRINT step requests column totals for the variable BalanceDue:
proc print data=clinic.insure; 
   var name policy balancedue; 
   where pctinsured < 100;  
   sum balancedue; 
run;
Column totals appear at the end of the report in the same format as the values of the variables.
Column Totals
Column Totals

Requesting Subtotals ...

Get SAS Certification Prep Guide: Base Programming for SAS 9, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.