DATA Step, Macro, Functions and more

SELECT DISTINCT ON

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 107
Accepted Solution

SELECT DISTINCT ON

Is it possible to do a SELECT DISTINCT ON in PROC SQL?

Accepted Solutions
Solution
‎11-21-2017 05:13 PM
Super User
Posts: 5,917

Re: SELECT DISTINCT ON

Posted in reply to tomcmacdonald
No, the syntax as you print it is not supported in SAS SQL.
Just guessing here but could the NODUPKEY option in PROC SORT give you the same result?
Data never sleeps

View solution in original post


All Replies
Solution
‎11-21-2017 05:13 PM
Super User
Posts: 5,917

Re: SELECT DISTINCT ON

Posted in reply to tomcmacdonald
No, the syntax as you print it is not supported in SAS SQL.
Just guessing here but could the NODUPKEY option in PROC SORT give you the same result?
Data never sleeps
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 175 views
  • 0 likes
  • 2 in conversation