getting max and min value by group

[esita]

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

[ballardw · Accepted solution]

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.

[esita]

This is the code I used

data max_min_new;

set max_min;

maxvalue= max(of value);

by group;

run;

[lxn1021]

proc sql;

     select group as group,

          max(value) as value

          from max_min

          group by group;

quit;