Lesson 10: Combining Tables

Question 1

Syntax for Concatenating Tables with Matching Columns (same names, length, and type)

Answer 1

DATA output table;
SET input-table 1 input-table2…; (any number of tables)
RUN;

SAS reads all of the rows from the first table listed in a SET statement, and writes them to the new table

Ten it reads and writes the rows from the second table and so on.

In the same DATA step you can include any other statements that you need to manipulate the rows read from all tables.