Overview
Introduction
When you need to select
data from multiple tables and combine the tables horizontally (side
by side), PROC SQL can be an efficient alternative to other SAS procedures
or the DATA step. You can use a PROC SQL join to combine tables horizontally:
proc sql;
select *
from a, b
where a.x=b.x; |
 |
A PROC SQL join is a
query that specifies multiple tables and/or views to be combined and,
typically, specifies the conditions on which rows are matched and
returned in the result set.
You should already be familiar with the basics of using PROC SQL to join tables. In this chapter, you take a more in-depth look at joining tables. ...
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.
