topic RANKING BY CATEGORY IN CROSS-TABLE in SAS Visual Analytics

RANKING BY CATEGORY IN CROSS-TABLE

Achraf_Ougdal — Mon, 29 May 2023 20:38:28 GMT

Hello Everyone,

I am Using SAS Visual Analytics on SAS 9.4 on Windows and I am having a rough time figuring out how to rank line items in a cross-table.

I want to rank each Sub-Category based on a value in its own category. maybe the below picture will clarify what I need.

Can you please help me ?

Thank you in advance.

Madelyn_SAS — Tue, 30 May 2023 18:48:23 GMT

Just to clarify, your goal is to create a new column with the ranking values?

Achraf_Ougdal — Tue, 30 May 2023 18:51:12 GMT

Yes exactly and I wanna do it in SAS Visual Analytics

acordes — Thu, 01 Jun 2023 06:59:06 GMT

Visual Analytics cannot derive a rank score directly, but you can use it in the object's role itself.

It's called rank and you can select x or x% top entries based on a variable's value.

But in my experience you cannot control for group structure.

So in your example TOP3 would show

Soccer 15

Tennis 12

Tennis 10