how to create excel file with one tab

[juliajulia]

hello, 

I use the sas ods to export two tables but the two table are exported to two different tabs. how can i export to excel file with only one tab that include both data result: my original code like this:

ods excel file = "D:\RSR\output\test.xlsx";
proc report data=table01aage;
title j=l "Table 1a. ";

column agegroup _016No _016colper _017No _017colper
_018No _018colper
_019No _019colper
_020No _020Colper
_021No _021Col_Per;
define agegroup / display 'Age group (yr)' style={just=left};
define _016No / display 'No' ;
define _016colper / display "%" format=comma12.2;
define _017No / display 'No';
define _017colper / display "%" format=comma12.2;
define _018No / display 'No';
define _018colper / display "%" format=comma12.2;
define _019No / display 'No';
define _019colper / display "%" format=comma12.2;
define _020No / display 'No';
define _020colper / display "%" format=comma12.2;
define _021No / display 'No';
define _021col_per / display "%" format=comma12.2;
run;

proc report data=table01agender;

column F1 No_ Col_Percent No_1 Col_Percent1 No_2 Col_Percent2 No_3 Col_Percent3 No_4 Col_Percent4 No_5 Col_Percent5 ;
define F1 / display 'Gender' style={just=left};
define No_ / display 'No' ;
define Col_Percent / display "%" format=comma12.2;
define No_1 / display 'No';
define Col_Percent1 / display "%" format=comma12.2;
define No_2 / display 'No';
define Col_Percent2 / display "%" format=comma12.2;
define No_3 / display 'No';
define Col_Percent3 / display "%" format=comma12.2;
define No_4 / display 'No';
define Col_Percent4 / display "%" format=comma12.2;
define No_5 / display 'No';
define Col_Percent5 / display "%" format=comma12.2;
run;

ods excel close;

[PaigeMiller · Accepted solution]

ods excel file = "D:\RSR\output\test.xlsx" options(sheet_interval='NONE');

[juliajulia]

This works well. Thank you!