SAS Certification Prep Guide, 4th Edition

Creating Output Tables

Overview

To create a new table from the results of a query, use a CREATE TABLE statement that includes the keyword AS and the clauses that are used in a PROC SQL query: SELECT, FROM, and any optional clauses, such as ORDER BY. The CREATE TABLE statement stores your query results in a table instead of displaying the results as a report.

General form, basic PROC SQL step for creating a table from a query result: PROC SQL; CREATE TABLE table-name AS SELECT column-1<,...column-n> FROM table-1|view-1<,...table-n|view-n> <WHERE expression> <GROUP BY column-1<,... column-n>> <ORDER BY column-1<,... column-n>>; Here is an explanation of the syntax: table-name specifies the name of the table to be created.