Can someone tell me what would be the code for removing completely identical/duplicate observations from the database?
Untested but it should work:
proc sort data=have nodupkey;
NODUPRECS via proc sort, no longer in SAS 9.4 I believe
DISTINCT via Proc SQL
proc sort data=have nodupkey out=unique1;
create table unique2 as
select distinct *