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

Get Exchanging Data From SAS to Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.