William E. Benjamin
Owner, Owl Computer Consultancy
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.
Exchanging Data From SAS to Excel: The ODS Excel Destination
By William E. Benjamin, Jr.
Anticipated publication date: Second quarter 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 careers. 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 available with the ODS Excel destination, with numerous examples including syntax and graphic output.
With this book, programmers 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 their 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 graphs to Excel a breeze, enhancing any presentation!