Hi all,
I am trying to get min and max value by group. Can anyone please help?
data max_min;
input group $ value;
datalines;
g1 30
g2 37
g2 76
g3 22
g3 84
g4 15
g4 21
g4 94
g4 73
;
run;
I want to get this output
group value
g1 30
g2 76
g3 84
g4 94
Thank You!!
proc means data=max_min max min;
class group;
var value;
run;
This gets the max a min values as that is what your subject line said.
proc means data=max_min max min;
class group;
var value;
run;
This gets the max a min values as that is what your subject line said.
This is the code I used
data max_min_new;
set max_min;
maxvalue= max(of value);
by group;
run;
proc sql;
select group as group,
max(value) as value
from max_min
group by group;
quit;
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.