Exchanging Data From SAS to Excel: The ODS Excel Destination

By William E. Benjamin Jr.

Book Overview

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(R) to Excel: The ODS Excel Destination will make sending your output and graphics to Excel a breeze, enhancing any presentation

• Format: Paperback
• Language: English
• ISBN: 162960609X
• ISBN13: 9781629606095
• Release Date: August 2017
• Publisher: SAS Institute
• Length: 206 Pages
• Weight: 0.85 lbs.
• Dimensions: 0.4" x 7.5" x 9.3"