topic How to delete duplicated observations in the data sets. in SAS Procedures

How to delete duplicated observations in the data sets.

sos — Wed, 02 Nov 2011 02:06:23 GMT

Hi, folks,

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

Thanks!

art297 — Wed, 02 Nov 2011 02:36:28 GMT

proc sort data=yourdatafile nodupkey;

by thevariablelistwithinwhichyoudontwantduplicates;

run;

may do what you want.

ballardw — Wed, 02 Nov 2011 21:49:22 GMT

Possibly more effecient in some situations:

Proc sql;

Create table nodup as

select distinct *

from yourdataset;

quit;