How to delete duplicated observations in the data sets.

[sos]

Hi, folks,

   I find that there are lots of duplicated observations in my data sets. Is there a code to delete them automatically?

Thanks!

Wu

[art297]

proc sort data=yourdatafile nodupkey;

  by thevariablelistwithinwhichyoudontwantduplicates;

run;

may do what you want.

[ballardw]

Possibly more effecient in some situations:

Proc sql;

     Create table nodup as

     select distinct *

     from yourdataset;

quit;