What is the current value of a non global option?

[xxformat_com]

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

[JerryV]

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

https://go.documentation.sas.com/?docsetId=proc&docsetTarget=p167ky4zsoxrn2n1myz6iisao1wc.htm&docset... 

[xxformat_com]

Unfortunately not.

[JerryV]

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

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;

[xxformat_com]

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?

[Tom · Accepted solution]

---

@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.