Suppress output in sas while creating excel-sheet

[dstuder]

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;

[ed_sas_member · Accepted solution]

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,