DATA Step, Macro, Functions and more

How to remove duplicates using proc SQL without Distinct

Reply
Frequent Contributor
Posts: 140

How to remove duplicates using proc SQL without Distinct

How to remove duplicates using proc SQL without Distinct

Super User
Super User
Posts: 7,407

Re: How to remove duplicates using proc SQL without Distinct

What do you mean, please provide test input data and required output, with a description of what you mean by duplicates.  The reason being that the sole function of distinct is to remove duplicates, and without some more, perhaps complicated code, you not going to get a better option.

SQL SELECT DISTINCT Statement

Super User
Posts: 9,682

Re: How to remove duplicates using proc SQL without Distinct

What does your sample data look like ?

Ask a Question
Discussion stats
  • 2 replies
  • 242 views
  • 0 likes
  • 3 in conversation