Examples | Design Code Function | Vantage Analytics Library - Examples - Vantage Analytics Library

No DATE Columns or NULL Value Replacement

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = customer;
   designcode =
     {designstyle (dummycode), designvalues (M,F), columns (gender)}
     {designstyle (contrastcode, M), designvalues (F/female), columns (gender/gen)}
     {designstyle (contrastcode, M), designvalues (F), columns (gender/gen2)}
     {designstyle (contrastcode, M), designvalues (F), columns (gender/gen3)};'
);

DATE Columns

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = credit_acct;
   designcode =
     {designstyle (dummycode), designvalues (DATE 1995-12-21), columns (acct_start_date)}
     {designstyle (contrastcode, DATE 1995-12-21), designvalues (DATE 1995-12-23/d2, DATE 1995-12-26/d3), columns (acct_start_date/sdate)};'
);

NULL Value Replacement

keycolumns is required.

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = customer;
   keycolumns = cust_id;
   designcode =
     designstyle (dummycode), designvalues (M, F), nullstyle (literal, ''U''), columns (gender);'
);