Exchanging Data From SAS to Excel: The ODS Excel Destination

  • 1h 51m
  • William E. Benjamin Jr.
  • SAS Institute
  • 2017

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

About the Author

William E. Benjamin, Jr., owns Owl Computer Consultancy, LLC, and works as a consultant, trainer, and author. William has been a SAS user for over 30 years and a consultant since 2007. He received an MBA from Western International University and a BS in computer science from Arizona State University. He has written and presented papers for SAS Global Forum, as well as many regional and local SAS users groups.

In this Book

  • Introduction
  • ODS Tagset versus Destination
  • ODS Excel Destination Actions
  • Setting Excel Document Property Values
  • Options That Affect the Workbook
  • Arguments that Affect Output Features
  • Options That Affect Worksheet Features
  • Options That Affect Print Features
  • Column, Row, and Cell Features


Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Rating 4.6 of 416 users Rating 4.6 of 416 users (416)