BookmarkSubscribeRSS Feed
Jeff_DOC
Pyrite | Level 9

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.

3 REPLIES 3
ChrisHemedinger
Community Manager

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;
SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
Jeff_DOC
Pyrite | Level 9

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.

ChrisHemedinger
Community Manager

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.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1710 views
  • 3 likes
  • 2 in conversation