SAS Certification Prep Guide, 4th Edition

Removing Integrity Constraints

Overview

To remove an integrity constraint from a data set, use the DATASETS procedure with the IC DELETE statement.

General form, DATASETS procedure with the IC DELETE statement: PROC DATASETS LIB=libref <NOLIST>; MODIFY SAS-data-set; IC DELETE constraint-name; QUIT; Here is an explanation of the syntax: libref is the name of the library in which the data set is stored. If you do not specify the LIB= option, the procedure uses the Work library. NOLIST suppresses the directory listing. SAS-data-set is the name of the data set that has the integrity constraint. constraint-name is the name of the integrity constraint that you want to delete.

Example

The code below removes the ...