How about this? A little cleanup. /* 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; select region , product , subsidiary , max(ID_columns) as id_columns from shoes1 group by region , product , subsidiary ; quit; proc sql; create table shoes2 as select * from shoes1 where id_columns in ( select max(ID_columns) as id_columns from shoes1 group by region , product , subsidiary ); quit; run; data ck; set shoes2; run;
... View more
