topic max value in SAS Programming

max value

hillcat27 — Fri, 10 Aug 2012 14:57:12 GMT

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!

Re: max value

Linlin — Fri, 10 Aug 2012 15:06:55 GMT

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;