I want to know how to find the mode in sas viya report.

[gugukaka]

I want to know how to find the mode in sas viya report. And I want to know how to get the maximum value of each column. For example, is there a method like Group by Max?

[Sam_SAS]

One approach to finding mode would be to convert the measure to a category (you would probably want to duplicate the column first) and then find the value that has the highest frequency. There might be other ways.

Maximum value is easier-- you can just apply the Maximum aggregation.

Let us know if that helps,

Sam

[sasviyajunior]

I want to get the mode aggregation, not the maximum aggregation. I have obtained the frequency corresponding to the category, but I am worried because there is no overlap of the aggregated measures.