Date:         Tue, 23 Aug 2005 14:37:49 -0500
Reply-To:     Russell D Newhouse <NEWHOUSE_RUSSELL_D@LILLY.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Russell D Newhouse <NEWHOUSE_RUSSELL_D@LILLY.COM>
Subject:      Re: libnames dictionary table
Comments: To: SAS User <sas@SDAC.HARVARD.EDU>
In-Reply-To:  <Pine.GSO.4.10.10508231517260.12886-100000@davinci.harvard.edu>
Content-Type: text/plain; charset="US-ASCII"

Mainly because LIBNAMES is not a PROC SQL Dictionary Table.

The available tables are:
CATALOGS
COLUMNS
EXTFILES
INDEXES
MEMBERS
OPTIONS
TABLES
VIEWS

One paper I always keep on hand about this topic is "You Could Look It Up:
An Introduction to SASHELP Dictionary Views" by Michael Davis (SUGI 26,
Paper 17-26).

You can find it in the online SUGI Proceedings.

http://support.sas.com/usergroups/sugi/proceedings/index.html






SAS User <sas@SDAC.HARVARD.EDU>
Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
08/23/2005 02:18 PM
Please respond to
SAS User <sas@SDAC.HARVARD.EDU>


To
SAS-L@LISTSERV.UGA.EDU
cc

Subject
libnames dictionary table






Does anyone know why I wouldn't be able to access the "libnames"
table?  Solaris, V8.2.  I get the following:

  1? proc sql;
  2? describe table dictionary.libnames;

ERROR: LIBNAMES is not a recognised PROC SQL Dictionary Table.

Any ideas?

Thanks.
-casey