Examples | Frequency Analysis | Vantage Analytics Library - Examples - Vantage Analytics Library

Required Parameters Only

call td_analyze (
  'frequency',
  'database = val_source;
   tablename = customer;
   columns = years_with_bank;'
);

minimumpercentage

Computes only frequency values that occur at least 10% of the time.

call td_analyze (
  'frequency',
  'database = val_source;
   tablename = customer;
   columns = years_with_bank;
   minimumpercentage = 10;'
);

cumulativeoption, topvalues

Computes cumulative measures and only the top five frequency values.

call td_analyze (
  'frequency',
  'database = val_source;
   tablename = customer;
   columns = years_with_bank;
   cumulativeoption = true;
   topvalues = 5;'
);

style

Applies the crosstab option to two columns.

call td_analyze (
  'frequency',
  'database = val_source;
   tablename = customer;
   columns = gender, marital_status;
   style = crosstab;'
);

pairwise

Combines one pairwise column with two frequency columns.

call td_analyze (
  'frequency',
  'database = val_source;
   tablename = customer;
   columns = gender, marital_status;
   style = pairwise;
   pairwisecolumns = years_with_bank;'
);

statisticscolumns, Output Table

call td_analyze (
  'frequency',
  'database = val_source;
   tablename = customer;
   columns = gender;
   statisticscolumns = years_with_bank;
   outputdatabase = val_results;
   outputtablename = frequency;'
);

where, having

call td_analyze (
  'frequency',
  'database = val_source;
   tablename = customer;
   columns = years_with_bank;
   cumulativeoption = true;
   where = cust_id < 0;
   having = xpct > 1;'
);