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.

Who should attend

Formats available	Duration
Classroom:	1.0 day
Live Web Classroom:	2 x 3.5 hour sessions	System Requirements

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.

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