only 5 sheets?

[walterwang]

I use ods excel and proc report to save the results to excel file.

part of the codes look like:

Macro:

ods excel %IF &state=1 %THEN

file="\walter\3_10\&outexcel..xlsx";

cssstyle="style.css"

options (embedded_titles = 'yes' embedded_footnotes='yes' title_footnote_nobreak='off'

sheet_interval="table" sheet_name="T3.10.09&statename.");

footnote;

　

proc report data=datasheet1 split='@' style(header)=higherlevel{borderwidth=0.3};

I run this macro 6 times. But only save 5 sheets.

what happened?

[Astounding · Accepted solution]

Have you tried adding this statement at the end of your PROC REPORT:

run;

[walterwang]

yes it works.

[Reeza]

Where's the ODS CLOSE statement? Or the RUN?
Do you have more %IF conditions? Are they all being evaluated correctly?