ranking and changing the order of tie values

[AJCFreeman]

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?

[ChrisNZ]

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.

[PGStats · Accepted solution]

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;

[AJCFreeman]

thanks it worked perfectly

[AJCFreeman]

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

[PGStats]

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

[AJCFreeman]

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

[ChrisNZ]

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