Date:         Fri, 6 Apr 2001 09:40:17 -0500
Reply-To:     "Blodgett, John G." <BlodgettJ@UMSYSTEM.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Blodgett, John G." <BlodgettJ@UMSYSTEM.EDU>
Subject:      Re: Problem trying to sort a view
Comments: To: "Don_Stanley@bnz.co.nz" <Don_Stanley@bnz.co.nz>
Content-Type: text/plain; charset="iso-8859-1"

Yes, the sortedby spec applies to a physical table referenced by the view,
not the view.
In defining a view within sql, 1-level data set references are implied to be
in the same data library as the view being created.  (As far as I know this
is the only place in SAS where a 1-level name does not default to work or
user.)  The advantage of using the single level name in the definition is
that it allows the view to work even if you access it using a different
libref that the one used to create the view definition.


John Blodgett
OSEDA (Office of Social & Economic Data Analysis)
626 Clark Hall -- University of Missouri
Columbia, MO  65211
PH: 573-884-2727  FX: 573-884-4635
e-mail: blodgettj@umsystem.edu
URL: http://www.oseda.missouri.edu/jgb/


> -----Original Message-----
> From: Don_Stanley@bnz.co.nz [mailto:Don_Stanley@bnz.co.nz]
> Sent: Friday, April 06, 2001 12:08 AM
> To: HERMANS1@WESTAT.COM; blodgettj@umsystem.edu
> Subject: Re: Problem trying to sort a view
>
>
> sig wrote ..... "It appears that you are mixing too many
> metaphors!  Sorting
> really means to
> put records in a file in a specific sequence.  You are trying
> to set sort
> order as a property of a virtual table.  The table does not
> exist at that
> stage.
>
> SI has done a remarkable job of integrating physical
> implementations, such
> as sort orders, with logical orderings.  You are stretching
> the limits of
> metadata when you try to maintain a "sorted by" property of a
> virtual table."
>
> I don't think he has a "sorted by" property on the virtual
> table. The virtual
> table is the view. The "sorted by" is stated to be on SDGEOS
> which appears to be
> a physical table and thus legitimately can have a sorted by.
>
> What I'm curious about is that the view as shown references a
> table in WORK, ie
> WORK.SDGEOS, but the log implies that is not the case .. SQL table
> PL942000.SDGEOS (alias =G). Am I missing something here or is
> John perhaps
> picking up the wrong view?
>
> Don
>
> WARNING: The contents of this E-mail may contain information
> that is legally
>         privileged and/or confidential to the named
> recipient. This information
>         is not to be used by any other person and/or
> organisation. The views
>         expressed in this document do not necessarily reflect
> those of the Bank
>         of New Zealand.
>
>