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;