Understanding Integrity Constraints
Overview
Now that you know how to modify data in place, you might
be wondering how you can protect or ensure the integrity of your data
when it is modified. Integrity constraints are rules that you can
specify in order to restrict the data values that can be stored for
a variable in a data set. SAS enforces integrity constraints when
values that are associated with a variable are added, updated, or
deleted using techniques that modify data in place, such as the following:
-
a DATA step with the MODIFY statement
-
an interactive data editing window
-
PROC SQL with the INSERT INTO, SET, or UPDATE statements
-
PROC APPEND
When you add an integrity constraint to the table that contains data, SAS ...
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.
