Exporting SAS® Files and Output to Microsoft® Excel Live Web Taster Session

Role

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

Duration

2 hours

Description

This session provides a taste of learning via a Live Web class. During the session you will examine the types of output that can be exported from Base SAS® into Microsoft® Excel and the techniques available to carry out the activity. You will export unformatted output created using ODS CSV and formatted output created using ODS HTML. At the same time you will experience learning via the Internet, participating in quizzes and polls, connecting to the Citrix environment to carry out exercises and observing demonstrations.

Prerequisites

Before attending this course, 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 ODS to Create Comma-Separated Value Files

• Using ODS CSV, ODS CSVALL and ODS CSVBYLINE

Using ODS to Create HTML Files for Microsoft Excel

• Creating HTML files

Objectives

After attending this live web taster session you will be able to:

• use Adobe Connect Pro to participate in a Live Web class
• take part in quizzes and polls during the class
• complete exercises by connecting to SAS via a Citrix client
• state the different types of output that can be exported from SAS to Microsoft® Excel
• describe what techniques export what sort of output to Microsoft® Excel
• use ODS to create comma-separated values files and HTML files for Microsoft Excel