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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: