https://communities.sas.com/t5/New-SAS-User/how-to-create-excel-file-with-one-tab/m-p/818210#M34609 <PRE><CODE class=" language-sas">ods excel file = "D:\RSR\output\test.xlsx" options(sheet_interval='NONE');</CODE></PRE> Tue, 14 Jun 2022 20:59:36 GMT PaigeMiller 2022-06-14T20:59:36Z https://communities.sas.com/t5/New-SAS-User/how-to-create-excel-file-with-one-tab/m-p/818208#M34608 <P>hello,&nbsp;</P> <P>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:</P> <P><BR />ods excel file = "D:\RSR\output\test.xlsx";<BR />proc report data=table01aage;<BR />title j=l "Table 1a. ";</P> <P>column agegroup _016No _016colper _017No _017colper <BR />_018No _018colper <BR />_019No _019colper<BR />_020No _020Colper<BR />_021No _021Col_Per;<BR />define agegroup / display 'Age group (yr)' style={just=left};<BR />define _016No / display 'No' ;<BR />define _016colper / display "%" format=comma12.2;<BR />define _017No / display 'No';<BR />define _017colper / display "%" format=comma12.2;<BR />define _018No / display 'No';<BR />define _018colper / display "%" format=comma12.2;<BR />define _019No / display 'No';<BR />define _019colper / display "%" format=comma12.2;<BR />define _020No / display 'No';<BR />define _020colper / display "%" format=comma12.2;<BR />define _021No / display 'No';<BR />define _021col_per / display "%" format=comma12.2;<BR />run;</P> <P>proc report data=table01agender;</P> <P>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 ;<BR />define F1 / display 'Gender' style={just=left};<BR />define No_ / display 'No' ;<BR />define Col_Percent / display "%" format=comma12.2;<BR />define No_1 / display 'No';<BR />define Col_Percent1 / display "%" format=comma12.2;<BR />define No_2 / display 'No';<BR />define Col_Percent2 / display "%" format=comma12.2;<BR />define No_3 / display 'No';<BR />define Col_Percent3 / display "%" format=comma12.2;<BR />define No_4 / display 'No';<BR />define Col_Percent4 / display "%" format=comma12.2;<BR />define No_5 / display 'No';<BR />define Col_Percent5 / display "%" format=comma12.2;<BR />run;</P> <P>ods excel close;</P> Tue, 14 Jun 2022 20:55:53 GMT https://communities.sas.com/t5/New-SAS-User/how-to-create-excel-file-with-one-tab/m-p/818208#M34608 juliajulia 2022-06-14T20:55:53Z https://communities.sas.com/t5/New-SAS-User/how-to-create-excel-file-with-one-tab/m-p/818210#M34609 <PRE><CODE class=" language-sas">ods excel file = "D:\RSR\output\test.xlsx" options(sheet_interval='NONE');</CODE></PRE> Tue, 14 Jun 2022 20:59:36 GMT https://communities.sas.com/t5/New-SAS-User/how-to-create-excel-file-with-one-tab/m-p/818210#M34609 PaigeMiller 2022-06-14T20:59:36Z https://communities.sas.com/t5/New-SAS-User/how-to-create-excel-file-with-one-tab/m-p/818230#M34612 This works well. Thank you! Tue, 14 Jun 2022 23:24:38 GMT https://communities.sas.com/t5/New-SAS-User/how-to-create-excel-file-with-one-tab/m-p/818230#M34612 juliajulia 2022-06-14T23:24:38Z