Required Parameters Only
Returns result set, which cannot be subsequently scored.
call td_analyze ( 'factor', 'database = val_source; tablename = customer; columns = age, years_with_bank, nbr_children;' );
Return Reports in Output Table
Returns output table, which can be subsequently scored.
call td_analyze ( 'factor', 'database = val_source; tablename = customer; columns = age, years_with_bank, nbr_children;' outputdatabase = val_results; outputtablename = myFactorOutput;' );
Show output table:
SELECT * FROM val_results.myFactorOutput;
Return Near Dependency Report
Threshold values are unrealistic but produce results with this data.
call td_analyze ( 'factor', 'database = val_source; tablename = customer; columns = age, years_with_bank, nbr_children;' neardependencyreport = true; conditionindexthreshold = 3; varianceproportionthreshold = .3;' );
Return Reports in Output Table with Two groupby Columns
Output table has one row for each group by column combination.
call td_analyze ( 'factor', 'database = val_source; tablename = customer; columns = age, years_with_bank, nbr_children;' outputdatabase = val_results; outputtablename = myFactorOutputGB; groupby = gender, marital_status;' );
Show output table:
SELECT * FROM val_results.myFactorOutputGB;
Build Matrix and Do Factor Analysis
Factor Analysis uses subset of matrix columns.
Build matrix:
call td_analyze ( 'matrix', 'matrixtype = esscp; database = val_source; tablename = customer; columns = age, years_with_bank, nbr_children, nbr_children; outputdatabase = val_results; outputtablename = matrix1;' );
Show output table:
SELECT * FROM val_results.matrix1 ORDER BY rownum;
Do factor analysis:
call td_analyze ( 'factor', 'matrixinput = true; database = val_results; tablename = matrix1; columns = age, years_with_bank, nbr_children;' );
Build Matrix with groupby Column and Do Factor Analysis
Build matrix:
call td_analyze ( 'matrix', 'matrixtype = esscp; database = val_source; tablename = customer; columns = income, age, age, nbr_children; outputdatabase = val_results; outputtablename = matrix1GB; groupby = gender;' );
Show output table:
SELECT * FROM val_results.matrix1GB ORDER BY gender, rownum;
Do factor analysis:
call td_analyze ( 'factor', 'matrixinput = true; database = val_results; tablename = matrix1GB; columns = age, years_with_bank, nbr_children; groupby = gender;' );
Factor Analysis with Varimax Rotation
call td_analyze ( 'factor', 'database = val_source; tablename = customer; columns = age, years_with_bank, nbr_children; rotationtype = varimax;' );
Factor Analysis with Prime Factor Variables Report
call td_analyze ( 'factor', 'database = val_source; tablename = customer; columns = age, years_with_bank, nbr_children; flr = true; fvr = true; thresholdpercent = 0.9; fvlr = true;' );