topic excel or not excel in SAS Programming

excel or not excel

mauri0623 — Wed, 27 Mar 2019 20:40:53 GMT

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

Re: excel or not excel

Cynthia_sas — Wed, 27 Mar 2019 20:51:09 GMT

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

Re: excel or not excel

mauri0623 — Wed, 27 Mar 2019 20:53:31 GMT

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

Re: excel or not excel

andreas_lds — Wed, 27 Mar 2019 21:00:24 GMT

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;