SAS SQL Case Study
SAS SQL Case Study
SQ1CS : SQ1CS
This course is designed to apply knowledge gained from SAS SQL 1: Essentials to a comprehensive case study project. It includes a review of SAS SQL 1 material along with the case study where you will use PROC SQL to access, explore, prepare, analyze and report on real data. This course builds on the concepts that are presented in the SAS SQL 1 and is not recommended if you have not taken the prerequisite.
Learn How To
- Apply your skills from SAS SQL 1
- Query and subset data
- Summarize and present data
- Combine tables using joins and set operators
- Create and modify tables and views
Who Should Attend
SAS programmers and business analysts
Prerequisites
SAS SQL 1: Essentials In addition, before attending this class, you should be able to do the following: Submit SAS programs on your operating system Create and access SAS data sets Use arithmetic, comparison, and logical operators Invoke SAS procedures You can gain this experience from the SAS Programming 1: Essentials course
SAS Products Covered
Base SAS
Course Outline
- Data Discovery
- SAS SQL 1 Review Access and Explore Data
- Exploring tables
- Exploring columns
- Using DICTONARY tables
- Subsetting data
- Presenting data
- Summarizing data with functions
- Creating and managing tables
- The OUTER UNION operator
- Inner join
- Creating views
- Using functions to report on data
Live Class Schedule
Duration: 7 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
Live Class Schedule
SOLD SEPARATELY
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Coaching Services
Take your training to the next level with personalized coaching. While private training offers structured coursework, coaching provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.