topic I want to know how to find the mode in sas viya report. in SAS Visual Analytics

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

gugukaka — Mon, 28 Oct 2019 09:57:57 GMT

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?

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

Sam_SAS — Mon, 28 Oct 2019 14:24:34 GMT

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

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

sasviyajunior — Wed, 30 Oct 2019 07:49:53 GMT

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.