Numeric Data
call td_analyze (
'vartran',
'database = val_source;
tablename = customer;
keycolumns = cust_id;
nullreplacement =
{nullstyle (literal, 0), columns (age, income/inc)}
{nullstyle (mean), columns (age/age1)}
{nullstyle (median), columns (age/age2)}
{nullstyle (medianwithoutaveraging), columns (age/age3)}
{nullstyle (mode), columns (age/age4)}
{nullstyle (imputed, customer_analysis), columns (income)};'
);
DATE and Character Data
call td_analyze (
'vartran',
'database = val_source;
tablename = customer;
keycolumns = cust_id;
nullreplacement =
{nullstyle (literal, DATE 1995-12-23), columns (acct_end_date/date1)}
{nullstyle (literal, U), columns (account_active/char1)}
{nullstyle (mean), columns (acct_end_date/date2)}
{nullstyle (median), columns (acct_end_date/date2A)}
{nullstyle (medianwithoutaveraging), columns (acct_end_date/date3)}
{nullstyle (mode), columns (acct_end_date/date4)}
{nullstyle (imputed, checking_acct), columns (acct_end_date/date5)}
{nullstyle (medianwithoutaveraging), columns (account_active/char2)}
{nullstyle (mode), columns (account_active/char3)}
{nullstyle (imputed, checking_acct), columns (account_active/char4)};');