Hello,
I need to count the number of individuals for each group that fulfil a requirement regarding the group, for instance: How many individuals in a group have a difference of less than 2 from the group average? When I try to create the corresponding calculated item in VA I get the following error since VA won't combine non-aggregated and aggregated values with numeric operators:
"Operand can only be aggregated, but this operator does not support aggregation"
I understand that I can persist the aggregated values in a new aggregated table but this will cause a loss of interactivity since the aggregated table doesn't get updated when report parameters change.
Providing sample data and expected result will help in understanding what you want.
You can mock up something with sashelp.cars, this is available in every SAS installation.
In my experience when you use control objects on page or report level they will also filter aggregated data sources.
Also have a look at the AggregateCells operator, as this allows you to define a different bygroup for aggregation as is used on the object.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.