Creating Output Files with ODS for Use by Excel - Exchanging Data Between SAS and Microsoft Excel - page 147

8.17 The New ODS Destination EXCEL for Writing Workbooks
The last topic I want to discuss in this chapter is a new entry into the ODS arena of data transfer to Excel.
ExcelXP is a tagset that has many features and can be changed by you. It is delivered as source code within
the SASHELP.Tmplmst tagset files. This can be modified or a new version can be downloaded at any time.
But, there is something new on the horizon. It is called the EXCEL ODS Destination. This will be a process
included within SAS ODS features that is not available for updating by users. It was first shipped with SAS
9.4 TS Level 1M1. The outputs of this ODS destination are native format Excel workbooks for the version
2007 format and later.
As with all things SAS sends out in an “Experimental” mode, this ODS destination is likely to change
before it is in a production mode. I will show you it exists, but will show no options because they may
change.
Figure 8.54: ODS EXCEL Destination Code to Produce an Excel Workbook.
ODS EXCEL FILE='c:\temp\Excel\shoes_native.xlsx';
PROC PRINT DATA=sashelp.shoes;
BY region;
RUN;
ODS EXCEL CLOSE;
Figure 8.55: Output Native Excel File from the Code in Figure 8.54.