Collaboration

Creating Highly Customized, Binary Excel Workbooks Using XML

Free registration required

Executive Summary

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.

  • Format: PDF
  • Size: 372.7 KB