Making More of SAS® Enterprise Guide® - Data Manipulation Techniques

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 data manipulation techniques.

Prior to class you will be invited to join a dedicated group on SAS Professionals where you can provide details of what data manipulation you need to perform 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

Creating Simple Queries

• Introduction to the query task
• Setting a Filter to select rows
• Selecting columns
• Creating new columns

Using an expressions

By recoding values

• Grouping data in a query
• Filtering grouped data

Objectives

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

• Explain the function of the different tabs within the Query Builder
• Use the Query Builder in SAS® Enterprise Guide® to: select the rows and columns required in the output; create new columns; summarise your data according to group values

This outline is provisional and subject to change.