topic Ranking order with the same score in Statistical Procedures

Ranking order

kpakpo — Fri, 13 Jan 2023 02:08:41 GMT

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

Ranking order with the same score

kpakpo — Fri, 13 Jan 2023 01:56:23 GMT

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

Re: Ranking order

Tom — Fri, 13 Jan 2023 04:23:25 GMT

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;

Re: Ranking order

andreas_lds — Fri, 13 Jan 2023 07:05:25 GMT

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

Re: Ranking order

PaigeMiller — Fri, 13 Jan 2023 11:01:01 GMT

@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-data-AKA-generate/ta-p/258712. 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.

Re: Ranking order

ballardw — Fri, 13 Jan 2023 10:55:54 GMT

Proc sort data=yourdata;

by descending score descending numberoftimesrated;

run;

proc print data=yourdata;

run;

Re: Ranking order with the same score

PaigeMiller — Fri, 13 Jan 2023 10:57:08 GMT

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

@kpakpo do not post the same question multiple times.