Proc rank in SQL

[kashlik123]

I am working on a project where a model that was built in SAS has to implemented into Oracle SQL.

My question is simply how can I do this in Oracle SQL:

data have;
infile datalines delimiter=',';
input var $ value;
datalines;                      
var_x,1
var_x,1
var_x,1
var_x,2
var_x,2
var_x,2
var_x,3
var_x,3
var_x,3
var_x,4
var_x,4
var_x,5
;
run;

proc rank data=have out=want groups=10 ties=high;
var value;
ranks rank;
run;

[Tom]

Look into PERCENT_RANK() .  That should get you a number between zero and 1.  You could then use FLOOR() and division to generate a number between 0 and 9.