October 2019
Intermediate to advanced
430 pages
19h 4m
English
|
Method of Creating a
Table
|
Example
|
|---|---|
|
create an empty table
by defining columns
|
proc sql;
create table work.discount
(Destination char(3),
BeginDate num Format=date9.,
EndDate num format=date9.,
Discount num);
quit;
|
|
create an empty table
that is like (has the same columns and attributes as) an existing
table
|
proc sql; create table work.flightdelays2 like certadv.flightdelays; quit; |
|
create a populated table
(a table with both columns and rows of data) from a query result
|
proc sql;
create table work.ticketagents ... |