SAS Enterprise Guide 2: Advanced Tasks and Querying

This course addresses SAS Enterprise Guide software.

• course overview
• course logistics

• 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

• SAS resources
• beyond this course

• query options
• querying DBMS tables