SAS 9 Data Management Learning Subscription

For programmers, data engineers, data integration developers, and data quality stewards using SAS®9 for their data management solution.
START FREE TRIAL
Purchase this digital subscription to:
Digital courses
Unlimited access to digital courses and books in this subscription.
Prepare for certification
Unlimited access to certification preparation materials.
Shareable digital badges
Earn a digital badge for each completed course.
Hands-on learning and practice
Get Full access to SAS software to practice as you learn.

About this Subscription

Gain expertise in designing and deploying data integration and data quality processes. Learn how to access data from a variety of sources, efficiently extract the relevant data, detect data quality issues, and implement processes to improve data quality. In addition, you learn how to apply a variety of data transformation methods to structure the data in ways that support downstream business applications and analytic solutions.

Learn how to:

  • Access data from a variety of source systems and formats and transform it into structures required for business and analytical objectives.
  • Tune SAS programs accessing relational database tables for optimized execution.
  • Profile data to identify data quality issues.
  • Create data flows for data quality improvement and data transformation.
  • Automatically detect and report data quality issues by applying business issues.
  • Apply data quality algorithms to standardize data values and identify duplicate entities.
  • Schedule and manage jobs to execute data transformation pipelines.
  • Process, transform, and publish event stream data in real time.
  • Create a glossary of terms for data governance and associate terms with data sources and data pipelines.
  • View and interpret lineage relationships among data entities and terms.

Before taking courses in this learning subscription, it’s recommended you have experience with SAS programming basics, SQL processing, and the SAS macro facility. You can gain this experience by completing the SAS® Programming 1: Essentials course and the courses in the SAS Programming Learning Subscription.

Courses Included

Data Integration Developer Certification

1

  • COURSE

    SAS® Data Integration Studio: Fast Track
    SHOW LESS ︿
    This course introduces SAS Data Integration Studio and includes topics about change management, registering source data and target data in metadata, creating and working with jobs, and working with transformations. The course also provides information about creating iterative processes, creating conditional processes, defining new transformations, in-database processing, analyzing metadata, promoting metadata, versioning metadata, and deploying jobs.

    The self-paced e-learning includes:
    • Annotatable course notes in PDF format.
    • Virtual lab time to practice.


    ENROLL

  • CERTIFICATION PREP

    SAS Certified Data Integration Developer for SAS 9
    SHOW LESS ︿
    In preparation for this exam, you will learn to define architecture of the platform for SAS Business Analytics, create metadata for source and target data, create metadata for target data and jobs, define generated transformations, and deploy jobs. You will also work with transformations, tables and table loader transformation, and slowly changing dimensions.

    ENROLL

  • CERTIFICATION PREP

    Practice Exam: SAS Data Integration Development for SAS 9
    SHOW LESS ︿
    Practice Exam: SAS Data Integration Development for SAS 9

    ENROLL

Data Connectivity

2

  • COURSE

    Efficiency Tips for Database Programming in SAS®
    SHOW LESS ︿
    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.

    ENROLL

  • COURSE

    SAS® Programming Methods to Read, Process, and Write Database Tables
    SHOW LESS ︿
    This course provides training on the generic aspects of how SAS connectivity works, including independent modules covering connectivity to specific data sources and connectivity in specific computing environments. Material will continue to be added to this course over time.

    ENROLL

Data Governance

3

  • COURSE

    SAS® Federation Server: Accessing and Virtualizing Enterprise Data
    SHOW LESS ︿
    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.

    ENROLL

  • COURSE

    SAS® Data Governance Essentials
    SHOW LESS ︿
    This course teaches you how to create and manage terms using SAS Business Data Network, how to access and view relationship information in SAS Lineage, and how to monitor data in SAS Business Rules Manager and view the monitoring results in SAS Visual Analytics.

    ENROLL

Core Data Quality Topics

