https://communities.sas.com/t5/SAS-Enterprise-Guide/Ranking-Data/m-p/28954#M4010 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. Thu, 03 Jul 2008 16:10:56 GMT Doc_Duke 2008-07-03T16:10:56Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Ranking-Data/m-p/28953#M4009 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?<BR /> <BR /> Name Count Rank<BR /> Mike 32 1 <BR /> Bill 29 2 <BR /> Jim 24 3<BR /> Cindy 24 3<BR /> Bob 19 5<BR /> Dave 17 6 Message was edited by: mdavidson Wed, 02 Jul 2008 18:03:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Ranking-Data/m-p/28953#M4009 mdavidson 2008-07-02T18:03:12Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Ranking-Data/m-p/28954#M4010 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. Thu, 03 Jul 2008 16:10:56 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Ranking-Data/m-p/28954#M4010 Doc_Duke 2008-07-03T16:10:56Z