I have this data: data dat;
input ID 10 domain rowpercent;
datalines;
RZL34500 1 2.8
RZL34500 2 0.0
RZL34500 3 71.1
RZL34500 4 0.0
RZL34500 5 4.8
RZL34500 6 2.8
RZL34500 7 2.9
RZL34500 8 4.8
RZL34500 9 4.8
RZL34500 10 0.0
RZL34500 11 0.0
RZL34500 12 0.0
RZL34500 13 0.0
RZL34500 14 2.5
RZL34500 15 0.0
RZL34500 16 0.0
RZL34500 17 0.0
RZL34500 18 0.0
RZL34500 19 0.0
; I am trying to rank it so that higher values are ranked higher: proc rank data=dat out=temp_1 ties=mean descending;
by id;
var RowPercent;
ranks rank;
run; My results are: ID domain rowpercent rank
RZL34500 1 2.8 6.5
RZL34500 2 0 14
RZL34500 3 71.1 1
RZL34500 4 0 14
RZL34500 5 4.8 3
RZL34500 6 2.8 6.5
RZL34500 7 2.9 5
RZL34500 8 4.8 3
RZL34500 9 4.8 3
RZL34500 10 0 14
RZL34500 11 0 14
RZL34500 12 0 14
RZL34500 13 0 14
RZL34500 14 2.5 8
RZL34500 15 0 14
RZL34500 16 0 14
RZL34500 17 0 14
RZL34500 18 0 14
RZL34500 19 0 14 Why are there multiple '3's and '14's? Secondary question: Is there a way that I can rank these values such that I get an accurate 'top 3'? Thanks in advance
... View more