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.
Purchase this digital subscription to:
Unlock 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 in Subscription

    Data Integration Developer Certification

    1
    • COURSE

      SAS® Data Integration Studio: Fast Track
      SHOW MORE ﹀
      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.

    • CERTIFICATION PREP

      Practice Exam: SAS Data Integration Development for SAS 9
      SHOW MORE ﹀
      Practice Exam: SAS Data Integration Development for SAS 9

    Data Connectivity

    2
    • COURSE

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

    • COURSE

      SAS® Programming Methods to Read, Process, and Write Database Tables
      SHOW MORE ﹀
      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.

    Data Governance

    3
    • COURSE

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

    • COURSE

      SAS® Data Governance Essentials
      SHOW MORE ﹀
      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.

    Data Quality Steward Certification

    4
    • COURSE

      Using DataFlux® Data Management Studio
      SHOW MORE ﹀
      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.

    • COURSE

      Understanding the SAS® Quality Knowledge Base
      SHOW MORE ﹀
      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.


    • COURSE

      Creating a New Data Type in the SAS® Quality Knowledge Base
      SHOW MORE ﹀
      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.


    • CERTIFICATION PREP

      Practice Exam: SAS Data Quality Using Dataflux Data Management Studio
      SHOW MORE ﹀
      Practice Exam: SAS Data Quality Using Dataflux Data Management Studio

    Additional Data Quality Topics

    5
    • COURSE

      Leveraging the Power of the Quality Knowledge Base (QKB) in SAS® Technology Components
      SHOW MORE ﹀
      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.


    • COURSE

      Leveraging the Power of the SAS® Quality Knowledge Base
      SHOW MORE ﹀
      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(R) Programming I: Essentials, SAS(R) Programming II: Manipulating Data with the DATA Step, and SAS(R) SQL 1: Essentials courses, and is not recommended for beginning SAS software users.

    Hadoop

    6
    • COURSE

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

    • COURSE

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

    • COURSE

      Working with SAS® Data Loader for Hadoop
      SHOW MORE ﹀
      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.

    Event Stream Processing

    7
    • COURSE

      SAS® Event Stream Processing: Essentials (6.2)
      SHOW MORE ﹀
      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.

    Decisioning

    8
    • COURSE

      Using SAS Intelligent Decisioning in SAS® Viya®
      SHOW MORE ﹀
      This workshop introduces SAS Intelligent Decisioning and the processes and concepts behind Intelligent Decisioning including its point-and-click user interface, business rules, and decisions services.

    SAS Products Covered

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


    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:

  • SAS Certified Data Integration Developer
  • SAS Certified Data Quality Steward for SAS 9


  • “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