Creates PROC SQL tables.
See: | Creating a Table and Inserting Data into It |
Creating a Table from a Query's Result |
is one of the following:
specifies that all rows in table-name satisfy the WHERE-clause.
specifies that the values of the column must be unique. This constraint is identical to UNIQUE.
specifies that the column does not contain a null or missing value, including special missing values.
specifies that the column is a primary key column, that is, a column that does not contain missing values and whose values are unique.
Restriction | When defining overlapping primary key and foreign key constraints, the variables in a data file are part of both a primary key and a foreign key definition. If you use the exact same variables, then the variables must be defined in a different order. |
specifies that the column is a foreign key, that is, a column whose values are linked to the values of the primary key variable in another table (the table-name that is specified for REFERENCES). The referential-actions are performed when the values of a primary key column that is referenced by the foreign key are updated or deleted.
Restriction | When you are defining overlapping primary key and foreign key constraints, the variables in a data file are part of both a primary key definition and a foreign key definition. If you use the exact same variables, then the variables must be defined in a different order. The foreign key's update and delete referential actions must both be RESTRICT. |
consists of
is one of the following:
specifies that all rows in table-name satisfy the WHERE-clause.
specifies that the values of each column must be unique. This constraint is identical to UNIQUE.
specifies a foreign key, that is, a set of columns whose values are linked to the values of the primary key variable in another table (the table-name that is specified for REFERENCES). The referential-actions are performed when the values of a primary key column that is referenced by the foreign key are updated or deleted.
Restriction | When you are defining overlapping primary key and foreign key constraints, the variables in a data file are part of both a primary key definition and a foreign key definition. If you use the exact same variables, then the variables must be defined in a different order. The foreign key's update and delete referential actions must both be RESTRICT. |
specifies that column does not contain a null or missing value, including special missing values.
specifies one or more primary key columns, that is, columns that do not contain missing values and whose values are unique.
Restriction | When defining overlapping primary key and foreign key constraints, the variables in a data file are part of both a primary key and a foreign key definition. If you use the exact same variables, then the variables must be defined in a different order. |
specifies that the values of each column must be unique. This constraint is identical to DISTINCT.
consists of
specifies the text of an error message that is written to the log when the integrity constraint is not met. The maximum length of message-string is 250 characters.
sorts the rows in table-name by the values of each order-by-item. See ORDER BY Clause.
creates table-name from the results of a query. See query-expression.
specifies the type of action to be performed on all matching foreign key values.
allows primary key data values to be updated, and updates matching values in the foreign key to the same values. This referential action is currently supported for updates only.
occurs only if there are matching foreign key values. This referential action is the default.
sets all matching foreign key values to NULL.
creates table-name with the same column names and column attributes as table-name2, but with no rows.
specifies a SAS WHERE clause. Do not include the WHERE keyword in the WHERE clause.