eliminating duplicate entries

[willy0625]

I have the following table:

Class  subject  score

   A        mat       95

   A        phy       80

   B        eng       75

   B        che       90

   C        bio        98

How would keep only unique 'Class' variables and yet retain the maximum score(and the corresponding subject) so that the resulting table looks like

Class  subject  score

   A        mat       95

   B        che       90

   C        bio        98

Many thanks.

[art297]

One possibility would be two proc sorts:

proc sort data=have out=want;

  by descending score;

run;

proc sort data=want nodupkey;

  by class;

run;

[Ksharp]

Hi. Art.T

Why not does you write as:

proc sort data=have ;by class descending score;run;

proc sort data=have out=want nodupkey;

  by class ;

run;

I think your code is very brilliant!

Ksharp

[JiamengYuan]

proc sql;

    create table dsn as

    select distinct class, subject, score

    form your_dataset

    group by class

    having score=max(score)

    ;

quit;