Collaboration

Creating Highly Customized, Binary Excel Workbooks Using XML

Date Added: Mar 2010
Format: PDF

This paper will illustrate a new method for generating binary Excel workbooks using SAS data. It will illustrate how one can go beyond ODS, proc export, Access engines, etc. to make highly-customized Excel workbooks using SAS data. In almost every SAS site, there is a need to interface with Excel. A large portion of that need is to export SAS datasets to Excel. However, a simple proc export is rarely what is needed since the data needs to be not only exported to Excel but to also be formatted in Excel.