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;
Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
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.

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

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
  • 1226 views
  • 3 likes
  • 2 in conversation