Hello Chris,

Great post and great blog. I learned a couple of nice things from this post. One thing I am having trouble with is if while in "ods-excel-mode" I create a new sheet, and then try to put text on the new sheet using ods text, the text will actually print to the bottom of the previous sheet. i.e. it seems like the new sheet isn't being created until I use a proc tabulate:

sample code:

%macro newsheet; ods excel options(sheet_interval='output');
ods exclude all; data _null_; declare odsout obj(); run;
ods select all;
%mend newsheet;

/* end of macros */

ods excel file='/sasdata/path/path/my spreadsheet.xlsx'
options (sheet_interval='none' sheet_name='first sheet);

proc tabulate data= ......... /*imagine proc tabulate code here*/
run;

%newsheet; /* macro for instancing a new sheet*/

ods excel options (sheet_interval='output' sheet_name='second sheet');

ods text="I want this to print at the top of the second sheet but it prints at the bottom of the second sheet";

proc tabulate data= ......... /*imagine proc tabulate code here*/
run;