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 3: ODS Excel Destination Actions

ODS Excel Destination Actions

A Simple ODS Excel Example and the CLOSE Action

A Simple ODS Excel Output Step

Finding ODS Object Names Using the ODS TRACE Statement

Using the ODS TRACE Statement to Show PROC UNIVARIATE Objects

ODS EXCLUDE Statement

ODS SELECT Statement

ODS SHOW Statement

Conclusion

Introduction

The ODS Excel destination “Actions” are ODS commands dealing with the structure and content of the output Excel workbook. There are only a few commands classified as “Actions” for the ODS EXCEL statement, and they are “Close”, “Exclude”, “Select”, and “Show”. In this chapter I explain these actions and provide examples. First, after describing the actions, I want to demonstrate the simplest implementation ...

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