Date:         Wed, 24 May 2006 15:15:50 -0700
Reply-To:     David L Cassell <davidlcassell@MSN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David L Cassell <davidlcassell@MSN.COM>
Subject:      Re: sql don't do sortedby?
In-Reply-To:  <200605242123.k4OIVS2m016687@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

HERMANS1@WESTAT.COM sagely replied:
>All:
>Note that resetting the value of the sortedby value does not necessarily
>mean that the dataset will correctly sorted from the viewpoint of that
>OS. Two exceptions come to mind where ordering by a key in a pass-thru
>query to a DB server:
>- differences in EBCIDIC and ASCII collating sequences;
>- differences in data representation between Unix/Linux SAS datasets and
>MS Windows SAS datasets.

And differences due to NLS settings, since different apps have different
sort sequences for different languages.  See the SORTSEQ= option.

And, of course, there's bound to be at least one more case out there...

David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement