Available in:
Skip Course Subscription
Skip Earn this badge
Skip Course Contact for SAS Layout
Learning Path
This course is part of the SAS Enterprise Guide and SAS Office Analytics Learning Subscription.
Earn this badge
SAS® Enterprise Guide® 2: Advanced Tasks and Querying
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.
SAS Products Covered
SAS Enterprise Guide
Course Outline
Working with Data in a Project
- Working with projects.
- Accessing data.
- Append Tables task.
- Split Columns task.
- Stack Columns task.
- Random Sample task.
- Sort Data task.
- Introduction to SAS functions.
- Manipulating numeric values.
- Manipulating character values.
- Converting data type.
- Multiple values prompts.
- Range prompts.
- Conditional processing of project steps.
- Recoding values.
- Recoding values based on a condition.
- Writing CASE expressions.
- Creating and applying custom formats.
- Grouping and summarizing data.
- Including detail and summarized data.
- Filtering summarized data in groups.
Live Class Schedule
Duration: 14 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
Live Class Schedule
SOLD SEPARATELY
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.