Exporting Formatted Output to Microsoft Excel using the Output Delivery System

Role

Data Manager, Report Writer, DI Developer, Operations Researcher, Statistical Analyst, Business Analyst and Market Researcher

Duration

2 hours

Description

The Output Delivery System (ODS) enables you to produce output in a variety of formats, such as: an HTML file; a traditional SAS Listing; a PostScript file; an RTF file (for use with Microsoft Word); an output data set.

During this live web class you will export formatted SAS output created using ODS HTML, ODS HTML3, ODS MSOFFICE2K and ODS TAGSET.EXCELXP to Microsoft® Excel.

To ensure the effectiveness of the training you will be invited to join a dedicated group on SAS Professionals where you can provide examples of how you are using Base SAS to export to Microsoft® Excel at work. These examples and any questions will be open to discussion during the class.

Prerequisites

Before attending this course, you should have attended the SAS Programming 1: Essentials course or have the equivalent knowledge and experience. Basic knowledge of the SAS Output Delivery System (ODS) and simple invocation techniques is helpful but not required.

SAS Modules Used

This course addresses Base SAS.

Course Topics

Introduction

• Introduction to course topics and concepts

Using ODS to Create HTML Files for Microsoft Excel

• Creating HTML 3.2 and HTML 4.0 files
• Creating Microsoft HTML files with the MSOFFICE2K tagset
• Using CSS to change style and number formats (self-study)

Using ODS to Create XML Files for Microsoft Excel

• What is spreadsheet markup language?
• Using ODS TAGSETS.EXCELXP to create SpreadsheetML files
• ExcelXP advanced topics

Objectives

After attending this live web session you will be able to export unformatted SAS output created using ODS destinations to Microsoft® Excel.

This outline is provisional and subject to change.