Documenting Integrity Constraints

Overview

To view the descriptor portion of your data, including the integrity constraints that you have placed on a data set, you can use the CONTENTS statement in the DATASETS procedure.
General form, DATASETS procedure with the CONTENTS statement:
PROC DATASETS LIB=libref <NOLIST>;
CONTENTS DATA=SAS-data-set;
QUIT;
Here is an explanation of the syntax:
libref
is the library in which the data set is stored.
NOLIST
suppresses the directory listing.
SAS-data-set
is the name of the data set that you want information about.
Note: The CONTENTS statement in the DATASETS procedure results in the same information as the CONTENTS procedure.

Example

The following code displays information about the Capinfo data set, including the integrity constraints that were added to this data set in the last example. Notice that the NOLIST option is used here to suppress the listing of all data sets in the Work library. With this option, only the information for the Capinfo data set is listed.
proc datasets nolist;
   contents data=capinfo;
quit;
Only the integrity constraints portion of the output is shown below.
integrity constraints portion of the output
..................Content has been hidden....................

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