SAS - How to find the max value between 2 or 3 numbers -


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