https://communities.sas.com/t5/SAS-Programming/SELECT-DISTINCT-ON/m-p/415325#M101835 No, the syntax as you print it is not supported in SAS SQL.<BR />Just guessing here but could the NODUPKEY option in PROC SORT give you the same result? Tue, 21 Nov 2017 21:54:03 GMT LinusH 2017-11-21T21:54:03Z https://communities.sas.com/t5/SAS-Programming/SELECT-DISTINCT-ON/m-p/415320#M101834 Is it possible to do a SELECT DISTINCT ON in PROC SQL? Tue, 21 Nov 2017 21:43:55 GMT https://communities.sas.com/t5/SAS-Programming/SELECT-DISTINCT-ON/m-p/415320#M101834 tomcmacdonald 2017-11-21T21:43:55Z https://communities.sas.com/t5/SAS-Programming/SELECT-DISTINCT-ON/m-p/415325#M101835 No, the syntax as you print it is not supported in SAS SQL.<BR />Just guessing here but could the NODUPKEY option in PROC SORT give you the same result? Tue, 21 Nov 2017 21:54:03 GMT https://communities.sas.com/t5/SAS-Programming/SELECT-DISTINCT-ON/m-p/415325#M101835 LinusH 2017-11-21T21:54:03Z