topic only 5 sheets? in New SAS User

only 5 sheets?

walterwang — Wed, 05 Dec 2018 03:22:42 GMT

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 — Wed, 05 Dec 2018 03:25:15 GMT

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

run;

Reeza — Wed, 05 Dec 2018 03:28:08 GMT

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

walterwang — Wed, 05 Dec 2018 03:29:38 GMT

yes it works.