Hi All,
Can someone tell me what would be the code for removing completely identical/duplicate observations from the database?
Thanks.
Untested but it should work:
proc sort data=have nodupkey;
by _all_;
run;
NODUPRECS via proc sort, no longer in SAS 9.4 I believe
or
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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.