Training The Digital Workforce of Tomorrow.
SAS-EG282 | SAS® Enterprise Guide 2: Advanced Tasks & Querying



2 Day(s)

Instructor-Led Training

from SGD $1980*

Course Schedules

01 Feb 2024 - 02 Feb 2024
10 Jun 2024 - 11 Jun 2024
15 Jul 2024 - 16 Jul 2024
16 Sept 2024 - 17 Sept 2024
11 Nov 2024 - 12 Nov 2024

Enroll/ Enquire Now

*Course Pricing Subjected to Terms & Conditions.

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.

Who Should Enrol?

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

Course Outcome

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.


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


Related Courses

You might also be interested in these courses

SAS-ROSI35 | SAS® Viya® and R Integration for Machine Learning
SAS-YVA231 | SAS® Visual Analytics 2 for SAS® Viya: Advanced
SAS-ST131 | Statistics 1: Introduction to ANOVA, Regression, and Logistic Regression
SAS-JMDE16 | JMP Software: Custom Design of Experiments
AVWSQ-SASPG1 | WSQ - SAS® Programming 1: Essentials
SAS-JCSA16 | JMP® Software: A Case Study Approach to Data Exploration