support & services / Education

Base SAS to Microsoft Excel: Counting the Ways - SASXL

This course presents the most effective techniques for exporting SAS tables or procedure output from Base SAS into Excel spreadsheets. The course uses examples to show the basics of the SAS Excel LIBNAME engine, the EXPORT procedure, and ODS to create CSV, HTML, and XML files that can be opened by Excel.

Download course description as PDF   Register now  

Duration

½ day - Live Web Classroom

Learn how to

  • use the EXPORT procedure to create Microsoft Excel files from SAS tables
  • use the LIBNAME engine to create Microsoft Excel files from SAS tables
  • use ODS to create comma-separated values files and HTML files for Microsoft Excel
  • use ODS to create Spreadsheet Markup Language files for Microsoft Excel.

Who should attend?

SAS programmers

Prerequisites

Before attending this course, you should have at least six months of experience writing SAS programs or have completed the SAS Programming 1: Essentials course and used SAS for at least one month. Basic knowledge of the Output Delivery System (ODS) and simple ODS invocation techniques is helpful, but not required.

Course Contents:

Introduction

  • introduction to course topics and concepts

Creating Microsoft Excel Files from SAS Tables

  • using the EXPORT procedure
  • using the external file interface (self-study)
  • using the Excel LIBNAME Engine

Using ODS to Create Comma-Separated Value Files

  • using ODS CSV and other CSV tagsets

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

Other Methods of Creating Files for Microsoft Excel (Self-Study)

  • additional file creation methods

Software Addressed

This course addresses Base SAS software. This course is appropriate for students who are using SAS 9 software.

Book Your Place Today