summarize is used in two ways:
- For numeric fields, summarize will calculate a running total of the field. The on arguments then determine when the accumulated value prints. When the field prints, the running total is reset to zero.
Where break will print totals under an existing column, summarize prints its values in a separate column.
- For date and text fields, summarize acts as a filter rather than an accumulator. The on arguments determine when the date or text field prints.
All summarize statements require at least one following ‘on’ reserved word.
Next – summarize syntax >