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

Please I need assistance:

 

I have 

 

Data ABC;

X   Y

2    a

1    a

4    b

3    b

;

 

I want maximum of X for each of Y (maximum based on criteria).

 

so output would be 

 

NEW

X  Y

2  a

4  b

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
hbi
Quartz | Level 8 hbi
Quartz | Level 8

Try this: 

 

 

DATA ABC;
  x=2; y='a'; output;
  x=1; y='a'; output;
  x=4; y='b'; output;
  x=3; y='b'; output;
RUN;

PROC SQL;
  CREATE TABLE want AS 
  SELECT max(x) as max_x, y
  FROM ABC
  GROUP BY y;
QUIT;

View solution in original post

4 REPLIES 4
hbi
Quartz | Level 8 hbi
Quartz | Level 8

Try this: 

 

 

DATA ABC;
  x=2; y='a'; output;
  x=1; y='a'; output;
  x=4; y='b'; output;
  x=3; y='b'; output;
RUN;

PROC SQL;
  CREATE TABLE want AS 
  SELECT max(x) as max_x, y
  FROM ABC
  GROUP BY y;
QUIT;
Olaajay
Calcite | Level 5

Thank you all! I just used the first solution given and it worked, I appreciate your help!

PGStats
Opal | Level 21

The simplest way is:

 

proc sql;
create table NEW as
select max(X) as X, Y
from ABC
group by Y;
quit;
PG
ballardw
Super User

If result not appearance is acceptable:

proc means data=have max;
class y;
var x;
run;

I would recommend becoming familiar with the procs such as means as I can add large number of statistics such a min, median, mean, standard deviation, range, skewness, kurtosis, a number of percentiles and such by adding them to the list where MAX appears above. 

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!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1941 views
  • 0 likes
  • 4 in conversation