- Home
- SAS Enterprise Guide 1: Querying and Reporting
SAS Enterprise Guide 1: Querying and Reporting
This course is for users who do not have SAS programming experience but need to access, manage, and summarize data from different sources, and present results in reports and graphs.
Power up your staff’s skills and boost your business
About Program
Format of Training
Training Features
Course Curriculum
Course Fees
Watch
ContactAbout Program
This course is for users who do not have SAS programming experience but need to access, manage, and summarize data from different sources, and present results in reports and graphs. This course focuses on using the menu-driven tasks in SAS Enterprise Guide, the point-and-click interface to SAS, to create queries and reports. It does not address writing SAS code or statistical concepts. This course serves as a prerequisite for the SAS Enterprise Guide 2: Advanced Tasks and Querying course and for the Creating Reports and Graphs with SAS Enterprise Guide course. It also serves as a prerequisite for the SAS Enterprise Guide: ANOVA, Regression, and Logistic Regressioncourse, which teaches statistical concepts using SAS Enterprise Guide.
Format of Training
Taught by certified instructors at high-tech facilities across the country
- A SAS expert at your side.
- Focused learning away from the office
- Networking opportunities
- State-of-the-art facilities
- Electronic course notes downloadable to your device and permission to print
- Business Knowledge Series: in-depth courses on the latest business topics
- We offer Connected Classes! Watch for courses in Cary, New York, Arlington, Dallas and San Francisco that connect remote students via our Live Web classroom.
All the benefits of the classroom without the travel
- Join the classroom right from your desktop
- Led by an expert instructor who can virtually look over your shoulder
- Ask questions and get answers in real-time
- Access the latest software via a virtual lab
- Receive 20 business days' access to a recording of your course
- Discuss, share, exchange ideas with participants from different countries
Training Features
- access and manipulate local and remote data of various types
- create queries that filter and summarize data, compute new columns, and join multiple tables
- create frequency and tabular reports
- create interactive graphs
- automate output results.
Course Curriculum
Getting Started
- introducing SAS Enterprise Guide
- course scenarios
Working with Data in a Project
- understanding the SAS data structure
- accessing SAS and DBMS data
- importing data files
Getting Started with Tasks
- introduction to tasks and wizards
- creating a frequency report
- generating HTML, PDF, and RTF output
- creating a listing report
- filtering data in a task
- creating a graph
Creating Summarized Output
- generating summary statistics
- creating a summary report with the Summary Tables task
Creating Simple Queries
- filtering and sorting data
- creating new columns with an expression
- grouping and summarizing data in a query
- joining tables
Using Prompts in Tasks and Queries
- prompting in projects
- creating and using prompts in tasks
- creating and using prompts in queries
Customizing and Organizing Project Results
- combining results
- updating and organizing projects
Learning More
- SAS resources
- beyond this course
Writing and Submitting SAS Programs
- writing and submitting SAS programs
Course Fees
Are you ready to take on SAS Enterprise Guide 1: Querying and Reporting?
Let’s get you started with one of the learning paths.
Find My Path Popular Courses
SAS® Academy for Clinical Programming SAS® Academy for Data Science Introduction to CDISC Domains & Standards Data Visualization Machine Learning & AI Data Management Data Analytics Predictive Business AnalystCertification
SAS Certified Base Programmer for SAS 9 SAS® Certified Big Data Professional Using SAS®9 Predictive Modeling certification exam SAS® Certified Clinical Trials Programmer Using SAS®9 SAS® Certified Data Scientist SAS® Certified Platform Administrator for SAS®9
© 2024 Epoch Research Institute India Pvt. Ltd. All Rights Reserved. All Contents Shown from SAS are sole propriety of © SAS Institute Inc. All Rights Reserved. SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Adobe and the Acrobat logo are trademarks of Adobe Systems Incorporated.