Desktop productivity for business analysts and programmers

Ranking Data

Posts: 61

Ranking Data

I'm trying to rank query results, what I currently have is a count by individual name. What I'm trying to accomplish is a "rank" field that looks like the following below. The "RANK" function in SAS EG doesn't seem to provide me with the results I'm looking for. Can someone point me in the right direction?

Name Count Rank
Mike 32 1
Bill 29 2
Jim 24 3
Cindy 24 3
Bob 19 5
Dave 17 6 Message was edited by: mdavidson
Trusted Advisor
Posts: 2,126

Re: Ranking Data

Posted in reply to mdavidson
I think that what you want to use is the RANK Task under the Data Tab. If it returns mid-ranks (3.5's where you have 3's), you can use the FLOOR function in the query to remove the decimal part.
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation