Examples | Statistical Analysis | Vantage Analytics Library - Examples - Vantage Analytics Library

Required Parameters Only

Calculates count, min, max, mean, and standard deviation.

call td_analyze (
  'statistics',
  'database = val_source;
   tablename = customer;
   columns = income;'
);

Output Table, groupby, where

call td_analyze (
  'statistics',
  'database = val_source;
   tablename = customer;
   columns = income;
   outputdatabase = val_results;
   outputtablename = statistics;
   groupby = gender;
   where = income > 0;'
);

All Statistical Measures, Extended Options

call td_analyze (
  'statistics',
  'database = val_source;
   tablename = customer;
   columns = income;
   statsoptions = all;
   extendedoptions = all;'
);

Selected Statistical Measures, Extended Options, Return Sample Statistic

call td_analyze (
  'statistics',
  'database = val_source;
   tablename = customer;
   columns = income;
   statsoptions = all;
   extendedoptions = modes;
   statisticalmethod = sample;'
);