In reply to Nikhil Wagh.

Hi Nikhil, thanks for your comment and a great question. Yes, it is possible to print multiple tables on the same sheet with different titles and and footnotes. You just use sheet_interval='none' as you suggested, plus embedded_titles='on' and embedded_footnotes='on' options; see this example:

ods excel file='F:\Files\two_tables_sheet.xlsx'
options (sheet_interval='none' embedded_titles='on' embedded_footnotes='on');

title 'SASHELP.CLASS table';
footnote 'This is footnote 1';
proc print data=SASHELP.CLASS (obs=9) noobs;
run;

title 'SASHELP.CARS table';
footnote 'This is footnote 2';
proc print data=SASHELP.CARS (obs=10) noobs;
run;

ods excel close;

Also see my another blog post that does the opposite; it splits one tables in parts and places each part into different tabs (sheets) - Splitting a data table into multiple sheets of an Excel workbook.