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 5: Options That Affect the Workbook

ODS Excel Destination Actions

The FILE= Option

The ID= Option

The BLANK_SHEET= Option

The CONTENTS= Option

The INDEX= Option

The MSG_LEVEL= Option

The TAB_COLOR= Option

The ZOOM= Option

Conclusion

Introduction

This chapter will discuss the ODS EXCEL ID= option and some suboptions that affect output at the level of the whole workbook. In Chapter 2, the SASHELP.SHOES data was filtered with the WHERE clause to only include data from the “ASIA” region. This was done to enable display of the data on one screen image. Unless otherwise noted, all of the examples in this and the following chapters will be using the following data set called “ASIA_ONLY” that was shown in Chapter 2.

Options and suboptions discussed ...

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