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.
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;
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.
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.
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.
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.
Ready to level-up your skills? Choose your own adventure.