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

[#1]

.

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

Let’s get Aggregated with AggregateTable

Part 1: AggregateTable function introduction and two simple use cases to get you started using this powerful and interesting function

I have decided to do another mini-series and this time we are going to take a closer look at a very powerful and interesting function called AggregateTable, which is a function available in the expression builder in SAS Visual Analytics.

There are already some very good articles about this powerful function out there, here are some that I highly recommend:

Understanding the AggregateTable Function for Beginners – by NithinRamu

SAS Visual Analytics Advanced Calculations (part 2 of 4): AggregateTable – by Renato_sas

Why another article on AggregateTable?

I think it is always a challenge to explain this powerful function and its flexibility, so I think the best way to do this is by using relevant and real use-cases from the field. That is reason why I have created this mini-series, to cover different scenarios, with different realistic use cases that customers have solved in real life using the AggregateTable function.

So, in part 1 of this mini-series I will first introduce AggregateTable function for you and then show-case two simple use cases, which I think is a good way to get you started using this fantastic function. 

1. AggregateTable function introduction (1:26)

2. First simple % of total use case using AggregateTable (4:36)

3. A visualization challenge, solved by using the hidden role (6:58)

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)