- Home
- SAS SQL 1: Essentials
SAS SQL 1: Essentials
This course teaches you how to process SAS data using Structured Query Language (SQL).
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 teaches you how to process SAS data using Structured Query Language (SQL).
This course can help prepare you for the following certification exam(s): SAS Advanced Programming for SAS 9.
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
- query and subset data
- summarize and present data
- combine tables, including complex joins and merges
- create and modify table views and indexes
- replace multiple DATA and PROC steps with one SQL query.
Course Curriculum
Introduction
- overview of SAS Foundation
- course logistics
- course data files
- introducing the Structured Query Language
Basic Queries
- overview of the SQL procedure
- specifying columns
- specifying rows
Displaying Query Results
- presenting data
- summarizing data
SQL Joins
- introduction to SQL joins
- inner joins
- outer joins
- complex SQL joins
Set Operators
- introduction to set operators
- the UNION operator
- the OUTER UNION operator
- the EXCEPT operator
- the INTERSECT operator
Creating Tables and Views
- creating tables with the SQL procedure
- creating views with the SQL procedure
Advanced PROC SQL Features
- dictionary tables and views
- using SQL procedure options
- interfacing PROC SQL with the macro language
Subqueries
- noncorrelated subqueries
- in-line views
Learning More
- SAS resources
- beyond this course
Course Fees
Are you ready to take on SAS SQL 1: Essentials?
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.