topic Re: ranking and changing the order of tie values in SAS Programming

ranking and changing the order of tie values

AJCFreeman — Thu, 09 Jun 2016 21:25:27 GMT

Hi,

I am ranking companies based on a metric. However when I have a tie between my company and another one, I want my company to show up first. How do I do that?

Re: ranking and changing the order of tie values

ChrisNZ — Thu, 09 Jun 2016 23:09:47 GMT

I suppose your rank value is an integer. Just always add 0.1 point to your company's rank and it will be ahead in case of ties.

Re: ranking and changing the order of tie values

PGStats — Fri, 10 Jun 2016 02:31:46 GMT

You can define a new variable and add it to the table sorting order

data have;
input Cpny :$10. Metric;
datalines;
Company_1 1
Company_2 2
MyCompany 2
Company_3 3
;

data have_report;
set have;
order = cpny ne "MyCompany";
run;

/* List companies in descending order of my metric, but
 show MyCompany first in case of a tie. Other ties are sorted 
 by alphabetical order of company name. */
proc sql;
select cpny, metric
from have_report
order by metric desc, order, cpny;
quit;

Re: ranking and changing the order of tie values

AJCFreeman — Fri, 10 Jun 2016 13:37:56 GMT

thanks it worked perfectly

Re: ranking and changing the order of tie values

AJCFreeman — Fri, 10 Jun 2016 14:17:09 GMT

I did all that to be able to order the data for a Gchart.
however my Gchart doesn't keep that order... 😞
any ideas?

Re: ranking and changing the order of tie values

PGStats — Fri, 10 Jun 2016 15:34:50 GMT

Create a sorted version of your dataset, switch to a SGPLOT VBAR (or HBAR) plot, and use XAXIS (or YAXIS) option DISCRETEORDER=DATA.

Re: ranking and changing the order of tie values

ChrisNZ — Sat, 11 Jun 2016 00:46:13 GMT

Or do this http://support.sas.com/kb/24/916.html

Re: ranking and changing the order of tie values

AJCFreeman — Mon, 13 Jun 2016 12:52:10 GMT

I put a space in front of my company's name.