Querying Multiple Tables
Overview
This topic deals with the more complex
task of extracting data from two or more tables.
Previously, you learned
how to write a PROC SQL step to query a single table. Suppose you
now want to examine data that is stored in two tables. PROC SQL enables
you to combine tables horizontally, in other words, to combine rows
of data.
In SQL terminology, combining tables horizontally is
called joining tables. Joins do not alter the original tables.
Suppose you want to create a report that displays the following information for employees of a company: employee identification number, last name, original salary, and ...
Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
