topic Select row based on max value in SAS Data Science

Select row based on max value

eagles_dare13 — Tue, 23 Sep 2014 14:30:41 GMT

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 — Tue, 23 Sep 2014 14:43:42 GMT

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...