BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
eagles_dare13
Obsidian | Level 7

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?

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to choose a machine learning algorithm

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.

Discussion stats
  • 1 reply
  • 33613 views
  • 2 likes
  • 2 in conversation