Exporting Unformatted Output to Microsoft Excel using SAS/ACCESS Software

Role

Data Manager, Report Writer, DI Developer, Operations Researcher, Statistical Analyst, Business Analyst and Market Researcher

Duration

2 hours

Description

Outputting data from SAS into Microsoft® Excel is still a task commonly performed by many SAS users on a day-to-day basis. During this live web class you will export unformatted SAS output created using SAS/ACCESS for PC File Formats and SAS/ACCESS to ODBC to Microsoft® Excel.

To ensure the effectiveness of the training you will be invited to join a dedicated group on SAS Professionals where you can provide details of how you are using SAS/ACCESS to export data to Microsoft® Excel. These examples and any queries can then be discussed during the class.

Prerequisites

Before attending this course, you should have an understanding of the concept of SAS Libraries.

SAS Modules Used

This course addresses Base SAS and SAS/ACCESS software.

Course Topics

Introduction

• Introduction to course topics and concepts

Using SAS/ACCESS for PC File Formats

• Proc EXPORT
• SAS/ACCESS LIBNAME Engine

Using SAS/ACCESS to ODBC

Objectives

After attending this live web session you will be able to export unformatted SAS output created using SAS/ACCESS for PC File Formats and SAS/ACCESS to ODBC to Microsoft® Excel.

This outline is provisional and subject to change.