PROC SQL: Beyond the Basics Using SAS®

5.7. Summary

1. Creating a table using a column-definition list is similar to defining a table’s structure with the LENGTH statement in the DATA step (see section 5.2.1).

2. Using the LIKE clause copies the column names and attributes from the existing table structure to the new table structure (see section 5.2.2).

3. Deriving a table from an existing table stores the results in a new table instead of displaying them as SAS output (see section 5.2.3).

4. In populating a table, three parameters are specified with an INSERT INTO statement: the name of the table, the names of the columns in which values are inserted, and the values themselves (see section 5.3.1).

5. Database-enforced constraints can be applied to a database table structure to enforce the type and ...