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?
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...
View solution in original post
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Register now!
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.