I realize this is an old thread and the op already came up with a solution, but for future reference and my own development would the "distinct" keyword not have worked to remove all observations that were identical across all variables in proc sql? For instance, proc sql; create table x as select DISTINCT (variable1), variable2, variable3, variable4, etc.... from old_table; quit;
... View more
