Webinar: Using SAS to Create Microsoft Excel Reports
- Selected option:
- e-Learning
- Cost per delegate:
- £80.00
- Duration:
- 2 Hours
Audience
This webinar is appropriate for SAS programmers who wish to create professional looking Microsoft Excel reports from SAS.Prerequisites
Attendees should be familiar with the fundamental concepts of SAS programming and in particular the Output Delivery System (ODS).Objectives
After attending this webinar, attendees will be able 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. Attendees 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.
Topics
1. Principles and Technology
- Introduction
- Technology Options
- Advantages and Disadvantages
2. Syntax and Examples of the Main Techniques
- Sorting
- Concatenating
- Merging
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
4. Manipulating the Content and Presentation of Data
- Embedding Excel Formulae and Formats
- Conditional Formatting
- Using Styles to Control Presentation
- Referencing Other Spreadsheets
