Introducing SAS Integrity Constraints (Versions 7 and Later)
Starting with Version 7 of SAS software, a feature called integrity constraints was implemented. Integrity constraints are rules that are stored with a SAS data set that can restrict data values accepted into the data set when new data is added with PROC APPEND, DATA step MODIFY, and SQL insert, delete, or update. These constraints are preserved when the data set is copied using PROC COPY, CPORT, or CIMPORT or is sorted with PROC SORT.
Briefly, there are two types of integrity constraints. One type, called general integrity constraints, allows you to restrict data values that are added to a SAS data set. You can specify specific values for a variable, a range of values, or a requirement ...
Get Cody’s Data Cleaning Techniques Using SAS® Software 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.
