I have a query on how to create aggregate measure of sum(_bygroup) of a variable.
Let's say I have example dataset as below:
And I want to create aggregate measure of total sales by ID such as below:
How can I do that in SAS Visual Analytics?
I was not able to get it to work with using the _bygroup_ aggregation. With Viya, if you don't mind creating an aggregated table then you can accomplish this with the following steps.
1. Create the aggregated table. (Select Data menu --> icon next to current table ---> New Data from aggregation of ....
I only select id and sales for the table to make it most efficient.
2. Create the customer category named 'Aggregated Measure'
3. Create a list table and include the three data items.
Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.
Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.