Databases Reference
In-Depth Information
3
Click the browse button to the right of the
Lookup Table
field and select
CHECKING_TRANS_LOOKUP. Then click
OK
to return to the Data Validation
properties window.
Display 10.19
Invalid Values Window
4
To specify the name of the error table, click the
Options
tab. In the Error Table
row, enter the SAS libref and filename (rather than the metadata names) of the
error table, such as
ORGOLD.CHECKING_TRANS_ERROR
. Click
Apply
to store your
input.
5
To replace missing values, click the
Missing Values
tab, then click
New
. In the
Missing Values window, select the column CHKING_TRANS_CHANNEL_CD. In
the
Action if missing field
, select
Change value to
. In the New Value field,
type
"??"
, with quotation marks. Click
OK
to return to the properties window.
Display 10.20
Missing Values Window
6
To configure the detection of duplicate values, click the
Duplicate Values
tab.
Click
New
to display the Duplicate Values window. In the
Available Columns
list,
select CHKING_TRANS_ID, then click the arrow to move that column name into
the
Selected Columns
list.
Search WWH ::
Custom Search