O'Reilly logo

Exchanging Data From SAS to Excel by William E. Benjamin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required