topic Re: How to output a list of all libraries in SAS? in SAS Data Management

How to output a list of all libraries in SAS?

Nehcour0420 — Mon, 21 Oct 2013 13:46:27 GMT

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

Re: How to output a list of all libraries in SAS?

LinusH — Mon, 21 Oct 2013 14:01:19 GMT

libname _all_ list;

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

Re: How to output a list of all libraries in SAS?

Nehcour0420 — Mon, 21 Oct 2013 14:20:11 GMT

Thanks Linus, that's very helpful!

Re: How to output a list of all libraries in SAS?

twocanbazza — Mon, 21 Oct 2013 21:23:20 GMT

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 )

Re: How to output a list of all libraries in SAS?

Nehcour0420 — Mon, 21 Oct 2013 23:58:24 GMT

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

Eric

Re: How to output a list of all libraries in SAS?

AnnaBrown — Tue, 29 Oct 2013 13:26:17 GMT

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

Re: How to output a list of all libraries in SAS?

Patrick — Tue, 29 Oct 2013 22:25:36 GMT

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.

Re: How to output a list of all libraries in SAS?

twocanbazza — Thu, 20 Feb 2014 23:38:52 GMT

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