SAS Component Language Dictionary |
Category: | SAS Table |
Syntax | |
Details | |
Example | |
See Also |
Syntax |
icvalue=ICVALUE(table-id,icname); |
contains the names of one or more columns from the SAS table identified by table-id. When ictype is CHECK, icvalue returns the condition that values must meet.
contains the identifier for the SAS table, which is returned by the OPEN function.
Details |
ICVALUE returns the names of columns that are associated with the specified integrity constraint. If ictype is CHECK and is specified as a condition, then ICVALUE returns the condition that is assigned to the constraint.
Example |
Return the value of the UQ integrity constraint. If ICVALUE returns a blank, then display the error message. Because the constraint UQ (which was created in the example for ICCREATE) specified that columns D and E must contain unique values, COLLIST would contain D E.
tableid=open('mylib.one','i'); collist=icvalue(tableid,'uq'); if (collist=' ') then _msg_=sysmsg();
See Also |
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.