The following Question & Answer List is based on SAS questions received by the author.
Reading and Writing Spreadsheets
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.