https://communities.sas.com/t5/SAS-Programming/Performance-of-sort-nodupkey-vs-sql-select-distinct/m-p/869719#M343540 <P>Dear community,</P> <P>I'm sure I've read posts / articles about this before but don't seem to be able to retrieve them right now ... Is there any systematic performance difference between PROC SORT NODUPKEY and PROC SQL SELECT DISTINCT when one needs to retrieve a list of unique values?</P> <P>Many thanks in advance</P> <P>Cheers</P> <P>Anne.</P> Fri, 14 Apr 2023 09:16:47 GMT Anne_A 2023-04-14T09:16:47Z https://communities.sas.com/t5/SAS-Programming/Performance-of-sort-nodupkey-vs-sql-select-distinct/m-p/869719#M343540 <P>Dear community,</P> <P>I'm sure I've read posts / articles about this before but don't seem to be able to retrieve them right now ... Is there any systematic performance difference between PROC SORT NODUPKEY and PROC SQL SELECT DISTINCT when one needs to retrieve a list of unique values?</P> <P>Many thanks in advance</P> <P>Cheers</P> <P>Anne.</P> Fri, 14 Apr 2023 09:16:47 GMT https://communities.sas.com/t5/SAS-Programming/Performance-of-sort-nodupkey-vs-sql-select-distinct/m-p/869719#M343540 Anne_A 2023-04-14T09:16:47Z https://communities.sas.com/t5/SAS-Programming/Performance-of-sort-nodupkey-vs-sql-select-distinct/m-p/869723#M343542 <P>OK, found the answer. Thanks everyone anyway!</P> <P>&nbsp;</P> <P><A href="https://support.sas.com/resources/papers/proceedings11/242-2011.pdf" target="_blank">242-2011: Don't Waste Too Many Resources to Get Your Data in a Specific Sequence (sas.com)</A></P> Fri, 14 Apr 2023 09:27:19 GMT https://communities.sas.com/t5/SAS-Programming/Performance-of-sort-nodupkey-vs-sql-select-distinct/m-p/869723#M343542 Anne_A 2023-04-14T09:27:19Z