I want to exclude the PROC REPORT (very long) from the Results window without affecting the export into Excel (Enterprise Guide 7.15, Office 365, Window 10). After trying numerous methods, I'm stuck and thought perhaps I'm missing something obvious. Here is the general code: ODS NORESULTS;
ODS EXCLUDE ALL;
ODS EXCEL FILE="&OUT.TEST.xlsx";
ODS EXCEL OPTIONS(AUTOFILTER="1-8" SHEET_NAME="ABC");
PROC REPORT DATA=OUT.TEST NOWD HEADSKIP SPANROWS;
COLUMN OBS T1 T2;
DEFINE OBS / DISPLAY "Obs";
RUN;
ODS EXCEL CLOSE;
ODS EXCLUDE NONE;
ODS RESULTS; I have tried all these ODS options, with the following results: ODS EXCLUDE ALL; --> Indeed suppresses output to Results, but it also excludes data from the Excel sheets (blank) ODS _ALL_ CLOSE; --> Produces a warning: "No output destinations active" ODS NORESULTS; --> No effect I've tried different combinations of the above codes and also different placement within the code, with no success. The NOPRINT option within PROC REPORT is also inapplicable since it also excludes data from the Excel export. The goal is to wrap this report within an option to localize the output suppression since it is surrounded by other code in the program where I do want the output. Any tips would be appreciated.
... View more