Help using Base SAS procedures

eliminating duplicate entries

Reply
Contributor
Posts: 27

eliminating duplicate entries

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.

PROC Star
Posts: 7,473

eliminating duplicate entries

Posted in reply to willy0625

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;

Super User
Posts: 10,028

Re: eliminating duplicate entries

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

N/A
Posts: 1

eliminating duplicate entries

Posted in reply to willy0625

proc sql;

    create table dsn as

    select distinct class, subject, score

    form your_dataset

    group by class

    having score=max(score)

    ;

quit;

Ask a Question
Discussion stats
  • 3 replies
  • 129 views
  • 6 likes
  • 4 in conversation