topic Re: rank by group and show the cutoffs in SAS Programming

rank by group and show the cutoffs

asasha — Fri, 19 Mar 2021 16:34:39 GMT

Hello, I need to rank a numeric variable into 5 groups by another categorical variable and also get the cutoffs. I currently have this code:

proc rank data=dsout out=ranks groups=5;
   by var2;
   var var1;
   ranks var1_rank;
run;

I have 2 columns now (var1, var2), and I want the output to be 4 columns. The var1 ranks by var2 (var1_rank) derived using the above code and the cutoff values (range) that would take a value like '0.0999254969 <= x1 < 0.1993986319' based on how the ranks are calculated. Thanks.

Re: rank by group and show the cutoffs

Reeza — Fri, 19 Mar 2021 17:05:07 GMT

I don't think there's a good way to do this all in one step except a manual data step...curious to see other answers.

Assuming you don't want that, I'd use PROC RANKS and then pass the results to PROC MEANS and find the MIN/MAX for each RANK and merge that back into my output from PROC RANK.

Example of adding average value to a data set - modify it to return min/max instead of average.
https://github.com/statgeek/SAS-Tutorials/blob/master/add_average_value_to_dataset.sas