Select row based on max value

[eagles_dare13]

I have a table like this:

col1 col2    col3      col4

A    B      alpha      0.5

A    B      beta       1.00

col4 is numeric.

Now I want the row corresponding to the max value of col4, so I just want to select the second row. How to do this?

[RW9 · Accepted solution]

You could do:

proc sort data=have (obs=1);

     by descending col4;

run;

Or:

proc sql;

  create table WANT as

  select  *

  from    SASHELP.CLASS

  having  HEIGHT=max(HEIGHT);

quit;

Or proc means...