topic Re: Proc rank in SQL in Developers

Question

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;