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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.