PRINT Procedure

SUM Statement

Totals values of numeric variables.
Summing Numeric Variables with One BY Group

Summing Numeric Variables with Multiple BY Variables

Limiting the Number of Sums in a Report

Creating a Customized Layout with BY Groups and ID Variables

Syntax

Required Argument

variable(s)
identifies the numeric variables to total in the report.

Optional Argument

STYLE <(location(s))>=<style-element-name> <[style-attribute-specification(s)]>
specifies the style element to use for cells containing sums that are created with the SUM statement.
Tips:To specify different style elements for different cells reporting sums, use a separate SUM statement for each variable and add a different STYLE option to each SUM statement.

If the STYLE option is used in multiple SUM statements that affect the same location, the STYLE option in the last SUM statement will be used.

See:For information about the arguments of this option and how it is used, see the option STYLE= in the PROC PRINT statement.

Details

Using the SUM and BY Statements Together

When you use a SUM statement and a BY statement with one BY variable, PROC PRINT sums the SUM variables for each BY group that contains more than one observation and totals them over all BY groups. (See Summing Numeric Variables with One BY Group.)
When you use a SUM statement and a BY statement with multiple BY variables, PROC PRINT sums the SUM variables for each BY group that contains more than one observation, just as it does if you use only one BY variable. However, it provides sums only for those BY variables whose values change when the BY group changes. (See Summing Numeric Variables with Multiple BY Variables.)
Note: When the value of a BY variable changes, the SAS System considers that the values of all variables listed after it in the BY statement also change.