I usually have better luck adding a subquery and I am assuming that the dups are existing in the amount column otherwise if its just the other columns the group by, by itself, should return distinct combinations of col1 - col5: Proc sql; select col1, col2, col3, col4 , col5, count(*) as number, sum(amount) as amount from (select distinct col1, col2, col3, col4, col5, amount from tablename) group by col1, col2, col3, col4, col5 ; quit; An example of the data may be in order to help explain the issue you are seeing. EJ
... View more