duplicate lines

[Mirou]

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 · Accepted solution]

proc sql;

create table want as

select distinct *

from db_table;

quit;

[Mirou]

thank you !

[PeterClemmensen]

Do like this

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