Summary
Text Summary
Understanding Methods of Creating Tables
You can use the CREATE
TABLE statement to create a table in three different ways:
-
create a table with no rows (an empty table) by defining columns
-
create an empty table that is like another table
-
create a table that contains rows, based on a query result.
Creating an Empty Table By Defining Columns
You can create a table
with no rows by using a CREATE TABLE statement that contains column
specifications. A column specification includes the following elements:
column name (required), data type (required), column width (optional),
one or more column modifiers (optional), and a column constraint (optional).
Displaying the Structure of a Table
To display, in the ...
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.