3 arrows

Winter-Ready Savings Up To $500 Off Training 

closeClose

Exporting SAS(R) Data Sets and Creating ODS Files for Microsoft Excel

This course presents techniques for exporting SAS data sets or reports from SAS to Excel. Skills Gained export SAS data sets using the EXPORT procedure and the LIBNAME statementexport SAS reports using ODS destinations such as EXCEL, EXCELXP, MSOFFICE2K, TABLEEDITOR, and CSV. Who Can Benefit SAS...

$725 USD GSA  $630.68
Course Code XLS
Duration 1 day
Available Formats Classroom
5107 Reviews star_rate star_rate star_rate star_rate star_half
Course Image

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

Skills Gained

  • 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 Can Benefit

  • 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 Details

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
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward