• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
0- - 0
Job Meter = High

On-Demand: Using SAS to Create Microsoft Excel Reports

30 Hours
Online Instructor-led Training
USD 1399 (USD 2800)
Save 50% Offer ends on 31-Dec-2023
On-Demand: Using SAS to Create Microsoft Excel Reports course and certification
318 Learners

About this Course
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.

Target Audience

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


On-Demand: Using SAS to Create Microsoft Excel Reports

Course Details & Curriculum

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

Didn't find what you are looking for?  Contact Us