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

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 tables together, ...

Get The Little SAS Book for Enterprise Guide 4.2 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.