topic Re: Get the value of a system option in SAS Programming

Get the value of a system option

NN — Fri, 17 Dec 2021 15:41:13 GMT

Hi Everyone,
Is there a way to get the value of an option into a dataset.\ ?

for example if i run the below statement it prints the value of option to the log.

but is there a way to get this value in a dataset so that i can check if mprint option is set to Mprint or nomprint?

proc options option=mprint;
run;

Re: Get the value of a system option

ballardw — Fri, 17 Dec 2021 15:59:43 GMT

You can use the DMOPTSAVE command with a data set to save the current settings of all options to a data set such as Work.myopts in the Display Manager. Not sure about other interfaces like Enterprise Guide or SAS Studio.

How you issue the command depends on your system.

You could then search for the name of the option, Optname and Optvalue. The on/off type options like MPRINT have values of "0" (off) or "1" (on). The option values are character because many of the system options like FMTSEARCH can have character values.

Re: Get the value of a system option

Reeza — Fri, 17 Dec 2021 16:03:42 GMT

Macro variables are more common:

/* Save the value of the MPRINT system option */
%let mprint_option = %sysfunc(getoption(MPRINT));

@NN wrote:

Hi Everyone,
Is there a way to get the value of an option into a dataset.\ ?

for example if i run the below statement it prints the value of option to the log.

but is there a way to get this value in a dataset so that i can check if mprint option is set to Mprint or nomprint?
proc options option=mprint;
run;

Re: Get the value of a system option

NN — Fri, 17 Dec 2021 16:37:35 GMT

Thanks @ballardw and @Reeza for your solutions.

The macro option is a quick solution for my current need hence i shall go ahead with it.

Re: Get the value of a system option

AllanBowe — Sat, 18 Dec 2021 14:30:57 GMT

If you ever need to reset that option back to it's original value, you could use this macro (inspired by @SASJedi ) : https://core.sasjs.io/mp__resetoption_8sas.html