Ideally you should fix the code that genarates that table. We can't help without knowing what that code is. But you might simply want to correct for its flaws by adding a step like: proc sql; create table want as select id, max(cat) as CAT, gr, sg from have group by id; quit; PG
... View more