No DATE Columns or NULL Value Replacement
call td_analyze ( 'vartran', 'database = val_source; tablename = customer; recode = {recodevalues (M/SAME, F/f), recodeother (NULL), columns (gender)} {recodevalues (1/SAME, 2/NULL, 3/6, 4/4, NULL/NULL), recodeother (NULL), columns (marital_status)} {recodevalues (F/f, null/0), recodeother (same), columns (gender/gender2)} {recodevalues (0/0, 1/1, 2/1, 3/1, 4/1, 5/1), recodeother (0), columns (nbr_children, years_with_bank)};' );
DATE Columns
call td_analyze ( 'vartran', 'database = val_source; tablename = credit_acct; recode = {recodevalues (DATE 1995-01-05/DATE 2016-06-15, DATE 1995-12-26/SAME), recodeother (DATE 2016-01-01), columns (acct_start_date)} {recodevalues (DATE 1995-01-05/DATE 2016-06-15, DATE 1995-12-26/SAME), recodeother (NULL), columns (acct_start_date/start2)} {recodevalues (DATE 1995-01-05/DATE 2016-06-15, DATE 1995-12-26/SAME), recodeother (SAME), columns (acct_start_date/start3)};' );
NULL Value Replacement
keycolumns is required.
call td_analyze ( 'vartran', 'database = val_source; tablename = customer; keycolumns = cust_id; recode = recodevalues (0/0, 1/1, 2/1, 3/1, 4/1, 5/1), recodeother (0), nullstyle (literal, 0), columns (nbr_children, years_with_bank);' );