Required Parameters Only
Produces an output table with the default name, _TWM_1_TO_1_AFFINITY.
call td_analyze ( 'association', 'database = val_source; tablename = credit_tran; groupcolumn = cust_id; itemcolumn = channel; outputdatabase = val_results; );
1-to-1 and 2-to-1 Analyses with Minimum Support
The where parameter eliminates rows with a blank channel column. The blank channel value requires double single quotes.
call td_analyze ( 'association', 'database = val_source; tablename = credit_tran; groupcolumn = cust_id; itemcolumn = channel; minimumsupport = 0.1; where = channel <> '' ''; combinations = 11,21; outputdatabase = val_results; outputtablename = example2_11, exmaple2_21;' );
Sequence Analysis with Minimum Support
call td_analyze ( 'association', 'database = val_source; tablename = credit_tran; groupcolumn = cust_id; itemcolumn = channel; sequencecolumn = tran_date; minimumsupport = 0.1; where = channel <> '' ''; outputdatabase = val_results; outputtablename = example3;' );