Solved: SELECT DISTINCT ON - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Quartz | Level 8

Quartz | Level 8

SELECT DISTINCT ON

Posted 11-21-2017 04:43 PM (1376 views)

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

1 ACCEPTED SOLUTION

Accepted Solutions

Tourmaline | Level 20

Tourmaline | Level 20

Re: SELECT DISTINCT ON

Posted 11-21-2017 04:54 PM (1519 views) | 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

1 REPLY 1

Tourmaline | Level 20

Tourmaline | Level 20

Re: SELECT DISTINCT ON

Posted 11-21-2017 04:54 PM (1520 views) | 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