BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
DavidPhillips2
Rhodochrosite | Level 12

In Web Report Studio, 4.4 M3, I’m trying to display the top 20 objects in descending order.  When I sort descending before ranking the sort works.  When I rank the sort takes no effect.

1 ACCEPTED SOLUTION

Accepted Solutions
Madelyn_SAS
SAS Super FREQ

Please try this:

 

  1. Right-click the label "Transfer Institution."
  2. On the menu, select Remove All Sorting.
  3. Right-click the label "Transfer Institution" again.
  4. On the menu, select Sort Ascending (or Descending) by First Year Transfer.

 

View solution in original post

5 REPLIES 5
Madelyn_SAS
SAS Super FREQ

Can you post a screen shot that illustrates the issue? I see no issues sorting on a column that has been ranked.

DavidPhillips2
Rhodochrosite | Level 12

added screenshot

Madelyn_SAS
SAS Super FREQ

Please try this:

 

  1. Right-click the label "Transfer Institution."
  2. On the menu, select Remove All Sorting.
  3. Right-click the label "Transfer Institution" again.
  4. On the menu, select Sort Ascending (or Descending) by First Year Transfer.

 

DavidPhillips2
Rhodochrosite | Level 12

Thanks, it looks like it was double sorted.

Madelyn_SAS
SAS Super FREQ

I think that the rank automatically applies a sort, so that any subsequent sorts are secondary sorts. Glad that removing all sorting worked!

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 2854 views
  • 0 likes
  • 2 in conversation