ODS, ODSText, Titles

[PhilC]

Thanks, your expertise will be valuable.  I'm glad even if you are just reading along.

[xxformat_com]

Hi Phil,

Is the following issue similar to yours? The title statement is added after the proc print/before proc odstext. title statement, ods noproctitle... doesn't help.

If so, just add : sheet_interval='none'.

You then only have to add sheet_interval='now' to add a title later on on the worksheet.

ods excel file="&xxtest./reporting/test.xlsx"
          options(embedded_titles='yes' /*sheet_interval='none'*/);

title 'Example';

proc print data=sashelp.class;
run;

proc odstext;
    p 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
run;

ods excel close;

sheet_interval='none'

On the second page, you'll have to an empty line at the top of the worksheet (unless someone has a bette solution)

ods excel options(sheet_name='Sheet 2' sheet_interval='now');
	proc odstext; *breakpage=yes is implicite in this case;
	    p '';
	run;
*ods excel options(sheet_interval='none'); *implicit;