Exporting Unformatted SAS® Output to Microsoft® Excel using Dynamic Data Exchange (DDE)

Role

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

Duration

2 hours

Description

Dynamic Data Exchange (DDE) is a method of dynamically exchanging information between Windows applications. You can use DDE with the DATA step, the SAS macro facility, SAS/AF applications, or any other portion of SAS that requests and generates data. DDE has many potential uses, one of which is to acquire data from a Windows spreadsheet or database application.

During this live web session you will export unformatted SAS® output using Dynamic Data Exchange to Microsoft® Excel. You will also be invited to join a dedicated group on SAS Professionals where you can provide examples of how you are using DDE at work. These examples and any questions will be open to discussion during the class.

Prerequisites

Before attending this course, you should have attended the SAS Programming 2: Data Manipulation Techniques course or have the equivalent knowledge and experience. Basic knowledge of simple invocation techniques is helpful but not required.

SAS Modules Used

This course addresses Base SAS software.

Course Topics

Introduction

• Introduction to course topics and concepts

Using Dynamic Data Exchange

• Controlling applications with DDE
• Using the DDE Hotlink
• Missing Values
• Using the NOTAB Option
• Using the !DDE_FLUSH string to transfer data dynamically
• Invoking application commands
• Using Macro Variables to Issue DDE Commands

Objectives

After attending this live web session you will be able to export unformatted SAS output using Dynamic Data Exchange to Microsoft® Excel.

This outline is provisional and subject to change.