topic Re: Find library properties using code in SAS Programming

Find library properties using code

Jeff_DOC — Fri, 05 Jan 2024 19:39:08 GMT

Hello.

I am looking for a way to list library properties. If I right click on a library and select properties I can see the properties, i.e., Type, Description, Server, Engine Location, Options, Libref, Read Only and Temporary. I'm looking for a way to simply list all properties of a library.

I don't have any example code as I can't find any place to start.

If someone could point me in a potential direction that would be very helpful.

Thank you.

Re: Find library properties using code

ChrisHemedinger — Fri, 05 Jan 2024 19:45:30 GMT

You can get lots of details from the DICTIONARY tables, easily accessed via SASHELP.VLIBNAM.

proc sql; create table details as select * from sashelp.vlibnam; quit;

Re: Find library properties using code

Jeff_DOC — Fri, 05 Jan 2024 19:50:47 GMT

I did look there but the variables it listed were incomplete. For instance, I can see an options variable in the properties but it doesn't show up in when I look in vlibnam.

Re: Find library properties using code

ChrisHemedinger — Fri, 05 Jan 2024 19:58:11 GMT

You will get similar details from:

libname _all_ list;

Some libname engines with special suboptions (for databases, for example) might not be "findable" through these methods.