Thank you Sir @PGStats and my apologies to OP @Sinakian1 please see the revised: data have;
input ID score;
datalines;
1 10
1 20
1 30
2 20
2 30
3 50
3 60
;
proc sql;
create table want as
select *,case when score = min(score) then range(score) else . end as range
from have
group by id
order by id,score;
quit;
... View more
