topic getting max and min value by group in SAS Programming

getting max and min value by group

esita — Fri, 21 Aug 2015 16:16:16 GMT

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 — Fri, 21 Aug 2015 16:24:59 GMT

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 — Fri, 21 Aug 2015 16:25:23 GMT

This is the code I used

data max_min_new;

set max_min;

maxvalue= max(of value);

by group;

run;

lxn1021 — Fri, 21 Aug 2015 16:28:51 GMT

proc sql;

select group as group,

max(value) as value

from max_min

group by group;

quit;