topic Re: ODS Excel won't work in ODS and Base Reporting

ODS Excel won't work

ply20051 — Thu, 16 Nov 2017 17:14:04 GMT

Hello,

I have a very weird issue with ODS Excel.

I put ODS Excel code section in front of proc sql and several proc freq. After running the program, I don't get any excel file, nothing coming out. Log doesn't say anything either.

Then I only marked and run the top part of "ODS Excel file=..." code again, it gave me the excel file.

What is this problem? How to fix it to generate the excel file right away after the running of the program.

Thank you so much for your help!

Here is my SAS codes:

ods excel file="c:\....xlsx" options (...);

proc sql;

create table a1 as

select *

from *;

quit;

ods excel options(sheet_interval="proc" sheet_name="Table 1";

proc freq data=a1;

title1 "Table 1"

table col1;

run;

ods excel options(sheet_interval="proc" sheet_name="Table 2";

proc freq data=a1;

title1 "Table 2"

table col2;

run;

ods excel close;

Re: ODS Excel won't work

Reeza — Thu, 16 Nov 2017 17:15:41 GMT

Post the log.

@ply20051 wrote:

Hello,

I have a very weird issue with ODS Excel.

I put ODS Excel code section in front of proc sql and several proc freq. After running the program, I don't get any excel file, nothing coming out. Log doesn't say anything either.

Then I only marked and run the top part of "ODS Excel file=..." code again, it gave me the excel file.

What is this problem? How to fix it to generate the excel file right away after the running of the program.

Thank you so much for your help!

Here is my SAS codes:

ods excel file="c:\....xlsx" options (...);

proc sql;

create table a1 as

select *

from *;

quit;

ods excel options(sheet_interval="proc" sheet_name="Table 1";

proc freq data=a1;

title1 "Table 1"

table col1;

run;

ods excel options(sheet_interval="proc" sheet_name="Table 2";

proc freq data=a1;

title1 "Table 2"

table col2;

run;

ods excel close;

Re: ODS Excel won't work

ply20051 — Thu, 16 Nov 2017 17:19:24 GMT

Sorry. This time it works. I run it twice and it works.

Re: ODS Excel won't work

Reeza — Thu, 16 Nov 2017 17:22:06 GMT

Your code has errors so I would still suggest checking your log and fixing any issues.

Re: ODS Excel won't work

ply20051 — Thu, 16 Nov 2017 17:23:27 GMT

Got you. I will look into my log to fix the errors.

May I know what errors you saw?

Thank you so much!

Re: ODS Excel won't work

ply20051 — Thu, 16 Nov 2017 17:24:31 GMT

I forgot typing in ")" in ods options.

Thank you!