Base SAS to Microsoft Excel: Counting the Ways

Duration: 1 half-day session CEU: 0.3

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.

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 I: 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 the following software product(s): Base SAS.

Course Materials

Students attend Live Web classes using a Web browser and a telephone and interact with their instructor and fellow classmates in real time. Each student receives an e-mail with instructions on how to join the class three business days before the class begins. The instructions e-mail includes a link to download the course materials, including the exercise files. Students need to download and print the course materials prior to class.

System Requirements

For Live Web, you must

review and follow the general system requirements.
complete the course exercises through our virtual lab. The virtual lab allows you to access the software used in class over the Internet, so that you do not need this software on your local machine.
run this test to connect to a virtual lab session. If firewall problems prevent you from connecting to the virtual lab, then you will need the following software installed and configured in your environment to participate in the course exercises:
- Base SAS 9
- Microsoft Excel 2002 or higher.

U.S. Schedule

19DEC2008 Live Web,

Check for additional and updated schedule information online at support.sas.com/courses/lwsasxl.html.