Define the group and analysis columns. In this report, Sector and Manager are group variables. Each detail row represents a set of observations that have a unique combination of formatted values for all group variables. Sales is, by default, an analysis variable that is used to calculate the Sum statistic. However, because statistics are associated with Sales in the column statement, those statistics override the default. FORMAT= specifies the formats to use in the report. Text between quotation marks specifies the column heading.
define manager / group format=$mgrfmt.; define sector / group format=$sctrfmt.; define sales / format=dollar11.2 ''; define sum / format=dollar9.2 'Total Sales';