4

  • COURSE

    Using DataFlux® Data Management Studio
    SHOW LESS ︿
    This course introduces DataFlux Data Management Studio and includes topics for data profiling, data jobs to perform data management tasks (such as data quality and entity resolution), data monitoring, usage of DataFlux Expression Engine Language, macro variables, and process jobs.

    ENROLL

  • COURSE

    Understanding the SAS® Quality Knowledge Base
    SHOW LESS ︿
    This course is designed for data quality stewards who need to learn more about the Quality Knowledge Base (QKB), as well as how to use DataFlux Data Management Studio to investigate and work with the QKB and its components.

    The self-study e-learning includes:
    • Annotatable course notes in PDF format.
    • Virtual lab time to practice.


    ENROLL

  • COURSE

    Creating a New Data Type in the SAS® Quality Knowledge Base
    SHOW LESS ︿
    This course is designed for data quality stewards who need to learn more about how to use DataFlux Data Management Studio to create new data types in the Quality Knowledge Base.

    The self-study e-learning includes:
    • Annotatable course notes in PDF format.
    • Virtual lab time to practice.


    ENROLL

Additional Data Quality Topics

5

  • COURSE

    Leveraging the Power of the Quality Knowledge Base (QKB) in SAS® Technology Components
    SHOW LESS ︿
    This course assists SAS users with accessing the components of the Quality Knowledge Base (QKB) from within a variety of SAS technology components.

    The self-study e-learning includes:
    • Annotatable course notes in PDF format.
    • Virtual Lab time to practice.


    ENROLL

  • COURSE

    Leveraging the Power of the SAS® Quality Knowledge Base
    SHOW LESS ︿
    This course is for programmers who want to learn how to leverage the power of the SAS Quality Knowledge Base, or QKB. The QKB and the associated SAS Data Quality functions, routines, procedures, and CAS actions enable data cleansing, transformation, deduplication, and fuzzy matching using simplified code in DATA step, SQL, and CASL. The course builds on concepts presented in the SAS® Programming 1: Essentials, SAS® Programming 2: Data Manipulation Techniques, and SAS® SQL 1: Essentials courses, and is not recommended for beginning SAS software users.

    ENROLL

Hadoop

6

  • COURSE

    Introduction to SAS® and Hadoop
    SHOW LESS ︿
    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.

    ENROLL

  • COURSE

    Hadoop Data Management with Hive, Pig, and SAS®
    SHOW LESS ︿
    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.

    ENROLL

  • COURSE

    Working with SAS® Data Loader for Hadoop
    SHOW LESS ︿
    This course gives business analysts and data scientists a seamless platform to profile, integrate, cleanse, and move big data without writing code in a Hadoop environment using an intuitive web-based interface.

    ENROLL

Event Stream Processing

7

  • COURSE

    SAS® Event Stream Processing: Essentials (6.2)
    SHOW LESS ︿
    This course teaches you how to build SAS Event Stream Processing applications that ingest high-volume and high-velocity data streams, respond in real time, and store only relevant data elements. The course discusses basic concepts of event stream processing and introduces the component objects with which to build event stream processing applications.

    ENROLL

SAS Products Covered

  • SAS Analytics Platform
  • SAS Data Quality Solution
  • SAS Data Integration Studio
  • SAS/ACCESS
  • Base SAS
  • DataFlux Data Management Studio
  • SAS Enterprise Guide
  • SAS Federation Server
  • SAS Business Data Network
  • SAS Data Governance
  • SAS Lineage
  • DataFlux Data Management Server
  • SAS Viya
  • SAS Data Connect Accelerator for Hadoop
  • SAS Data Connector to Hadoop
  • SAS Data Loader for Hadoop
  • SAS Event Stream Processing


Digital Badges

Earn a digital badge for each course that you complete and for each credential that you earn. Show off your achievements on your resume and in your social channels to highlight your skills and connect with potential employers.

Certification Preparation

When you complete the courses in this learning path, you will have the demonstrated skills necessary to prepare you to earn the following credentials:

“I think the self-paced training was the BEST I’ve ever taken. The videos were short and segmented correctly to keep my attention and the activities and quizzes were just enough to help my confidence.”

Tony Mayo, SAS Customer