proc sql;
     create table newtable as
        select distinct Col1, Col2, Col3, Col4, ... , Col10 from oldtable;
quit;

proc sql;
     create table newtable as
        select (distinct Col3), * from oldtable;
quit;