| How can I write to an Excel spreadsheet, when we don't license SAS/ACCESS for PC File Formats?
|
This code is probably better placed in the ODS section, but is an easy way to create a formatted Excel spreadsheet (in c:\temp\report.xls) without any requirement for SAS/ACCESS, e.g.:
ODS HTML FILE="c:\temp\report.xls";
PROC PRINT DATA=sashelp.class;
RUN;
ODS HTML CLOSE;
This is actually a feature of Excel, as the file created is still an HTML web page, but the suffix causes Excel to be opened when you double-click on the filename, which automatically converts the contents to a spreadsheet.
|
