How to output a list of all libraries in SAS?

[Nehcour0420]

Hi there,

I am trying to get SAS print out a list of all libraries that are visible in EG. After Googling  around, I found that most of the articles are about output the datasets within certain libraries but not the list of the libraries. (I have access to EG, DI Studio and SAS MC)

Any thoughts?

Thanks,

Eric

[LinusH · Accepted solution]

libname _all_ list;

dictionary.libnames accessible from proc sql (or sashelp.vlibnam from other SAS programs).

[Nehcour0420]

Thanks Linus, that's very helpful!

[twocanbazza]

FYI

I think that the above suggestion will only list the Libraries that are assigned in EG, however there may be some that are visable although not assigned - non-preassigned metadata libraries (These libraries are still visible from EG )

[Nehcour0420]

Thanks Barry, I have noticed that as well. Just wondering if you know there is any way to resolve that?

Eric

[AnnaBrown]

Hello Eric,

I've cross-posted this to the SAS Macro Facility, Data Step and SAS Language Elements community in case anyone has input on this.

Anna

[Patrick]

The not pre-assigned libraries are the ones which are only defined in SAS Metadata. The libname statement hasn't been executed yet on the compute tier (eg. the workspace server).

The only way of retrieving such library definitions is by querying metadata. SAS(R) 9.3 Language Interfaces to Metadata, either by using Proc Metadata or the metadata specific data step functions.

[twocanbazza]

Hi Stumbled on this and thought it may help.  I believe it provides the answer you need (although the document has been mentioned here, here is the specific link I think)

SAS(R) 9.3 Language Interfaces to Metadata

Barry