Enterprise guide - query & reporting
Aims
The course introduces the SAS Enterprise Guide tool used to produce, in a fully guided form in the Windows environment, data access, treatment, analysis and presentation activities. With this software, you can learn how to access local and remote data in different input formats, define formats, join tables, generate summary reports, descriptive statistics and charts.
Who should attend
End users, Business users.
Prerequisites
Familiarity with individual computing tools; this course does not require SAS knowledge.
Course outline
- Enterprise Guide and SAS: areas of use, aims, differences, interface organisation
- Projects, data, activities
- Data models
- Local and remote data management
- External data access (DBMS, text files, MS Excel)
- Available activities/tasks
- Use environment
- Report creation examples (detail and summary tables etc.)
- Basic styles for result presentation
- Definition and application of user representation formats
- Query definition environment
- How to set row and column selection filters
- Simple table joins
- Defining new output columns
- How to substitute query values and parameters
- Complex table joins
- Advanced query data joining and selection
- Creating parametrised query
- Creating summarized output and export table
- Creating graphs
- Creating one-way or multi-way summary tables
Duration
The duration of the course is 2 days.