Description

This course is intended for experienced SAS Enterprise Guide users who want to learn more about advanced SAS Enterprise Guide techniques. It focuses on using the Query Builder within SAS Enterprise Guide, including manipulating character, numeric, and date values; converting variable type; and building conditional expressions using the Expression Builder. This course also addresses efficiency issues, such as joining tables and using a single query to group, summarize, and filter data.

Skills Gained

use tasks to transpose, stack, rank, and create a random sample of your data
use functions to convert the data type from character to numeric and from numeric to character
use conditional logic in the Query Builder to create new columns
use multiple value prompts.

Who Can Benefit

Non-programmers with SAS Enterprise Guide experience, as well as experienced programmers with SAS Enterprise Guide experience

Course Overview

Introduction

course overview
course logistics

Using the Data Menu

Append Tables task
Split Columns task
Stack Columns task
Random Sample task
Sort Data task

Using Functions in the Query Builder

introduction to SAS functions
manipulating numeric values
manipulating character values
converting data type

Prompting and Conditional Processing

multiple values prompts
range prompts
conditional processing of project steps

Recoding Data

recoding values
recoding values based on a condition
writing CASE expressions
creating and applying custom formats

Grouping and Filtering

grouping and summarizing data
including detail and summarized data
filtering summarized data in groups

Learning More

SAS resources
beyond this course

Additional Query Topics

query options
querying DBMS tables

Prerequisites

Before attending this course, students should understand how to navigate the SAS Enterprise Guide environment, create projects, add data sources, accomplish basic analysis and reporting using tasks, and create queries. You can gain this knowledge by taking the SAS(R) Enterprise Guide(R) 1: Querying and Reporting course or by completing the Getting Started tutorial in SAS Enterprise Guide. No SAS or SQL programming experience is required.

SAS Enterprise Guide 2: Advanced tasks and Querying Classroom Live Washington, DC October 24, 2017

Price: $1,100

Enroll today to reserve your spot!

Description

Course Overview

Prerequisites

Find a Course

Corporate Services

Contact us