Define the table columns. The column dimension of the TABLE statement creates a column for each formatted value of Classrm. Crossed within each value of Classrm is the analysis variable (sales) with a blank label. Nested within each column are columns that summarize sales for the class.
The first nested column, labeled sum, is the sum of sales for the row for the classroom.
The second nested column, labeled ColPctSum, is the percentage of the sum of sales for the row for the classroom in relation to the sum of sales for all teams in the classroom.
The third nested column, labeled RowPctSum, is the percentage of the sum of sales for the row for the classroom in relation to the sum of sales for the row for all classrooms.
The fourth nested column, labeled RepPctSum, is the percentage of the sum of sales for the row for the classroom in relation to the sum of sales for all teams for all classrooms.
classrm='Classroom'*sales=' '*(sum colpctsum*f=pctfmt9. rowpctsum*f=pctfmt9. reppctsum*f=pctfmt9.) all*sales*sum=' '