Standardlookup

The Standardlookup data set provides a mechanism to capture valid values for discrete variables in the SAS Clinical Standards Toolkit metadata files. This data set supports such tasks as validating the content of SAS Clinical Standards Toolkit metadata files and providing selectable values in the user interfaces of other tools and solutions.

Standardlookup Data Set Structure in the Global Standards Library

Column Name	Column Length	Description
sasref	($8)	SAS libref
table	($32)	A SAS Clinical Standards Toolkit table name
column	($32)	A SAS Clinical Standards Toolkit column name
refcolumn	($32)	Associated SAS Clinical Standards Toolkit column name
refvalue	($200)	Associated SAS Clinical Standards Toolkit column value
value	($200)	Unique SAS Clinical Standards Toolkit column value
default	($200)	Default SAS Clinical Standards Toolkit column value
nonnull	($1)	Value that specifies whether a SAS Clinical Standards Toolkit column value must be non-null
order	(8.)	A SAS Clinical Standards Toolkit column value order
comment	($200)	Explanatory comments

A Standardlookup data set is provided for most standards with the SAS Clinical Standards Toolkit. This data set can be used to define and register custom standards in the SAS Clinical Standards Toolkit.

An example of the Standardlookup data set can be found at:

<global standards library directory>/standards/cst-framework/control/standardlookup.sas7bdat

An example of the records in a Standardlookup data set is provided in the following figure:

Standardlookup Data Set Content in the Global Standards Library

These records show that the SASReferences data set allows a value of referencemetadata for the type column. The type value in a SASReferences data set must always be non-null. Two subtype values (table and column) are allowed when type is referencemetadata. For more information about the columns and values in the SASReferences data set, see the following section.