max value

[hillcat27]

Hello,

Simple problem: I need to create a data set in which the maximum value is reported for each categorical variable.  For example:

Col1   Col2

a          2

a          1

a          0

b          3

b          0

c          1    

c          2

c          3

Would read as follows:

Col1     Col2

a          2

b          3

c          3

Many thanks!

[Linlin]

data have;

input Col1 $  Col2;

cards;

a          2

a          1

a          0

b          3

b          0

c          1    

c          2

c          3

;

proc sql;

  create table want as

    select col1,max(col2) as col2

   from have

     group by col1;

  quit;