topic Re: Removing duplicate observation in SAS Data Management

Removing duplicate observation

mlogan — Tue, 09 Feb 2016 02:28:36 GMT

Hi All,

Can someone tell me what would be the code for removing completely identical/duplicate observations from the database?

Thanks.

Astounding — Tue, 09 Feb 2016 03:18:49 GMT

Untested but it should work:

proc sort data=have nodupkey;

by _all_;

run;

Reeza — Tue, 09 Feb 2016 03:33:52 GMT

NODUPRECS via proc sort, no longer in SAS 9.4 I believe

DISTINCT via Proc SQL

proc sort data=have nodupkey out=unique1;
by _all_;
run;


proc sql;
create table unique2 as
select distinct *
from have;
quit;