i have table :
emitter receiver dur t_dur pct_dur pcum rank_123 123 12 6038 24843 0.243 0.243 1 (...) 123 578 256 24843 0.010 0.832 22.5 123 456 256 24843 0.010 0.842 22.5 (...) i have proc sql every case rank integer. when it's 22,5 have choose tiebreaker, want pick bigger one. (at point, these variables, tiebreaker choose?)
i tried :
proc sql; create table work.teste_up_top22_123 select emitter, pcum top22 work.base rank_123=22.5 , max(receiver); quit; in "teste_up_top22_123" want have value of emitter , value of cumulative percentage (pcum) ranking 22,5 , value of receiver bigger. so, stay:
emitter top22 123 0.832 how can this? , in cases have more 2 numbers ranking 22,5, it's same procedure?
thanks!
try this:
proc sql; create table work.teste_up_top22_123 select emitter, pcum top22 work.base rank_123=22.5 having receiver=max(receiver); quit;
Comments
Post a Comment