topic Re: Retrieving LIBNAME options in SAS Programming

Retrieving LIBNAME options

VinayKY — Thu, 12 Jul 2012 08:31:58 GMT

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

Re: Retrieving LIBNAME options

Ksharp — Thu, 12 Jul 2012 09:22:28 GMT

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

proc options option=compress;run;

Ksharp

Re: Retrieving LIBNAME options

VinayKY — Thu, 12 Jul 2012 09:29:22 GMT

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

Re: Retrieving LIBNAME options

Ksharp — Fri, 13 Jul 2012 04:36:51 GMT

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 .