SAS Certification Prep Guide, 4th Edition

Creating a Table from a Query Result

Overview

Sometimes you want to create a new table that contains both columns and rows that are derived from an existing table or set of tables. In this situation, you can submit one PROC SQL step that does both of the following:

• creates a new table
• populates the table with data from the result of a PROC SQL query.

To create a table from a query result, use a CREATE TABLE statement that includes the keyword AS and the clauses that are used in a query: SELECT, FROM, and any optional clauses, such as ORDER BY.

General form, CREATE TABLE statement with query clauses: CREATE TABLE table-name AS SELECT column-1<, ... column-n> FROM table-1 | view-1<, ... table-n | view-n> <optional query ...