SAS Enterprise Guide 2: Advanced Tasks and Querying

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.

Duration 2 Days
Certificate SAS Global
Language English

Fees 12000 + taxes


Power up your staff’s skills and boost your business

or Call us on +91 79 403 270 00


Course Description

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

About Program

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.

Format of Training

All the benefits of the classroom without the travel:

Led by an expert instructor who can virtually look over your shoulder. Discuss, share, exchange ideas with students from different countries

Classroom training options include courses offered in our regional training centers or via our Live Web classroom.

Taught by certified instructors at high-tech facilities across the country

  • A SAS expert at your side.
  • Focused learning away from the office
  • Networking opportunities
  • State-of-the-art facilities
  • Electronic course notes downloadable to your device and permission to print
  • Business Knowledge Series: in-depth courses on the latest business topics
  • We offer Connected Classes! Watch for courses in Cary, New York, Arlington, Dallas and San Francisco that connect remote students via our Live Web classroom.

Train when and where you want

  • Eliminate travel costs and time away
  • Enjoy award-winning e-Courses

SAS e-Learning courses do not include SAS software. You must have SAS software installed to complete the practice exercises.

Prerequisite

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

This course addresses SAS Enterprise Guide software.

Training Features

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

Introduction

  • course logistics
  • course overview

Using the Data Menu

  • introduction to data tasks
  • Split Columns task
  • Stack Columns task
  • Transpose task (self-study)
  • Random Sample task
  • Sort Data task

Using Functions in the Query Builder

  • introduction to functions
  • manipulating values
  • converting data type

Prompting and Conditional Processing

  • multiple value prompts
  • range prompts
  • conditional process of project steps

Case Logic

  • recoding values
  • using the Replace condition
  • writing CASE expressions
  • writing nested CASE expressions (self-study)

Grouping and Filtering

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

Query Options (Self-Study)

  • query output options

Learning More

  • SAS resources
  • beyond this course

Project

  • multiple value prompts
  • range prompts
  • conditional process of project steps

FAQs

Each exam challenges candidates to apply specific knowledge they have acquired through SAS software training and/or job experience. Computer-based in format, SAS Global Certification exams comprise multiple-choice and/or short-answer questions, depending on the exam. Exams are generally scheduled through Pearson VUE but are also held at various locations around the world on a pre-scheduled basis. Candidates are allotted varying time limits to complete the exam, depending on which exam is taken. Specific exam content and passing criteria are located within each exam. To encourage your feedback, SAS Global Certification exams include a feature that allows candidates to comment on specific test questions. Your opinions are important to us and are a critical component in test development. Additionally, SAS Global Certification requires candidates to accept the terms of the SAS Institute Inc. Certification Program CandidatCancele Agreement before taking a certification exam.

Short-answer questions require you type your answer in a text box, rather than select your answer from four options. Typically, you will provide a numeric answer or a short section of SAS programming code. When entering code, case is ignored, and all variations of SAS syntax that correctly complete the program are accepted as correct.

Course Fees

e-learning

  

  

12000

+ Applicable Taxes
Enroll Now