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. 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 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
Duration: 2 days
This course is intended for experienced SAS Enterprise Guide users who want to learn more about advanced querying techniques. 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 completing the 'Getting Started' tutorial within SAS Enterprise Guide. No SAS or SQL programming experience is required.
Introduction
- course logistics
- course overview
Using the Data Menu
- introduction to data tasks
- Append Table task
- 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
Query Output Options
Prompting and Conditional Processing
- multiple values prompts
- range prompts
- conditional processing 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
- filtering summarized data
- including detail and summary data
- filtering summarized data in groups
Learning More
- SAS resources
- beyond this course
Students have unlimited 24/7 access to the interactive multimedia course on the Web for one year.
The course requires only a standard Web browser and a free Flash plug-in. The course includes data
that can be downloaded, printable lesson summaries, a Quick Reference Guide, practices and solutions,
step-by-step demonstrations, and a Certificate of Completion.
This course addresses SAS Enterprise Guide.
You should
- use Internet Explorer 6.0 or later or Firefox 1.5 or later, with JavaScript and cookies enabled
- have the latest version of Macromedia Flash Player installed
- have base SAS software visible on the same machine that you are taking the training on so that you can practice your new skills in your own SAS environment.
Back to SAS Global Forum Training
