Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Ranking

Reply
Contributor
Posts: 41

Ranking

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

Regular Contributor
Posts: 208

Re: Ranking

Posted in reply to SomanDavuluri

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

Contributor
Posts: 57

Re: Ranking

Posted in reply to TejaSurapaneni
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
Contributor
Posts: 41

Re: Ranking

Posted in reply to SomanDavuluri

Thank U Teja ,

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

Thanks

Soman

Regular Contributor
Posts: 208

Re: Ranking

Posted in reply to SomanDavuluri

Hello Soman,

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

Thanks & Regards,

Teja Surapaneni

Contributor
Posts: 69

Re: Ranking

Posted in reply to SomanDavuluri

Create a Reporttype as Crosstab.

Contributor
Posts: 41

Re: Ranking

Posted in reply to Explore_SAS

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

Contributor
Posts: 41

Re: Ranking

Posted in reply to SomanDavuluri

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

Ask a Question
Discussion stats
  • 7 replies
  • 831 views
  • 0 likes
  • 4 in conversation