topic Re: sashelp for ods select all ? in ODS and Base Reporting

sashelp for ods select all ?

hartwell — Wed, 04 Dec 2024 18:59:30 GMT

I'm working on a macro that has to suppress some of its output using

ods rtf exclude all;

Under the assumption that the user was outputting to rtf (default user behavior for us), once this piece of the macro is done, it turns output back on using

ods rtf select all;

However, there are some use cases where the user was suppressing the printout of my macro outputs. In this case, I'd like my code to determine what ods output the user had selected and return to that after the excluded portion of macro code runs. Is there a sashelp/dictionary table that contains this information? I've already looked through vstyle, voption, vallopt, vrememb and didn't see anything specific that told me which state to revert to.

Re: sashelp for ods select all ?

Chevell_sas — Wed, 04 Dec 2024 20:06:18 GMT

One method of doing this as you mentioned is to use the SASHELP.VDEST table. Does this work for you? Either in SQL using the Dictionary.vdest table or in the DATA step.

data temp;
  set sashelp.vdest;
run;

Re: sashelp for ods select all ?

hartwell — Wed, 04 Dec 2024 20:19:00 GMT

Here's the table produced by printing sashelp.vdest, which I don't think is enough info for me to restore their defaults after I exclude everything.

Re: sashelp for ods select all ?

Chevell_sas — Wed, 04 Dec 2024 20:50:38 GMT

@hartwell Sorry, I did not read closely enough. This information which is selected does not get stored in a location that can be retrieved. However, if you are interested in the selected information, you could in tandem create an ODS DOCUMENT with the selected information and replay this. See the following example.

ods rtf file="c:\temp\temp1.rtf";

/* Print selected output and create an ODS Document with the selected output */

ods select all;
ods document name=temp;

proc freq data=sashelp.class;
run;

ods select none;

proc print data=sashelp.class;
run;

ods document close;
ods rtf close;

/* Display the selected output */

proc document name=test(update);
replay;
quit;

Re: sashelp for ods select all ?

hartwell — Wed, 04 Dec 2024 21:29:48 GMT

I managed to find a way to get the info I needed from ods show.

proc printto log="/dest/test.txt";
run;

ods show;

proc printto;
run;

data _null_;
    infile "/dest/test.txt";
    input ;
    lines=_infile_;
    if _n_ = 8 then do;
        call symputx('ODS_SHOW',_infile_);
    end;
run;

%let ODS_SHOW = %sysfunc(prxchange(s!Current OVERALL select list is: !!,1,&ODS_SHOW));

Re: sashelp for ods select all ?

Tom — Thu, 05 Dec 2024 02:15:06 GMT

@hartwell wrote:

Here's the table produced by printing sashelp.vdest, which I don't think is enough info for me to restore their defaults after I exclude everything.

It is enough for the code you showed since all you needed to know was the value of the DESTINATION variable to generate your two statements.

ods rtf exclude all;
ods rtf select all;

So assuming you want to first prevent output from going to the active destinations you could do something like:

data _null_;
  set sashelp.vdest;
  where dest ne 'OUTPUT';
  call execute(catx(' ','ods',destination,'exclude all;'));
run;

Then add a similar step at the point where you want to start sending output their way again.

I think you are getting confused and thought you would need to recreate the original ODS statement that defined the destination. You would only need to do that if had run this command:

ods rtf close;

And if your question meant that someone else had closed the RTF destination before your code ran then the only way to recreate it is to be like Big Jule in Guys and Dolls and "remember where they once was."