Date:         Mon, 7 May 2007 17:21:58 -0500
Reply-To:     Kevin Myers <kmyers1@CLEARWIRE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Kevin Myers <kmyers1@CLEARWIRE.NET>
Subject:      Re: Finding all the values of an index variable
Comments: To: Sigurd Hermansen <HERMANS1@WESTAT.com>,
          "Keintz, H. Mark" <mkeintz@wharton.upenn.edu>
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
              reply-type=original

----- Original Message -----
From: "Sigurd Hermansen" <HERMANS1@WESTAT.com>
To: "Keintz, H. Mark" <mkeintz@wharton.upenn.edu>; <SAS-L@LISTSERV.UGA.EDU>
Sent: Monday, May 07, 2007 17:08
Subject: RE: Finding all the values of an index variable


<snip>

> proc sql stimer;
>   create table distinctiXSQL as
>   select distinct iX from test (sortedby=iX)
>   ;
> quit;

<snip>

> The SAS SQL query needlessly sorted the
> dataset and thus would require O(nlogn) time.

<snip>

Good grief.  Why in the world is SQL sorting the dataset, when it should
already know that the dataset is both sorted and indexed by the requested
distinct column?  That seems like a bug, and should probably be reported to
SI.

s/KAM