topic Re: Ranking in SAS Visual Analytics

Ranking

SomanDavuluri — Wed, 26 Aug 2015 09:43:42 GMT

Can anyone help , how to create ranking column showing rank numbers physically in sas visual analytics reports

Re: Ranking

TejaSurapaneni — Wed, 26 Aug 2015 13:03:41 GMT

Hell Soman,

Unfortunately we cannot show ranks in VA Environment, we have to define in backend data.

In SAS VA we can define TOP and BOTTOM 5, 10, 50, 100 etc... depends on Client requirement, and Enable Sorting option.

Thanks & Regards,

Teja Surapaneni

Re: Ranking

SomanDavuluri — Thu, 27 Aug 2015 06:49:19 GMT

Thank U Teja ,

I have one more question for u , can we create a pivot for the data in report designer ?

Thanks

Soman

Re: Ranking

TejaSurapaneni — Thu, 27 Aug 2015 14:21:04 GMT

Hello Soman,

What your trying to show (Pivot), Can you please describe with at least one example.

Thanks & Regards,

Teja Surapaneni

Re: Ranking

Explore_SAS — Thu, 27 Aug 2015 17:58:18 GMT

Create a Reporttype as Crosstab.

Re: Ranking

SomanDavuluri — Fri, 28 Aug 2015 04:36:14 GMT

Can u show me with some examples ... i tried but not able to make it teja ...

Re: Ranking

SomanDavuluri — Fri, 28 Aug 2015 05:00:15 GMT

teja ,

And also how remove the excess column space in the report ...

suppose i have done a cross tab and i require only two columns , i see blank space in the report which looks odd , how can we remove the blank and fit in the required fields which makes the report look better visually.

thanks

Soman

Re: Ranking

Carrot17 — Tue, 12 Dec 2017 06:44:49 GMT

Hi Teja,

Would you know how to remove the last tie value in rank? Please see example below. In that example we would like to remove the "F" but everytime we unticked the "All Ties" option "C" will be vanished.

Thank in advance.

example: Top 5
A 4
B 4
C 2
D 2
E 2
F 2

EXPECTATION
A 4
B 4
C 2
D 2
E 2

SAS VA Result
A 4
B 4
D 2
E 2
F 2

Regards,
Carrot17