Creating a Table That Has Integrity Constraints
Overview
Integrity constraints are rules that you can specify
in order to restrict the data values that can be stored for a column
in a table. SAS enforces integrity constraints when values associated
with a column are added, updated, or deleted. Integrity constraints
help you preserve the validity and consistency of your data.
You can
create integrity constraints by using either PROC SQL or PROC DATASETS.
PROC DATASETS can assign constraints only to an existing table. PROC
SQL can assign constraints either as it creates a new table or as
it modifies an existing table. This chapter discusses the use of PROC
SQL to Create integrity constraints while creating a table.
Note: To learn more about ...
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.
