As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Moving SAS Data to Excel

From sasCommunity
Jump to: navigation, search

Paper 272-2009

You Use SAS®, Your Boss Uses Excel. Guess Where Your Results Are Going to Appear! Using ODS to Create Your Results in Excel

William E Benjamin Jr, Owl Computer Consultancy, LLC, Phoenix, Arizona

Abstract

This paper digs into the use of ODS on the SAS® side to prepare Excel spreadsheets directly. SAS code and macros will be demonstrated to create multi-page Excel spreadsheets, giving the programmer the ability to build tools to exploit data and display information for the end user. As a result, the SAS programmer will be able to create spreadsheets for distribution, automate the standardization of reports and the building of powerful spreadsheet applications with access to information built by offline SAS processes that the end user can refresh.

Online resources