BookmarkSubscribeRSS Feed
VinayKY
Calcite | Level 5

Hi

How do I retrieve options specified on a library while allocating it programatically in SAS 9.1.3?

Suppose, I have following statement:

libname mylib '/path/to/mylib' compress=yes;

So, How do I know that the libref 'mylib' defined above is a compressed library? I could not find any relevant dictionary table which holds this information....

Also, if I run following statement, it prints the info in SAS log, making me think that SAS does hold the information somewhere:

libname mylib list;

Following are few initial lines of log(which prints compress value):

NOTE: Libref=   MYLIB

      Scope=    IOM ROOT COMP ENV

      Engine=   V9

      Compress= YES

Thanks

Vinay

3 REPLIES 3
Ksharp
Super User

That is System option . You need to check it at dictionary.options .

Or

proc options option=compress;run;

Ksharp

VinayKY
Calcite | Level 5

Hi Ksharp

'Compress' is system option too and can be specified on a LIBNAME too. There are other options which could be specified on LIBNAME statement.

My question specifically is related to LIBNAME option only. How to I retrieve options specified on LIBNAME statement?

Hope it makes it clear

Thanks

Vinay

Ksharp
Super User

That is a complicated problem. You can mix libname option and system option as you did .

Different engine has different options . Maybe you need to check it at Documentation for different Engine .

Or talk to Technology Support .

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of 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
  • 1115 views
  • 0 likes
  • 2 in conversation