Examples | Histogram | Vantage Analytics Library - Examples - Vantage Analytics Library

Required Parameters Only

Creates 10 equal-width bins by default.

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

Output Table, bins

Creates a result table with 5 equal width bins.

call td_analyze (
  'histogram',
  'database = val_source;
   tablename = customer;
   columns = income;
   bins = 5;
   outputdatabase = val_results;
   outputtablename = histogram;'
);

overlaycolumns

call td_analyze (
  'histogram',
  'database = val_source;
   tablename = customer;
   columns = income, age;'
   overlaycolumns = gender;'
);

statisticscolumns

call td_analyze (
  'histogram',
  'database = val_source;
   tablename = customer;
   columns = income, age;'
   statisticscolumns = years_with_bank;'
);

style

call td_analyze (
  'histogram',
  'database = val_source;
   tablename = customer;
   columns = income, age;'
   style = crosstab;'
);

where

call td_analyze (
  'histogram',
  'database = val_source;
   tablename = customer;
   columns = income;
   where = income > 0;'
);

widths

call td_analyze (
  'histogram',
  'database = val_source;
   tablename = customer;
   columns = income;
   widths = 25000;'
);

quantiles

call td_analyze (
  'histogram',
  'database = val_source;
   tablename = customer;
   columns = income;
   quantiles = 4;'
);

boundaries

call td_analyze (
  'histogram',
  'database = val_source;
   tablename = customer;
   columns = income;
   boundaries = 0, 50000, 100000, 150000;'
);

binwithminmax

call td_analyze (
  'histogram',
  'database = val_source;
   tablename = customer;
   columns = income;
   binwithminmax = 10, 0, 200000;'
);