SAS(R) Enterprise Guide(R) 2: Advanced Tasks and Querying

Course code: EG282

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.
1 200 EUR

1 452 EUR including VAT

Selection of dates
onas
Do you have a question?
+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: Upon request

Type: Upon request

Course duration: 14 hours

Language: en

Price without VAT: 1 200 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
Upon request Upon request 14 hours en 1 200 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Target group

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

Course structure

Working with Data in a Project

  • Working with projects.
  • Accessing data.

Transforming SAS Tables

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

Manipulating Data Values

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

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

Prerequisites

Before attending this course, students should understand how to do the following:
  • Navigate the SAS Enterprise Guide environment.
  • Create projects.
  • Add data sources.
  • Use tasks to accomplish basic analysis and reporting.
  • Create queries.
  • Do you need advice or a tailor-made course?

    onas

    product support

    ComGate payment gateway MasterCard Logo Visa logo