excel or not excel

[mauri0623]

ods excel file="/home/sasuser/bin/MCDdata.xlsx"
options(sheet_name="MCD Data"
sheet_interval='none'
embedded_titles='yes');

title "Report for Johns Hopkins Medical Services Corporation";
proc print data = t_mcd noobs;
run;
ods excel close;

I want some kind of condition to decide to crate a .xlsx output or not create one. Please help

[Cynthia_sas]

Hi:
Unless you're doing some kind of macro program processing, you'd have to do this type of decision or conditional processing before you get to this point. If you mean you want to test t_mcd to see whether it has observations or is empty, then there are previous Forum postings on how to do this.

Cynthia

[mauri0623]

The code is in a macro already. I just want to say create a excel or don't. Condition "YES" or "NO".

[andreas_lds · Accepted solution]

And the condition is provided by what? A parameter of the macro? If so, then just do something like:

%if &condition. = YES %then %do;
  insert your exporting code here
%end;