Examples | Z-Score Function | Vantage Analytics Library - Examples - Vantage Analytics Library

No NULL Value Replacement

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = customer;
   zscore = columns (age, income/inc), datatype (integer);'
);

NULL Value Replacement

keycolumns is required.

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = customer;
   keycolumns = cust_id;
   zscore = nullstyle (literal, 0), columns (age, income);'
);