The SAS Output Delivery System and reporting techniques

ODS EXCEL Title (using ODS text in the next Excel sheet)

Reply
Occasional Contributor
Posts: 8

ODS EXCEL Title (using ODS text in the next Excel sheet)

Hi there,

 

I have a problem where the title using ODS text is not appearing in the second worksheet but instead appearing at the bottom of Sheet 1.

 

My code is as follows:

 

**Start of code;

 

ods Excel file ="&PATH2./Output/OptoutReport.xlsx" style=HTMLblue options(sheet_interval="none" sheet_name="Sheet1");

 

ods escapechar='~';

 

ods text="~S={font_size=14pt font_weight=bold}~Sheet 1";

 

proc tabulate data=pct;

.

.

.

run;

 

**Dummy table;

***********;

 

ods excel options(sheet_interval="table");

ods exclude all;

data _null_;

file print;

put _all_;

run;

ods select all;

***********;

 

ods Excel options(sheet_interval="none" sheet_name="Sheet2");

 

ods escapechar='~';

 

ods text="~S={font_size=14pt font_weight=bold}~Sheet 2";

 

proc tabulate data=pct;

.

.

.

run;

 

ods Excel close;

 

 

**end of code;

 

Oddly enough, when I placed this code --> ods text="~S={font_size=14pt font_weight=bold}~Sheet 2"; just before this line of code--> ods Excel close; the text would then appear after the table generated using proc tabulate data.

 

Appreciate if anyone can give a pointer to solve this issue.

 

Thank you.

 

 

Super User
Posts: 17,826

Re: ODS EXCEL Title (using ODS text in the next Excel sheet)

You should contact tech support. But that also assumes you're using SAS 9.4 M3+. Anything before that was pre-production. 

Ask a Question
Discussion stats
  • 1 reply
  • 161 views
  • 0 likes
  • 2 in conversation