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 the 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
standard	($20)	The name of the registered standard.
standardversion	($20)	The version number of the registered standard. This must be unique within the standard.
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
templatetype	($8)	For the given record, a non-null value (for example, data set) indicates that a template is available. For example, the macro call `%cst_createdsfromtemplate( _cstStandard=CST-FRAMEWORK,_cstType=control,_cstSubType=reference,_cstOutputDS=work.sasreferences)` finds that a template is available as csttmplt.sasreferences.
template	($40)	The SAS reference (libref.dset or fileref) to the templatetype. For example, csttmplt.sasreferences points to `global standards library directory/standards/cst-framework-1.5/templates/sasreferences.sas7bdat`.
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 in the definition and registration of custom standards in the SAS Clinical Standards Toolkit.

The cross-standard global standards library Standardlookup data set that is provided with the SAS Clinical Standards Toolkit is located here:

global standards library directory/metadata/standardlookup.sas7bdat

This data set contains the concatenation of each Standardlookup data set that is provided for each supported standard in the SAS Clinical Standards Toolkit.

Here is an example of the records in a Standardlookup data set:

Standardlookup Data Set Content in the Global Standards Library

These records show the valid values for discrete columns in any SDTM 3.1.2 SASReferences (including StandardSASReferences) data set. For example, filetype can have values of CATALOG, DATASET, FILE, or FOLDER. These records also show that a SASReferences data set allows two subtype values (REFERENCE and VALIDATION) when type is CONTROL. When type is CONTROL, the subtype value must always be non-null.

Templates are available for both the SASReferences data set and the validation_master data sets. For more information about the columns and values in SASReferences data sets, see the following section.