SAS Visual Analytics Tips & Trick Series: Let’s get Aggregated, Part 3

[#1]

.

How to become a professional and more efficient using SAS Visual Analytics

Let’s get Aggregated with AggregateTable

Part 3: How to work with nested aggregations using the AggregateTable function

In part 3, we are investigating how we can work with nested and multiple aggregations when using the AggregateTable function. Depending on what detail level our data has, sometimes we need to aggregate our data multiple times before we can use it.

Use case description: Sales management wants to benchmark product sale % against continent average sales, where sales first is summarized by country.

.

 1. Use case introduction (0:40)

2. AggregateTable function set-up: How to manage two aggregations (2:14)

3. Looking at the final % of average product sales per continent calculation  (3:55)

Previous videos in this mini-series:

Part 1 - AggregateTable function introduction and two simple use cases: Click here to go to part 1

Part 2 - Different % of sub-total use cases: Click here to go to part 2

To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!

Please note: All data used in my videos are either fictive demo data or open public data

SAS Visual Analytics version used in this video: 2026.06

(Please Note: Function AggregateTable is available on Viya 3.5 as well)