Exporting Unformatted Output to Microsoft Excel using Base SAS

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 the DATA Step, Proc PRINTTO and ODS LISTING 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 examples of how you are using Base SAS to export to Microsoft® Excel at work. These examples and any questions will be open to discussion during the class.

Prerequisites

Before attending this class, you should have attended the SAS Programming 1: Essentials course or have the equivalent knowledge and experience. Basic knowledge of the SAS Output Delivery System (ODS) and simple invocation techniques is helpful but not required.

SAS Modules Used

This course addresses Base SAS.

Course Topics

Introduction

• Introduction to course topics and concepts

Using the DATA Step

• Using FILE and PUT statements to create fixed-width and delimited text files
• " Sending SAS Output via email

Proc PRINTTO

• Using Proc PRINTTO to generate an ASCII text files

Using ODS LISTING

• Using ODS LISTING to send Procedure output to an ASCII text file

Objectives

After attending this live web session you will be able to export unformatted SAS output created using the DATA Step, Proc PRINTTO and ODS LISTING to Microsoft® Excel.

This outline is provisional and subject to change.