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 ... |
Get SAS Certification Prep Guide, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
