DATASETS Procedure
- Syntax
Procedure SyntaxPROC DATASETS StatementAGE StatementAPPEND StatementATTRIB StatementAUDIT StatementCHANGE StatementCONTENTS StatementCOPY StatementDELETE StatementEXCHANGE StatementEXCLUDE StatementFORMAT StatementIC CREATE StatementIC DELETE StatementIC REACTIVATE StatementINDEX CENTILES StatementINDEX CREATE StatementINDEX DELETE StatementINFORMAT StatementLABEL StatementMODIFY StatementREBUILD StatementRENAME StatementREPAIR StatementSAVE StatementSELECT Statement - Overview
- Concepts
- Results
- Examples Removing All Labels and Formats in a Data SetManipulating SAS FilesSaving SAS Files from DeletionModifying SAS Data SetsDescribing a SAS Data SetConcatenating Two SAS Data SetsAging SAS Data SetsODS Output Getting Sort Indicator InformationUsing the ORDER= Option with the CONTENTS StatementInitiating an Audit File
IC REACTIVATE Statement
Reactivates a foreign key integrity constraint that
is inactive.
| Restriction: | Must be in a MODIFY RUN group |
| See: | Understanding Integrity Constraints in SAS Language Reference: Concepts |
Example
Suppose that you have
the foreign key FKEY defined in data set MYLIB.MYOWN and that FKEY
is linked to a primary key in data set MAINLIB.MAIN. If the integrity
constraint is inactivated by a copy or move operation, you can reactivate
the integrity constraint by using the following code:
proc datasets library=mylib; modify myown; ic reactivate fkey references mainlib; run;