All YOUR Questions Answered at
[sas.answers @ Holland Numerics]
Sponsored Links for SAS Software Users
Careers, Jobs and Contracts, Services and Products

Frequently Asked Questions about SAS Software

The following Question & Answer List is based on SAS questions received by the author.

Reading and Writing Spreadsheets

Question Answer
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;
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.

     Back to Main FAQ Menu
Number of visitors = Counter (since 15th May 2000)

Email: Phil Holland <>

Web Design by Holland Numerics

Valid HTML 4.01!