Amadeus cookies policy - you'll see this message only once.

Amadeus use cookies on this website. They help us to know a little bit about you and how you use our website, which improves the browsing experience and marketing - both for you and for others. They are stored locally on your computer or mobile device. To accept cookies, continue browsing as normal. Or, go to the privacy policy for more information.

Accept and close

On-Demand: Using SAS to Create Microsoft Excel Reports

This on-demand webinar shows you how to output reports from SAS to Excel by making use of techniques such as the Excel Libname, Proc Export and the ODS TAGSETS.EXCELXP destination. You will also learn how to control many structural aspects of Excel workbooks, as well as being able to manipulate the content and presentation of data within Excel.

On-Demand course price:
£80.00 plus VAT per delegate

Course outline Purchase a License

Audience

This on-demand webinar is appropriate for SAS programmers who wish to create professional looking Microsoft Excel reports from SAS.



Prerequisites

You should be familiar with the fundamental concepts of SAS programming and in particular the Output Delivery System (ODS).

Topics

Module 1. Principles and Technology

  • Introduction
  • Technology Options
  • Advantages and Disadvantages

Module 2. Syntax and Examples of the Main Techniques

  • Using the ODS TAGSETS.EXCELXP Destination
  • Using the Excel Libname
  • Using Proc Export

Module 3. Controlling the Structure of Excel Workbooks using ODS TAGSETS.EXCELXP

  • Outputting Two Dimensional Reports
  • Creating Three Dimensional and Multi-Page Reports
  • Controlling the Width of Columns
  • Freezing Header Rows
  • Specifying Autofilters
  • Printing Options

Module 4. Manipulating the Content and Presentation of Data

  • Embedding Excel Formulae and Formats
  • Using Styles to Control Presentation
  • Referencing Other Spreadsheets