topic What is the current value of a non global option? in SAS Programming

What is the current value of a non global option?

xxformat_com — Wed, 29 Apr 2020 20:56:49 GMT

Hi,

We use proc options, to list the values of global options.

Is there a similar procedure to list the values of procedures' options, etc.

e.g. how can I find out which value for "version=" option is used by the xlsx engine for a given installation beside looking at the SAS online doc?

Best Regards

Re: What is the current value of a non global option?

JerryV — Wed, 29 Apr 2020 21:45:23 GMT

Would proc product_status; run; give you what you need?

https://go.documentation.sas.com/?docsetId=proc&docsetTarget=p167ky4zsoxrn2n1myz6iisao1wc.htm&docsetVersion=9.4&locale=en

Re: What is the current value of a non global option?

xxformat_com — Thu, 30 Apr 2020 17:28:32 GMT

Unfortunately not.

Re: What is the current value of a non global option?

JerryV — Thu, 30 Apr 2020 18:07:05 GMT

How about the function tslvl(). https://go.documentation.sas.com/?docsetId=hostunx&docsetTarget=p0fjexseegel6tn1w5solsj5gofg.htm&docsetVersion=9.4&locale=en

If you're using EG you can:

data a;
set _prodsavail;
licensed=sysprod(prodcode);
  do option='A', 'D', 'E', 'F', 'H', 'I', 'M', 'P', 'S', 'T' ;
    tslvl = tslvl(prodmod,option);
        output;
  end;
run;

Otherwise try:

data b; 
prodcode='prodnum208';	prodmod='sasdbf';
  do option='A', 'D', 'E', 'F', 'H', 'I', 'M', 'P', 'S', 'T' ;
    tslvl = tslvl(prodmod,option);
        output;
  end;
run;

Re: What is the current value of a non global option?

xxformat_com — Thu, 30 Apr 2020 19:28:05 GMT

Thanks for the support. I guess I have not formulate properly my request.
I'm not looking at the SAS installation product version
but at procedures' options default value and sas excel... engine default/actual options.

eg. libname ... excel '....xlsx' version=???;
what is the default/actual version used here? can I find it using a program?

Re: What is the current value of a non global option?

Tom — Thu, 30 Apr 2020 23:46:17 GMT

@xxformat_com wrote:
Thanks for the support. I guess I have not formulate properly my request.
I'm not looking at the SAS installation product version
but at procedures' options default value and sas excel... engine default/actual options.

eg. libname ... excel '....xlsx' version=???;
what is the default/actual version used here? can I find it using a program?

The answer is NO. In general since you are writing the code just remember what you wrote.

%let print_noprint = noprint;
proc sql &print_noprint;
...

Procedures are written to preform what they perform. There is no concept of telling you want they are doing. You tell them what to do.

There is some metadata available for LIBREF and FILEREF values by querying the DICTIONARY tables, but they do not normally have all of the options. But you should be able to find out what path they are pointing to.