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>;
table-name
specifies the name
of the table to be created.
SELECT
specifies the columns
that will appear in the table.
FROM
specifies the tables
or views to be queried.
optional query clauses
are used to refine
the query further and include WHERE, GROUP BY, HAVING, and ORDER BY.
|
TA
.proc sql; create table work.ticketagents as select lastname, firstname, jobcode, salary from certadv.payrollmaster, certadv.staffmaster where payrollmaster.empid = staffmaster.empid and jobcode contains 'TA'; quit;
proc sql; select * from work.ticketagents; quit;
NOTE: Table WORK.TICKETAGENTS created, with 41 rows and 4 columns.
3.142.42.33