Examples | Bin Code | Vantage Analytics Library - Examples - Vantage Analytics Library

Bin Styles Applied to Numeric Columns

call td_analyze (
  'vartran,
  'database = val_source;
   tablename = customer_analysis;
   bincode =
     {binstyle (bins, 5), columns (cust_id/cid1, age/age1, income/inc1)}
     {binstyle (binswithboundaries, 5, 0, 100), columns (cust_id/cid2, age/age2, income/inc2)}
     {binstyle (boundaries, 0.0, 100.0, 200.00), columns (cust_id/cid3, age/age3, income/inc3)}
     {binstyle (quantiles, 5), columns (cust_id/cid5, age/age5, income/inc5)}
     {binstyle (width, 25), columns (cust_id/cid4, age/age4, income/inc4)};'
);

Bin Styles Applied to DATE Columns

The literal DATE is required, and cannot be enclosed in quotation marks.

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = credit_acct;
   bincode = 
     {binstyle (binswithboundaries, 5, DATE 1995-01-01, DATE 1995-12-31), columns (acct_start_date)}
     {binstyle (boundaries, DATE 1995-01-01, DATE 1995-07-01, DATE 1995-12-31), columns (acct_start_date/start2)};'
);

NULL Value Replacement

keycolumns is required.

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = customer;
   keycolumns = cust_id;
   bincode = binstyle (bins, 5), nullstyle (literal, 0), columns (income);'
);