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 O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.