Solved
Contributor
Posts: 36

# Totals and Subtotals on Summary Tables

How do i include totals and subtotals when making a summary table on EG?

Accepted Solutions
Solution
‎10-29-2012 11:01 PM
SAS Super FREQ
Posts: 9,426

## Re: Totals and Subtotals on Summary Tables

Hi:

If you are using the Summary Tables Task, then when you are in the table designer, look for an available CLASS variable that is labelled Total (ALL) -- you can drag that item to any dimension in order to produce subtotals and totals. See this example of a table design, there I have AGE nested with SEX as the CLASS variables and get the mean of HEIGHT in the columns, then I have both sub-totals and a total on the table design.

cynthia

All Replies
Solution
‎10-29-2012 11:01 PM
SAS Super FREQ
Posts: 9,426

## Re: Totals and Subtotals on Summary Tables

Hi:

If you are using the Summary Tables Task, then when you are in the table designer, look for an available CLASS variable that is labelled Total (ALL) -- you can drag that item to any dimension in order to produce subtotals and totals. See this example of a table design, there I have AGE nested with SEX as the CLASS variables and get the mean of HEIGHT in the columns, then I have both sub-totals and a total on the table design.

cynthia

Contributor
Posts: 36

## Re: Totals and Subtotals on Summary Tables

Thank you i appreciate it, that really helped!

Contributor
Posts: 31