SAS VA Conditional formatting

[PM23]

Hi all,

is it possible to format greatest value in the column? Maybe I am just blind or stupid, but I don't see this option in SAS VA, I see only greater than, missing,  etc.

Thank you in advance.

[Sam_SAS]

Hello,

I think there is not an easy, straightforward way to do this.

However, it may be possible to work around by precalculating the max value for your column in your data preparation step, and then creating a display rule that compares the column value to that calculated max value column. I was able to achieve a result like this:

Is that the sort of output you were looking for?

It is also possible to calculate the max value within VA as an aggregated measure by using an expression like this:

AggregateTable(_Max_, Table(_Max_, Fixed(), 'Height'n))

Where Height is column you want to get the max value for. This will only work in a list table if Detail Data is disabled for the table.

(Note that both workarounds here compared to the max value in the whole source table and they are not dynamic if you apply filters to the list table object, etc.)

Let us know if that helps,

Sam

[Sam_SAS · Accepted solution]

I'm not sure why I went to the complicated AggregateTable operator, but a much simpler expression would be:

Max [_ForAll_] ('Height'n)

When you use this version, it will resolve the max value in the list table object, rather than the max for the whole source table. This means that it will be dynamic when you filter the data for the list table.

It does still have the limitation where Detail Data cannot be enabled for the list table object.

[PM23]

Sam, thank you for your solution. I decided to use heatmap in Options of Crosstab and it works fine for me.

[Sam_SAS]

Thanks for following up with us 🙂