Making More of SAS® Enterprise Guide® - Joining Tables

Role

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

Duration

3 hours

Description

SAS® Enterprise Guide® provides a SAS graphical interface that helps you exploit the power of SAS and publish dynamic results in a Microsoft Windows client application. The solution is the preferred SAS interface for business analysts, programmers and statisticians and a key application in SAS Business Intelligence offerings.

This session is one of a series of short Live Web classes aiming to help you make the most of SAS® Enterprise Guide®. During this class you will learn some essential techniques for joining tables.

Prior to class you will be invited to join a dedicated group on SAS Professionals where you can provide details of how you need to join tables using Enterprise Guide. These can then be discussed during the class.

Prerequisites

Before attending this course, you should be able to:

• invoke a SAS® Enterprise Guide® session
• open or create a new SAS® Enterprise Guide® project
• add data to the project
• run simple tasks against the data, i.e. list data, one-ways frequencies etc

SAS Modules Used

This course addresses SAS® Enterprise Guide® 4.2.

Course Topics

Introduction

• Introduction to course topics and concepts

Joining Tables Horizontally (Merging)

• Joining Tables
• Joining Tables including non-matching rows

Joining Tables Vertically (Concatenating and Interleaving)

• Appending Tables
• Interleaving Tables

Objectives

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

• State the different techniques available for joining tables using SAS® Enterprise Guide®
• Use the appropriate task to achieve the required join using SAS® Enterprise Guide®

This outline is provisional and subject to change.