SAS Certification Prep Guide, 4th Edition

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 ...