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 integrity constraints on the Capinfo data set: 
proc datasets;
    modify capinfo;
    ic delete pkidinfo;
    ic delete class1;
 quit;
A message is written to the SAS log when the integrity constraint is deleted.
Table 18.3 SAS Log 
53      modify capinfo;
54      ic delete pkidinfo;
NOTE: Integrity constraint PKIDInfo deleted.
55      ic delete class1;
NOTE: All integrity constraints defined on WORK.CAPINFO.DATA 
      have been deleted.
56   run;NOTE: Integrity constraint PKIDInfo deleted.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.141.30.210