SAS® 9.4 Cert Prep: Part 12 Combining Tables

Go to class
Write Review

Free Online Course: SAS® 9.4 Cert Prep: Part 12 Combining Tables provided by LinkedIn Learning is a comprehensive online course, which lasts for Less than 1 hour of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. SAS® 9.4 Cert Prep: Part 12 Combining Tables is taught by SAS Institute.

Overview
  • Prepare to take the SAS 9.4 certification exam. Learn how to consolidate your data by combining tables with the SAS DATA step.

Syllabus
  • Introduction

    • Combine tables to consolidate your data
    1. Concatenating Tables
    • Concatenating tables with matching columns
    • Demo: Concatenating tables
    • Handling column attributes
    2. Merging Tables
    • What is a merge?
    • Processing a one-to-one merge
    • Processing a one-to-many merge
    • Demo: Combining
    3. Identifying Matching and Nonmatching Rows
    • Merging tables with nonmatching rows
    • Identifying matches and nonmatches
    • Demo: Merging tables with nonmatching rows
    • Merging tables with matching column names
    • Merging tables without a common column
    • DATA step merge and PROC SQL Join