Results

Each SAS Clinical Standards Toolkit process generates a Results data set. The Results data set can be persisted beyond the SAS session based on SASReferences data set settings. Each Results data set captures the outcome of specific process actions. Each Results data set uses the Messages data set to standardize output.

The structure of each SAS Clinical Standards Toolkit Results data set is described in this table.

Column Name

Column Length

Description

resultid

($8)

Result ID. The resultid is a message ID from the standard Messages data set (for example, framework or CDISC SDTM). The SAS Clinical Standards Toolkit has adopted a naming convention matching a resultid with each standard. The resultid values are prefixed with an up to 4-character prefix (CST for framework messaging; CDISC examples: ODM, SDTM, ADAM, and CRT). By convention, the prefix matches the mnemonic field in the Standards data set in global standards library directory/metadata. This prefix is followed by a 4-digit numeric that is unique within the standard (for example, SDTM1234). You can use any naming convention limited to eight characters.

Value should be non-null.

checkid

($8)

Validation check ID. The SAS Clinical Standards Toolkit has adopted a naming convention matching each standard to be validated. The checkid values are prefixed with an up to 4-character prefix (CDISC examples: ODM, SDTM, ADAM, and CRT). By convention, the prefix matches the mnemonic field in the Standards data set in global standards library directory/metadata. This prefix is followed by a 4-digit numeric that is unique within the standard (for example, SDTM1234). You can use any naming convention limited to eight characters.

Value should be non-null for validation processes. Otherwise, this column is optional.

resultseq

(8.)

Unique invocation of resultid. For validation processes, a sequence number to indicate the record number relative to checkid in the Validation Control run-time set of checks. If set to 1, then this is incremented only with each repeat invocation of a check. For non-validation processes, this value is generally a constant 1, but is reset to 1 with each new invocation of the SAS Clinical Standards Toolkit macro that is being run when the Results record is generated.

Value should be non-null positive integer.

seqno

(8.)

Sequence number relative to resultseq. This value is a unique sequence number for the Results record in each unique value of resultseq.

Value should be non-null positive integer.

srcdata

($200)

Source data. This string generally specifies:

(for validation) the domains evaluated or the check macro used
(otherwise) the SAS Clinical Standards Toolkit macro that is being run when the Results record is generated

Value should be non-null.

message

($500)

Resolved message text from Messages data set. The message value includes up to two run-time parameter values in message text.

Value should be non-null.

resultseverity

($40)

Result severity (for example, warning or error).

Info	Informational note
Note	Problem detected, low severity
Warning	Problem detected, medium severity
Warning: Check not run	No assessment able to be made
Warning: Check not completed	Full compliance assessment could not be made
Error	Problem detected, high severity

Value should be non-null.

resultflag

(8.)

A value that determines whether a problem has been detected. The values are 0=no, otherwise, yes.

-1	Validation check not run
0	No problem detected (value always 0 when resultseverity=Info)
1	Validation check run, error detected

Value should be non-null.

_cst_rc

(8.)

Process status. Values are nonzero and aborted. A nonzero value typically indicates that the process ended abnormally.

Value should be non-null.

actual

($240)

Actual value observed. This value is generally used for validation reporting. It provides the actual column values that are in error. This column is optional.

keyvalues

($2000)

Record-level keys and values. This value is generally used for validation reporting. It provides domain key values for records that are in error. This column is optional.

resultdetails

($200)

Basis or explanation for result. This column is optional.

For an example of a SAS Clinical Standards Toolkit Results data set, see Example of a Validation Results Data Set (#1) and Example of a Validation Results Data Set (#2).