Writing to excel from SAS, DDE vs ODS

Robert Ellsworth
Ellsworth Stewart Consulting Inc.


Abstract

This paper will demonstrate 4 methods for populating excel report. The paper will compare methods using DDE versus writing CSV and using excel macros versus SAS Add-in for Microsoft Office versus ODS. The pros and cons of each method will be highlighted.