- Home
- SAS Enterprise Guide 2: Advanced Tasks and Querying
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.
Power up your staff’s skills and boost your business
About Program
Format of Training
Training Features
Course Curriculum
Course Fees
Watch
ContactAbout 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
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.
All the benefits of the classroom without the travel
- Join the classroom right from your desktop
- Led by an expert instructor who can virtually look over your shoulder
- Ask questions and get answers in real-time
- Access the latest software via a virtual lab
- Receive 20 business days' access to a recording of your course
- Discuss, share, exchange ideas with participants from different countries
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 overview
- course logistics
Using the Data Menu
- Append Tables task
- Split Columns task
- Stack Columns task
- Random Sample task
- Sort Data task
Using Functions in the Query Builder
- 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
- 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
Learning More
- SAS resources
- beyond this course
Additional Query Topics
- query options
- querying DBMS tables
Course Fees
Are you ready to take on SAS Enterprise Guide 2: Advanced Tasks and Querying?
Let’s get you started with one of the learning paths.
Find My Path Popular Courses
SAS® Academy for Clinical Programming SAS® Academy for Data Science Introduction to CDISC Domains & Standards Data Visualization Machine Learning & AI Data Management Data Analytics Predictive Business AnalystCertification
SAS Certified Base Programmer for SAS 9 SAS® Certified Big Data Professional Using SAS®9 Predictive Modeling certification exam SAS® Certified Clinical Trials Programmer Using SAS®9 SAS® Certified Data Scientist SAS® Certified Platform Administrator for SAS®9
© 2024 Epoch Research Institute India Pvt. Ltd. All Rights Reserved. All Contents Shown from SAS are sole propriety of © SAS Institute Inc. All Rights Reserved. SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Adobe and the Acrobat logo are trademarks of Adobe Systems Incorporated.