10 Creating Integrity Constraints and Audit Trails
Introducing SAS Integrity Constraints
Demonstrating General Integrity Constraints
Deleting an Integrity Constraint Using PROC DATASETS
Creating an Audit Trail Data Set
Demonstrating an Integrity Constraint Involving More than One Variable
Demonstrating a Referential Constraint
Attempting to Delete a Primary Key When a Foreign Key Still Exists
Attempting to Add a Name to the Child Data Set
Demonstrating the Cascade Feature of a Referential Constraint
Demonstrating the SET NULL Feature of a Referential Constraint
Demonstrating How to Delete a Referential Constraint
Introducing SAS Integrity Constraints
Starting with SAS 7, a feature called integrity constraints was implemented. Integrity constraints ...
Get Cody's Data Cleaning Techniques Using SAS, Second 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.
