Creating Excel Output

To view output in Excel, you can specify that your original data set be formatted for Excel. Use the ODS TAGSETS.EXCELXP statement to open the Prdsale data set in Excel.

ods tagsets.excelxp file='your-file-path/Prdsale.xls';
title "PROC PRINT Output";

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