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

Learn how to

• 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 SAS programmers Formats available Duration
: 2 half day sessions

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

Introduction

• course logistics
• SAS to Excel
• understanding your environment

Exporting SAS(R) Data Sets

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

Using the ODS EXCEL Destination

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

Using the ODS EXCELXP Destination

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

Using Additional ODS Destinations

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

XLS.