DATA Step, Macro, Functions and more

Retrieving LIBNAME options

Reply
Occasional Contributor
Posts: 11

Retrieving LIBNAME options

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

Super User
Posts: 9,682

Re: Retrieving LIBNAME options

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

Or

proc options option=compress;run;

Ksharp

Occasional Contributor
Posts: 11

Re: Retrieving LIBNAME options

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

Super User
Posts: 9,682

Re: Retrieving LIBNAME options

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 .

Ask a Question
Discussion stats
  • 3 replies
  • 233 views
  • 0 likes
  • 2 in conversation