SAS® Enterprise Guide® 2: Advanced Tasks and Querying
Available in:
Education Category Image


  
SAS® Enterprise Guide® 2: Advanced Tasks and Querying
Duration: 14 hours
EG2 : 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.
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.
  • Who Should Attend
    Non-programmers with SAS Enterprise Guide experience, as well as experienced programmers with SAS Enterprise Guide experience
    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. ;You can gain this knowledge by taking the SAS Enterprise Guide 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 Products Covered
    SAS Enterprise Guide
    Course Outline
    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.

  • Live Instructor Dates SOLD SEPARATELY
    DATES ▼ LOCATION
    TIME
    LANGUAGEEVENT FEE
    16-19 JUN 2025Live Web, US10:30 AM-2:30 PM EDTSpanish1,450 USD
    23-26 JUN 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,450 USD
    18-21 AUG 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,450 USD
    30 SEP-03 OCT 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,450 USD
    11-14 NOV 2025Live Web, US1:00 PM-4:30 PM ESTEnglish1,450 USD
    01-04 DEC 2025Live Web, US9:30 AM-1:30 PM ESTSpanish1,450 USD


    THIS COURSE IS PART OF

    SAS Enterprise Guide and SAS Office Analytics Learning Subscription



    Skip Earn this badge

    Earn this badge

    Badge Image