Exchanging Data From SAS® to Excel · the ODS Excel Destination by Benjamin-Jr., William E. -- Read -- Imperial Library of Trantor

Index

Cover Title Page Copyright Page Contents About This Book About The Author Chapter 1: Introduction

Introduction

What is the SAS ODS EXCEL Destination? Why I like Backward Compatibility Why the ODS Excel Destination Is an Output-Only Feature of SAS Layout of This Book General Chapter Layout

Chapter 2: ODS Tagset versus Destination

View of Microsoft Excel Changes from the Outside Data Sources Used as Examples The EXCELXP Tagset The ODS EXCEL Destination Features of the ODS EXCEL Destination

Simple Syntax ID= Actions Optional Arguments (Options) Suboptions of the OPTIONS Statement

General Chapter Descriptions

Chapter 3: ODS Excel Destination Actions

Introduction 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

ODS EXCLUDE Statement ODS SELECT Statement ODS SHOW Statement Conclusion

Chapter 4: Setting Excel Document Property Values

Introduction Options to Modify the Excel Document Properties Sheet Default Excel Property Sheets Modify Excel Property Sheets with the ODS EXCEL Destination Excel Property Sheet Date/Time Fields without the SASDATE Option Excel Property Sheet Date/Time Fields with the SASDATE Option Conclusion

Chapter 5: Options That Affect the Workbook

Introduction 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

Chapter 6: Arguments that Affect Output Features

Introduction Arguments That Affect Worksheet-Level Output Features Using the ODS Document Object Model (DOM) with the ODS EXCEL Statement The ODS ANCHOR= Option The BOX_SIZING= Option Using Cascading Style Sheets with the CSSSTYLE= Option

Simple Color Changes Using a CSS File Sending Graphs to Excel and Modifying the Output Using a CSS File Adding a Background Image Using CSS

The IMAGE_DPI= Option The STYLE= Option The ODS EXCEL STYLE= Option

The ODS EXCEL STYLE= Overrides

The TEXT= Option Conclusion

Chapter 7: Options That Affect Worksheet Features

Introduction ODS Excel Destination Suboptions The EMBEDDED_FOOTNOTES= Suboption

Embedded Footnotes Turned Off Embedded Footnotes Turned On Embedded Footnotes=‘ON’ with Multiple Outputs on a Worksheet

The EMBED_FOOTNOTES_ONCE= Suboption

The EMBEDDED_TITLES= Suboption

EMBEDDED_TITLES=‘OFF’ EMBEDDED_TITLES=‘ON’

The EMBED_TITLES_ONCE= Suboption

The FITTOPAGE= Suboption The GRIDLINES= Suboption The PAGES_FITHEIGHT= Suboption The PAGES_FITWIDTH= Suboption The SHEET_INTERVAL= Suboption

SHEET_INTERVAL=‘BYGROUP’ Example SHEET_INTERVAL=‘PAGE’ Example SHEET_INTERVAL=‘PROC’ Example SHEET_INTERVAL=‘NONE’ Example SHEET_INTERVAL=‘TABLE’ Example

The SHEET_LABEL= Suboption The SHEET_NAME= Suboption The SUPPRESS_BYLINES= Suboption Conclusion

Chapter 8: Options That Affect Print Features

Introduction ODS Excel Destination Actions The BLACKANDWHITE= Option The CENTER_HORIZONTAL= Option The CENTER_VERTICAL= Option The DRAFTQUALITY= Option The ORIENTATION= Option The PAGE_ORDER_ACROSS= Option The PRINT_AREA= Option The PRINT_FOOTER= Option The PRINT_FOOTER_MARGIN= Option The PRINT_HEADER= Option The PRINT_HEADER_MARGIN= Option The ROWBREAKS_COUNT= Option The ROWBREAKS_INTERVAL= Option The ROWCOLHEADINGS= Option The SCALE= Option

When Using Excel 2013, If You Enter:

The TITLE_FOOTNOTE_NOBREAK= Option The TITLE_FOOTNOTE_WIDTH= Option Conclusion

Chapter 9: Column, Row, and Cell Features

Introduction 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

Index