topic Re: PROC PRINT to EXCEL in SAS Programming

PROC PRINT to EXCEL

Palucci — Wed, 03 Nov 2021 07:45:25 GMT

Is it possible to save the result of proc print in excel format as export and not in html?

  
proc print data=diff n noobs sumlabel='Titak' grandtotal_label='Grand Total';
   sum Custmer Price Sold ;

PeterClemmensen — Wed, 03 Nov 2021 08:12:39 GMT

Yes. Use the ODS Excel Destination.

Plenty of examples online 🙂

PeterClemmensen — Wed, 03 Nov 2021 08:15:56 GMT

Something like

ods html close;
ods excel file = "S:\SASPC\PNC\class.xlsx";

proc print data = sashelp.class;
run;

ods excel close;
ods html;