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?
Content-Type: text/plain; format=flowed
HERMANS1@WESTAT.COM sagely replied:
>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 L. Cassell
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