SAS Enterprise Guide 2: Advanced Tasks & Querying

Course Code:
SAS-EG282
Duration:
2 days
9:00am to 5.00pm
Course Fees:
S$1,800 (excl of G.S.T)
2020 Course Dates
27 – 28 Jul 2020
17 – 18 Aug 2020
25 – 26 Aug 2020
3 – 4 Sep 2020
21 – 22 Oct 2020
29 – 30 Oct 2020
5 – 6 Nov 2020
10 – 11 Dec 2020
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.

Course Overview

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.

Program Objectives

Learn how to

• 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.

Course Outline

Module 1: Working with Data in a Project

Module 2: Transforming SAS Tables

Module 3: Manipulating Data Values

Module 4: Prompting and Conditional Processing

Module 5: Recoding Data Values

Module 6: Grouping and Filtering

Click Here for full course outline

Take The Next Step

It Takes Less Than 5 Min