Examples | Recode Function | Vantage Analytics Library - Examples - Vantage Analytics Library

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);'
);