Exchanging Data From SAS to Excel

Chapter 2: ODS Tagset versus Destination

View of Microsoft Excel Changes from the Outside

Data Sources Used as Examples

The EXCELXP Tagset

The ODS EXCEL Destination

Features of the ODS EXCEL Destination

Simple Syntax

ID=

Actions

Optional Arguments (Options)

Suboptions of the OPTIONS Statement

General Chapter Descriptions

View of Microsoft Excel Changes from the Outside

During the decade between 2006 and 2015, there have been many changes in the way SAS interfaced with Microsoft Excel. The changes began with the Microsoft release of Office 2007. Because this book deals mainly with Excel, I will refer to that product specifically. For many years the format of the Microsoft Excel files had remained the same. Opening a small Excel file with the Notepad ...