Hi, I was trying to find an example where sheet_interval='page' would work but couldn't. The following example does not create a new tab every 15 or so observations. data class;
set sashelp.class;
do x=1 to 10;
output;
end;
run;
options pagesize=15;
ods excel file="&xxdemo./reporting/test.xlsx";
ods excel options(sheet_interval='page');
*proc print data=class noobs;
run;
proc report data=class;
columns sex;
define sex / display;
run; ods excel close; I also could not find a difference in result, except the tab name, between a sheet_interval='table' and a sheet_interval='bygroup' with ods excel, given that by statement create one table per by value. Do you have any example where both differ? Regards, Véronique
... View more