Book description
Microsoft Excel remains the leading spreadsheet application on the market; nearly every SAS user will need to move their data and reports into Excel workbooks at some point during their career. Exchanging Data From SAS(R) to Excel: The ODS Excel Destination shows SAS users how to create Excel workbooks that are presentation ready, eliminating manual changes to the workbooks after creation. While the original book Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently touched upon many topics involved in moving data between SAS and Excel, this companion book delves into the options that are available with the ODS Excel destination. This book also has numerous examples that include syntax and graphical output. With this book, you can learn how to: Create native Excel files Insert graphs and images into Excel files Place multiple tables on multiple tabs within the file Customize spreadsheets with workbook-level options, print features, column features, row features, and cell-level features Exchanging Data from SAS® to Excel: The ODS Excel Destination will make sending your output and graphics to Excel a breeze, enhancing any presentation!Table of contents
- About This Book
- About The Author
- Chapter 1: Introduction
- Introduction
- 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
- General Chapter Descriptions
- Chapter 3: ODS Excel Destination Actions
- Introduction
- ODS Excel Destination Actions
- A Simple ODS Excel Example and the CLOSE Action
- 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
- The IMAGE_DPI= Option
- The STYLE= Option
- The ODS EXCEL STYLE= Option
- The TEXT= Option
- Conclusion
- Chapter 7: Options That Affect Worksheet Features
- Introduction
- ODS Excel Destination Suboptions
- The EMBEDDED_FOOTNOTES= Suboption
- The EMBED_FOOTNOTES_ONCE= Suboption
- The EMBEDDED_TITLES= Suboption
- The EMBED_TITLES_ONCE= Suboption
- The FITTOPAGE= Suboption
- The GRIDLINES= Suboption
- The PAGES_FITHEIGHT= Suboption
- The PAGES_FITWIDTH= Suboption
- The SHEET_INTERVAL= Suboption
- 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
- 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
Product information
- Title: Exchanging Data From SAS to Excel
- Author(s):
- Release date: September 2017
- Publisher(s): SAS Institute
- ISBN: 9781635261400
You might also like
book
Clinical Graphs Using SAS
SAS users in the Health and Life Sciences industry need to create complex graphs to analyze …
book
Pivot Table Data Crunching for Microsoft® Office Excel® 2007
This book consolidates all the best functionality of pivot tables into one guide that provides you …
book
Exchanging Data between SAS and Microsoft Excel
Master simple-to-complex techniques for transporting and managing data between SAS and Excel William Benjamin's Exchanging Data …
book
Microsoft® Excel 2010 On Demand
What you need, when you need it! Need answers quickly? Microsoft Excel 2010 on Demand provides …