SAS® Enterprise Guide® 2: Advanced Tasks and Querying
Duration: 14 hours
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 Analytics Pro;SAS Enterprise Guide;SAS Visual Data Discovery
Note: For the 7.1 English version of the course, follow the data setup instructions in the Course Overview. There is no data setup for the Korean version of the course.
The hands-on lab is preconfigured to support this course and will not support hands-on practice for all your enrolled courses.
Live Instructor Dates 
