I'd say it's because eliminating duplicate records isn't really a core feature; it's just a useful by-product of the SUM function.
Obviously, there's a world of divers requirements out there, but SORT focuses on cases where you want to combine information from duplicate keys, not just ignore them. sas On Wed, Sep 20, 2017 at 11:41 AM, Sri h Kolusu <skol...@us.ibm.com> wrote: >> I always wondered why the function to simply eliminate duplicate >> records is hidden within the SUM function? This is awkward. Why >> isn't there a clear and straight forward keyword either on the >> OPTION or on the SORT statement, such as NODUPLICATES/DUPLICATES? >> ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN