topic Re: Suppress output in sas while creating excel-sheet in ODS and Base Reporting

Suppress output in sas while creating excel-sheet

dstuder — Thu, 14 May 2020 08:30:10 GMT

Hi everyone!

I have to print out a huge cross table. Unfortunately SAS doesn't respond any more when I try to execute it. So, how can I suppress the output in SAS and create the excel sheet only?

ODS EXCEL FILE="myfile.xlsx" options(frozen_headers="6" embedded_titles="yes"); 
TITLE "My Title"; 
  ODS EXCEL options(sheet_name="Sheet name");

  proc tabulate; 
    class ... ; 
    table ... ; 
    format ... ; 
  run;

ODS EXCEL CLOSE;

Re: Suppress output in sas while creating excel-sheet

ed_sas_member — Thu, 14 May 2020 09:55:09 GMT

Hi @dstuder

You can close all ODS destination before the ODS excel statement:

ods _all_ close;

ODS EXCEL FILE="/home/u41058973/sasuser.v94/myfile2.xlsx" options(frozen_headers="6" embedded_titles="yes"); 
TITLE "My Title"; 
  ODS EXCEL options(sheet_name="Sheet name");

...

ODS EXCEL CLOSE;

Best,