There is a new version of this course. Please see Working with SAS® and Microsoft Excel.

This course presents techniques for exporting SAS data sets or reports from SAS to Excel.

• export SAS data sets using the EXPORT procedure and the LIBNAME statement
• export SAS reports using ODS destinations such as EXCEL, EXCELXP, MSOFFICE2K, TABLEEDITOR, and CSV.

Zielgruppe / Who should attend

Verfügbare Schulungsformen / Formats available	Dauer (kann variieren, Details s. Terminliste)
Präsenzkurs:	1 Tag

Before attending this course, you should have at least six months of experience writing SAS programs or have completed the SAS® Programmierung 1: Grundlagen 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.

In diesem Kurs wird mit folgenden Software Modulen gearbeitet / This course addresses Base SAS Software

This course also addresses SAS/ACCESS Interface to PC Files software.

• course logistics
• SAS to Excel
• understanding your environment

• introduction
• using the EXPORT procedure
• using the LIBNAME statement

• introduction
• adding sub-options
• specifying Excel formats
• creating Excel charts

• introduction to additional destinations
• introduction to the EXCELXP destination
• adding sub-options
• specifying Excel formats

• using the MSOFFICE2K destinations
• using the TABLEEDITOR destination
• using the CSV destinations