max value

Reply
Occasional Contributor
Posts: 10

max value

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!

Super Contributor
Posts: 1,636

Re: max value

Posted in reply to hillcat27

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;

Ask a Question
Discussion stats
  • 1 reply
  • 170 views
  • 0 likes
  • 2 in conversation