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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.