Ranking order

[kpakpo]

i have customer feedback ranking for my staff and 5 of them all scored 100 percent how do i rank the based on how frequently they were rated

[Tom]

Not sure what you mean.

If you want to number the observations just use a simple SUM statement.

proc sort data=have ;
  by descending score descending number_of_times_rated;
run;
data want;
  set have;
  by descending score descending number_of_times_rated;
  rank + 1;
run;

[andreas_lds]

I won't open any attachments, so please post data in usable form and show the expected result.

[PaigeMiller]

---

@kpakpo wrote:

i have customer feedback ranking for my staff and 5 of them all scored 100 percent how do i rank the based on how frequently they were rated

---

If I am understanding properly (and maybe I am not understanding properly), you can rank via PROC SORT

proc sort data=have out=have_sorted;
    by descending score descending number_of_times_rated;
run;

Please do not include data as file attachments or screen captures. Many of us will not download attachments, and we can't write code from screen captures. We need data provided as working SAS data step code, see https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat.... Many people go ahead and just ignore this request, but that is not a good way to get help ... do not ignore this request. We're trying to help you, but you need to help us too.

[ballardw]

Proc sort data=yourdata;

   by descending score descending numberoftimesrated;

run;

proc print data=yourdata;

run;

[kpakpo]

i have customer feedback ranking for my staff . how do i rank the based on how frequently they were rated. how do I know who is the best staff in customer service 

Name.  score  Number of times rated 

Joe.       100.      3

Matt        100.     5

Phil.         99.      15

Eugene.   90.      20

Kobby.     99.       15

[PaigeMiller]

This is a duplicate thread. All answers should go in your other thread.

@kpakpo do not post the same question multiple times.