/* maybe a sample dataset in the example would help */ data shoes; set sashelp.shoes;id_columns = _n_; run; data shoes1; set sashelp.shoes(obs=11) ; id_columns = _n_;run; data shoes1; set shoes shoes1; run; proc sql; create table shoes2 as select * from shoes1 where ID_columns not in ( select ID_columns from ( select ID_columns , count(*) as records from shoes1 group by ID_columns ) where records > 1 ); quit; run; data ck; set shoes2; run;
... View more