Chapter 6. Combining Data Tables
6.1 Methods for Combining Tables 240
6.2 Appending Tables 242
6.3 Joining Tables 244
6.4 Setting the Properties of a Join 246
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 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.
To join tables together, ...