topic eliminating duplicate entries in SAS Procedures

eliminating duplicate entries

willy0625 — Fri, 29 Jul 2011 01:51:48 GMT

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 — Fri, 29 Jul 2011 02:39:32 GMT

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;

JiamengYuan — Fri, 29 Jul 2011 03:11:16 GMT

proc sql;

create table dsn as

select distinct class, subject, score

form your_dataset

group by class

having score=max(score)

;

quit;

Ksharp — Wed, 03 Aug 2011 05:43:39 GMT

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