SAS® Enterprise Guide® 2: Advanced Tasks and Querying

Non-programmers with SAS Enterprise Guide experience, as well as experienced programmers with SAS Enterprise Guide experience

• 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

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.

Working with Data in a Project

• Working with projects
• Accessing data

Transforming SAS Tables

• Append Tables task
• Split Columns task
• Stack Columns task
• Random Sample task
• Sort Data task

Manipulating Data Values

• 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 Values

• 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

Previous courses

SAS® Enterprise Guide® 1: Querying and Reporting [EG182]