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 9: Column, Row, and Cell Features

ODS Excel Destination Column, Row, and Cell Options

The ABSOLUTE_COLUMN_WIDTH= Suboption

The AUTOFILTER= Suboption

The COLUMN_REPEAT= Suboption

The FROZEN_HEADERS= Suboption

The HIDDEN_COLUMNS= Suboption

The ABSOLUTE_ROW_HEIGHT= Suboption

The FROZEN_ROWHEADERS= Suboption

The HIDDEN_ROWS= Suboption

The ROW_HEIGHTS= Suboption

The ROW_REPEAT= Suboption

The FORMULAS= Suboption

The START_AT= Suboption

Conclusion

Introduction

In this chapter, we will discuss the ODS EXCEL options that affect Row, Column, and Cell level data that is output into an Excel worksheet. In this chapter, the SASHELP.SHOES data set will be filtered with a WHERE clause to include only data from the “ASIA” region along with part of the ...

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