topic Re: duplicate lines in SAS Programming

duplicate lines

Mirou — Thu, 02 May 2019 17:17:49 GMT

Hello,

I need to delete duplicate lines (identical observations) from a data base,

i have a databse with many columns (100 columns) how shouldi proceed.

Thanks

novinosrin — Thu, 02 May 2019 17:21:17 GMT

proc sql;

create table want as

select distinct *

from db_table;

quit;

PeterClemmensen — Thu, 02 May 2019 17:22:53 GMT

Do like this

proc sort data=YourData out=NoDuplicates nodupkey;
	by _all_;
run;

Mirou — Thu, 02 May 2019 17:30:27 GMT

thank you !