Customized Excel Output

The STYLE= option with the Science style specified in the ODS TAGSETS.EXCELXP statement tells ODS to use the Science style for all Excel output. Specifying the OPTIONS suboption (DOC="HELP") prints Help for the ODS TAGSETS.EXCELXP statement suboptions to the SAS log file. All tagsets have instream help. For more information about the DOC= suboption, see the ODS Tagset statement in Dictionary of ODS Language Statements in SAS Output Delivery System: User’s Guide.

ods tagsets.excelxp file='your-file-path/Prdsale.xls' style=Science options
(doc="help");
title "PROC PRINT Output";

proc print data=sashelp.prdsale;
run;
ods tagsets.excelxp close;