topic Re: Libname _ALL_ LIST output is not limited to "currently assigned librefs" in SAS Enterprise Guide

Libname _ALL_ LIST output is not limited to "currently assigned librefs"

Michael_W — Thu, 04 Jun 2015 21:44:25 GMT

Here's my objective: I am trying generate a list of all of the libraries that are currently assigned in my EG session. The following link suggests that I can use the
Libname _ALL_ LIST command to list all of the librefs that are currently assigned. However, when I execute the command in an EG code node, it lists all librefs; those that are assigned and unassigned (and I only want the the assigned ones). SAS(R) 9.2 Companion for z/OS Is there another way to accomplish my objective?y

Thank you in advance,

Michael

Re: Libname _ALL_ LIST output is not limited to "currently assigned librefs"

jakarman — Thu, 04 Jun 2015 22:03:19 GMT

What do you mean with unassigned ones? They are either assigned or not assigned and the libname _all_ list is making a list of assigned one as seen by the SAS process.
Eguide doesn't play any role in this

There is something on preassigned librefs SAS(R) 9.4 Intelligence Platform: Data Administration Guide, Fourth Edition

SAS(R) 9.4 Intelligence Platform: Desktop Application Administration Guide, Fourth Edition the preassigned are yellow and defined not assigned white.

Re: Libname _ALL_ LIST output is not limited to "currently assigned librefs"

Kurt_Bremser — Fri, 05 Jun 2015 07:36:53 GMT

How do you know that a library listed by LIBNAME _ALL_ LIST; is not assigned?

Re: Libname _ALL_ LIST output is not limited to "currently assigned librefs"

ballardw — Fri, 05 Jun 2015 16:07:21 GMT

By any chance are you referring to libraries on a server you connect with? The server could well have active libraries that you are not using.

If you need libraries that only you use you may be able to examine dictionary.libnames and look at the paths

proc sql;

select * from dictionary.libnames;

quit;

Re: Libname _ALL_ LIST output is not limited to "currently assigned librefs"

Michael_W — Mon, 08 Jun 2015 15:39:17 GMT

BallardW,

Thank you kindly for responding and helping me with my issue. In Enterprise Guide, there are a handful of libraries that are registered in the metadata but that are not preassigned. In order to assign them, I need to manually do so by right clicking on the library icon in my server list. The LIBNAME _ALL_ LIST command picks up all libraries whether they're assigned or not. The solution/recommendation that you've provided below does exactly what I need!

Thank you very much!

Michael

Re: Libname _ALL_ LIST output is not limited to "currently assigned librefs"

Michael_W — Mon, 08 Jun 2015 15:46:12 GMT

Thank you kindly for responding to my issue. In EG, I have a handful of libraries that registered in the metadata but are not preassigned. In order to assign them, I need to manually do so by right clicking on the library icoon in my server list. The LIBNAME _ALL_ LIST command picks up all libraries whether they're assigned or not. The solution provided by BallwardW solved my issue.

Thank you very much,

Michael