topic Re: Calculate row-wise difference from group statistic in VA in SAS Visual Analytics

Calculate row-wise difference from group statistic in VA

paul_e — Wed, 17 Aug 2022 13:26:42 GMT

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"

Re: Calculate row-wise difference from group statistic in VA

paul_e — Thu, 18 Aug 2022 07:58:26 GMT

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.

Re: Calculate row-wise difference from group statistic in VA

BrunoMueller — Thu, 18 Aug 2022 14:13:47 GMT

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.

Re: Calculate row-wise difference from group statistic in VA

BrunoMueller — Tue, 30 Aug 2022 12:11:30 GMT

The last paragraph should be:
Also have a look at the AggregateTable operator, as this allows you to define a different bygroup for aggregation as is used on the object.