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 (1413 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 (1556 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 (1557 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

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!