Base SAS

Title	Level	Training Formats
Administrative Healthcare Data and SAS®: Hands-On Programming Workshop This hands-on workshop is open to SAS programmers who attended the Administrative Healthcare Data and SAS course. This workshop explores programming methods and techniques that are useful in the management of administrative healthcare data.	1 Beginner
Administrative Healthcare Data and SAS® This industry-specific course focuses on the payer side of the industry: the origin, content, management, and use of administrative healthcare data. During the course, students become acquainted with the providers, payers, and users of the U.S. healthcare system. This course is not a hands-on programming course, but rather, it explores the business of medical claims data, health plan members, and service providers. As a supplement to this course, programmers should consider also registering for Administrative Healthcare Data and SAS: Hands-On Programming Workshop, a one-day course that focuses on programming methods and techniques that are useful in the healthcare industry. The two courses are offered on contiguous days.	1 Beginner
SAS® Programming 1: Essentials This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses. If you do not plan to write SAS programs and you prefer a point-and-click interface, you should attend the SAS Enterprise Guide 1: Querying and Reporting course.	2 Fundamental
SAS® SQL 1: Essentials This course teaches you how to process SAS data using Structured Query Language (SQL).	3 Intermediate
SAS® Programming 2: Data Manipulation Techniques This course is for those who need to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the SAS Programming 1: Essentials course and is not recommended for beginning SAS software users.	3 Intermediate
SAS® Programming 3: Advanced Techniques This course is for SAS programmers who want to learn advanced techniques within the DATA step and procedures. The course builds on the concepts that are presented in the SAS Programming 2: Data Manipulation Techniques course.	4 Advanced
SAS® Macro Language 1: Essentials This course focuses on using the SAS macro facility to design, write, and debug macro programs, with an emphasis on understanding how programs that contain macro code are processed.	4 Advanced
SAS® Programming 1 Case Study This course is designed to apply knowledge gained from SAS Programming 1: Essentials to a comprehensive Case Study project. It is led by a live instructor and includes a review of SAS Programming 1 topics along with the Case Study project. In this course you will use your SAS skills to solve problems and get results as you are guided through the SAS programming process. This is a great course to take after completing SAS Programming 1 and before taking SAS Programming 2. In addition, this class will help you prepare for the Base SAS Certification Exam for SAS 9.4.	1 Beginner
SAS® Programming 2 Case Study This course is designed to apply knowledge gained from SAS Programming 2: Data Manipulation Techniques to a comprehensive case study project. It includes a review of SAS Programming 2 material along with the case study where you will use the DATA step and procedures to prepare, merge, transpose and summarize real data. The course builds on the concepts that are presented in the SAS Programming 2 and SAS Programming 1: Essentials course and is not recommended if you have not taken the prerequisites.	1 Beginner
Working with JSON Files Using SAS In this comprehensive course, you will explore JavaScript Object Notation (JSON) files and gain essential skills to proficiently utilize them using SAS. JSON has become a widely adopted format for data exchange due to its simplicity and clarity. Through hands-on exercises and real-world examples, you will learn about JSON files, their data types, and how to seamlessly integrate SAS tools and techniques to effectively read and write JSON files, enhancing your analytical capabilities.	1 Beginner
Exploring SAS® Studio for SAS® Programmers This course provides an introduction to SAS Studio for experienced SAS programmers. SAS Studio is an interface that enables users to write and submit SAS programs and use snippets and tasks to generate SAS code. The self-study e-learning includes: Annotatable course notes in PDF format. Virtual Lab time to practice.	3 Intermediate
SAS® Federation Server: Accessing and Virtualizing Enterprise Data SAS Federation Server makes it easier for business users to access secure data for reporting and analysis. It provides a virtual layer or view, giving users the appropriate level of control without physically moving data. This frees up IT staff to focus on other tasks by giving them a simple method of sharing data using a centralized, governed security layer.	3 Intermediate
Hadoop Data Management with Hive, Pig, and SAS® In this course, you use processing methods to prepare structured and unstructured big data for analysis. You learn to organize this data into a variety of Hadoop distributed file system (HDFS) storage formats for processing efficiency using Apache Hive and Apache Pig. You also learn SAS software technologies that integrate with Hive and Pig and how to leverage these open source capabilities by programming with Base SAS and SAS/ACCESS Interface to Hadoop.	3 Intermediate
Introduction to SAS® and Hadoop This course teaches you how to use SAS programming methods to read, write, and manipulate Hadoop data. Base SAS methods that are covered include reading and writing raw data with the DATA step and managing the Hadoop file system and executing Pig code from SAS via the HADOOP procedure. In addition, the SAS/ACCESS Interface to Hadoop methods that allow LIBNAME access and SQL pass-through techniques to read and write Hadoop Hive table structures are discussed. Although not covered in detail, a brief overview of additional SAS and Hadoop technologies, including executing DS2 in Hadoop with the SAS Code Accelerator for Hadoop and using Hadoop data sources for the distributed in-memory analytics platform of SAS Viya, is included. This course is included in the Expert Exchange on Hadoop: Using SAS/ACCESS service offering to configure SAS/ACCESS Interface to Hadoop or SAS/ACCESS Interface to Impala to work with your Hadoop environment.	3 Intermediate
Efficiency Tips for Database Programming in SAS® This class teaches you how to tune your SAS programs for faster execution, especially those that access relational database tables using SAS/ACCESS interfaces or SAS Viya data connectors.	3 Intermediate
Exploring SAS® Studio for SAS® Analytics Pro This course demonstrates how the functionality and features of SAS Studio for SAS Analytics Pro in SAS Viya can enable SAS programmers to save time by coding more efficiently.	3 Intermediate
SAS® Report Writing This course teaches you how to create tabular reports using the REPORT and TABULATE procedures. You also learn how to enhance your reports using the Output Delivery System (ODS).	3 Intermediate
Data Visualization Using ODS Graphics This course teaches you how to write SAS programs that use ODS Graphics to produce high-quality data visualizations. ODS Graphics is part of Base SAS.	3 Intermediate
SAS® Certification Review: SAS® 9.4 Base Programming Performance-Based Exam This course provides a review of the majority of topics in the SAS 9.4 Base Programming Performance-Based Exam. It addresses the four exam content areas: Accessing and Creating Data Structures, Managing Data, Generating Reports and Output, and Handling Errors.	3 Intermediate
SAS SQL Case Study 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.	3 Intermediate
Feature Engineering and Data Preparation for Analytics This course introduces programming techniques to craft and feature engineer meaningful inputs to improve predictive modeling performance. In addition, this course provides strategies to preemptively spot and avoid common pitfalls that compromise the integrity of the data being used to build a predictive model. This course relies heavily on SAS programming techniques to accomplish the desired objectives.	4 Advanced
High-Performance Data Manipulation with SAS® DS2 This course teaches DS2 programming. DS2 is a fourth-generation SAS language, designed for advanced data manipulation. It blends DATA step and SQL syntax using modern programming structures and can process multiple rows of data in parallel in Base SAS and in supported massively parallel processing environments such as Hadoop, Teradata, and SAS Cloud Analytic Services (CAS). A brief introduction to SAS Viya and Cloud Analytic Services is included. The self-paced e-learning includes: Annotatable course notes in PDF format. Virtual lab time to practice.	4 Advanced
SAS® Programming for R Users This course is for experienced R users who want to apply their existing skills and extend them to the SAS environment. Emphasis is placed on programming and not statistical theory or interpretation. Students in this course should have knowledge of plotting, manipulating data, iterative processing, creating functions, applying functions, linear models, generalized linear models, mixed models, stepwise model selection, matrix algebra, and statistical simulations.	3 Intermediate
Establishing Causal Inferences: Propensity Score Matching, Heckman's Two-Stage Model, Interrupted Time Series, and Regression Discontinuity Models This course introduces some methods commonly used in program evaluation and real-world effectiveness studies, including two-stage modeling, interrupted time-series, regression discontinuity, and propensity score matching. These methods help address questions such as: Which medicine is more effective in the real world? Did an advertising program have an impact on sales? More generally, are the changes in outcomes causally related to the program being run?	3 Intermediate
Introduction to Statistical Concepts This course covers basic statistical concepts that are critical for understanding and using statistical methods. This course explains what statistics is and why it is important to understand the characteristics of your data. The information in this course is a prerequisite for many other statistical courses that SAS Education offers. The course is appropriate for Base SAS and SAS Enterprise Guide users. Data, practices, and a case study are included.	1 Beginner
SAS Programming: Getting Started This journey will help you get started developing code in SAS. This collection of free learning assets provide a tour of what is possible with programming in either SAS 9 or SAS Viya.	1 Beginner
SAS Viya Data Engineering: Getting Started Get started using SAS Data Engineering by spending a little time each day learning a new aspect of the offering. Over the course of a few weeks, you'll get a good idea of the skills you may need to leverage SAS' data engineering capabilities. At the end of your journey be sure to explore formal enablement opportunities to continue your quest in becoming a SAS Data Engineer.	1 Beginner
SAS® and Hadoop In this course, you learn about the Hadoop environment, Apache Hive, and Apache Pig, as well as various SAS methods for interacting with Hadoop.	3 Intermediate