SAS Certified Professional Prep Guide

Using the AS Keyword

AS Keyword Syntax

Suppose 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.

Syntax, 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 clauses>;