Chapter 6
Combining Data Tables
6.1 Methods for Combining Tables
6.4 Setting the Properties of a Join
6.1 Methods for Combining Tables
In SAS Enterprise Guide, there are two basic ways to combine data tables: appending and joining. You append when the tables contain the same (or almost the same) columns. You join when the tables contain the same (or almost the same) rows. This section describes, in general terms, what happens when you combine tables.
Appending tables Appending tables is like stacking them. It only makes sense to append tables if they have columns in common. Appending tables is done with the Append Table task, which is described in the next section.
Joining tables To join ...
Get The Little SAS Book for Enterprise Guide 4.2 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.
