Association Rule Mining Action Set: Syntax
Provides actions for association rule mining
mbanalysis Action
Performs rule generation for market basket analysis.
CASL Syntax
Summary: Input and Output Tables
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
— |
specifies one or more hierarchy tables. If you omit this parameter, then the mbanalysis action performs simple association analysis without a hierarchy. You can specify up to five tables; each table specifies one level of the hierarchy. | |
|
required parametertable |
— |
specifies the settings for an input table. |
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
— |
specifies the table to contain frequent item sets to generate rules. This output table also includes transaction counts and support. | |
|
— |
specifies the table to contain the unique frequent items along with their transaction counts and support. | |
|
— |
specifies the table to contain the rules. This output table includes variables that identify the left-hand and right-hand sides of the rule, the support, and the lift. | |
|
— |
specifies the table in which to save the model for future scoring. |
Parameter Descriptions
antecedentList={"string-1" <, "string-2", ...>}
specifies the regular expression strings to match in the antecedent (left-hand side) of a rule.
conf=double
specifies the minimum confidence for the rules.
| Default | 50 |
|---|---|
| Range | 0–100 |
consequentList={"string-1" <, "string-2", ...>}
specifies the regular expression strings to match in the consequent (right-hand side) of a rule.
hierarchy={{castable-1} <, {castable-2}, ...>}
specifies one or more hierarchy tables. If you omit this parameter, then the mbanalysis action performs simple association analysis without a hierarchy. You can specify up to five tables; each table specifies one level of the hierarchy.
For more information about specifying the hierarchy parameter, see the common castable parameter (Appendix A: Common Parameters).
* idVariable="variable-name"
specifies variable that is used to group the target variable into baskets.
items=integer
specifies the number of items in a rule. The default value is 2 when either the out parameter or outrule parameter is specified and 1 otherwise.
| Default | 2 |
|---|---|
| Range | 1–1000 |
lift=double
specifies the minimum lift value necessary to generate a rule.
| Default | 1 |
|---|---|
| Range | 0–100 |
maxItems=integer
specifies a maximum basket size, such that baskets larger than the specified value are rejected.
| Default | 1000 |
|---|---|
| Range | 0–1000 |
minItems=integer
specifies a minimum basket size, such that baskets smaller than the specified value are rejected.
| Default | 1 |
|---|---|
| Range | 0–20 |
nLHS_range={nLHSRHSOpts}
The nLHSRHSOpts value can be one or more of the following:
* lower=integer
specifies the minimum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1 |
|---|---|
| Range | 1–1000 |
* upper=integer
specifies the maximum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1000 |
|---|---|
| Range | 1–1000 |
norm=TRUE | FALSE
when set to True, normalizes the values of the target variable and the items in the out tables.
| Default | FALSE |
|---|
nRHS_range={nLHSRHSOpts}
The nLHSRHSOpts value can be one or more of the following:
* lower=integer
specifies the minimum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1 |
|---|---|
| Range | 1–1000 |
* upper=integer
specifies the maximum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1000 |
|---|---|
| Range | 1–1000 |
out={casouttable}
specifies the table to contain frequent item sets to generate rules. This output table also includes transaction counts and support.
For more information about specifying the out parameter, see the common casouttable parameter (Appendix A: Common Parameters).
outfreq={casouttable}
specifies the table to contain the unique frequent items along with their transaction counts and support.
For more information about specifying the outfreq parameter, see the common casouttable parameter (Appendix A: Common Parameters).
outrule={casouttable}
specifies the table to contain the rules. This output table includes variables that identify the left-hand and right-hand sides of the rule, the support, and the lift.
For more information about specifying the outrule parameter, see the common casouttable parameter (Appendix A: Common Parameters).
saveState={casouttable}
specifies the table in which to save the model for future scoring.
For more information about specifying the saveState parameter, see the common casouttable parameter (Appendix A: Common Parameters).
separator="string"
specifies the separator character in the antecedent (left-hand side) or the consequent (right-hand side) of a rule. The default value is "&".
sup_lift=double
specifies the minimum support lift necessary to generate a rule.
| Default | 0 |
|---|
supmin=double
specifies the minimum level of support for a rule. This represents the minimum allowable frequency of an item. This parameter overrides the suppct parameter.
| Minimum value | 0 |
|---|
suppct=double
specifies the minimum level of support for a rule as a percentage of the number of baskets in the input data table.
| Range | 0–100 |
|---|
* table={castable}
specifies the settings for an input table.
For more information about specifying the table parameter, see the common castable parameter (Appendix A: Common Parameters).
* tgtVariable="variable-name"
specifies a single nominal variable to use as the target variable. If this variable is not present in the data table that is specified in the table parameter, then the action exits with an error.
mbanalysis Action
Performs rule generation for market basket analysis.
Lua Syntax
Summary: Input and Output Tables
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
— |
specifies one or more hierarchy tables. If you omit this parameter, then the mbanalysis action performs simple association analysis without a hierarchy. You can specify up to five tables; each table specifies one level of the hierarchy. | |
|
required parametertable |
— |
specifies the settings for an input table. |
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
— |
specifies the table to contain frequent item sets to generate rules. This output table also includes transaction counts and support. | |
|
— |
specifies the table to contain the unique frequent items along with their transaction counts and support. | |
|
— |
specifies the table to contain the rules. This output table includes variables that identify the left-hand and right-hand sides of the rule, the support, and the lift. | |
|
— |
specifies the table in which to save the model for future scoring. |
Parameter Descriptions
antecedentList={"string-1" <, "string-2", ...>}
specifies the regular expression strings to match in the antecedent (left-hand side) of a rule.
conf=double
specifies the minimum confidence for the rules.
| Default | 50 |
|---|---|
| Range | 0–100 |
consequentList={"string-1" <, "string-2", ...>}
specifies the regular expression strings to match in the consequent (right-hand side) of a rule.
hierarchy={{castable-1} <, {castable-2}, ...>}
specifies one or more hierarchy tables. If you omit this parameter, then the mbanalysis action performs simple association analysis without a hierarchy. You can specify up to five tables; each table specifies one level of the hierarchy.
For more information about specifying the hierarchy parameter, see the common castable parameter (Appendix A: Common Parameters).
* idVariable="variable-name"
specifies variable that is used to group the target variable into baskets.
items=integer
specifies the number of items in a rule. The default value is 2 when either the out parameter or outrule parameter is specified and 1 otherwise.
| Default | 2 |
|---|---|
| Range | 1–1000 |
lift=double
specifies the minimum lift value necessary to generate a rule.
| Default | 1 |
|---|---|
| Range | 0–100 |
maxItems=integer
specifies a maximum basket size, such that baskets larger than the specified value are rejected.
| Default | 1000 |
|---|---|
| Range | 0–1000 |
minItems=integer
specifies a minimum basket size, such that baskets smaller than the specified value are rejected.
| Default | 1 |
|---|---|
| Range | 0–20 |
nLHS_range={nLHSRHSOpts}
The nLHSRHSOpts value can be one or more of the following:
* lower=integer
specifies the minimum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1 |
|---|---|
| Range | 1–1000 |
* upper=integer
specifies the maximum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1000 |
|---|---|
| Range | 1–1000 |
norm=true | false
when set to True, normalizes the values of the target variable and the items in the out tables.
| Default | false |
|---|
nRHS_range={nLHSRHSOpts}
The nLHSRHSOpts value can be one or more of the following:
* lower=integer
specifies the minimum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1 |
|---|---|
| Range | 1–1000 |
* upper=integer
specifies the maximum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1000 |
|---|---|
| Range | 1–1000 |
out={casouttable}
specifies the table to contain frequent item sets to generate rules. This output table also includes transaction counts and support.
For more information about specifying the out parameter, see the common casouttable parameter (Appendix A: Common Parameters).
outfreq={casouttable}
specifies the table to contain the unique frequent items along with their transaction counts and support.
For more information about specifying the outfreq parameter, see the common casouttable parameter (Appendix A: Common Parameters).
outrule={casouttable}
specifies the table to contain the rules. This output table includes variables that identify the left-hand and right-hand sides of the rule, the support, and the lift.
For more information about specifying the outrule parameter, see the common casouttable parameter (Appendix A: Common Parameters).
saveState={casouttable}
specifies the table in which to save the model for future scoring.
For more information about specifying the saveState parameter, see the common casouttable parameter (Appendix A: Common Parameters).
separator="string"
specifies the separator character in the antecedent (left-hand side) or the consequent (right-hand side) of a rule. The default value is "&".
sup_lift=double
specifies the minimum support lift necessary to generate a rule.
| Default | 0 |
|---|
supmin=double
specifies the minimum level of support for a rule. This represents the minimum allowable frequency of an item. This parameter overrides the suppct parameter.
| Minimum value | 0 |
|---|
suppct=double
specifies the minimum level of support for a rule as a percentage of the number of baskets in the input data table.
| Range | 0–100 |
|---|
* table={castable}
specifies the settings for an input table.
For more information about specifying the table parameter, see the common castable parameter (Appendix A: Common Parameters).
* tgtVariable="variable-name"
specifies a single nominal variable to use as the target variable. If this variable is not present in the data table that is specified in the table parameter, then the action exits with an error.
mbanalysis Action
Performs rule generation for market basket analysis.
Python Syntax
Summary: Input and Output Tables
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
— |
specifies one or more hierarchy tables. If you omit this parameter, then the mbanalysis action performs simple association analysis without a hierarchy. You can specify up to five tables; each table specifies one level of the hierarchy. | |
|
required parametertable |
— |
specifies the settings for an input table. |
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
— |
specifies the table to contain frequent item sets to generate rules. This output table also includes transaction counts and support. | |
|
— |
specifies the table to contain the unique frequent items along with their transaction counts and support. | |
|
— |
specifies the table to contain the rules. This output table includes variables that identify the left-hand and right-hand sides of the rule, the support, and the lift. | |
|
— |
specifies the table in which to save the model for future scoring. |
Parameter Descriptions
antecedentList=["string-1" <, "string-2", ...>]
specifies the regular expression strings to match in the antecedent (left-hand side) of a rule.
conf=double
specifies the minimum confidence for the rules.
| Default | 50 |
|---|---|
| Range | 0–100 |
consequentList=["string-1" <, "string-2", ...>]
specifies the regular expression strings to match in the consequent (right-hand side) of a rule.
hierarchy=[{castable-1} <, {castable-2}, ...>]
specifies one or more hierarchy tables. If you omit this parameter, then the mbanalysis action performs simple association analysis without a hierarchy. You can specify up to five tables; each table specifies one level of the hierarchy.
For more information about specifying the hierarchy parameter, see the common castable parameter (Appendix A: Common Parameters).
* idVariable="variable-name"
specifies variable that is used to group the target variable into baskets.
items=integer
specifies the number of items in a rule. The default value is 2 when either the out parameter or outrule parameter is specified and 1 otherwise.
| Default | 2 |
|---|---|
| Range | 1–1000 |
lift=double
specifies the minimum lift value necessary to generate a rule.
| Default | 1 |
|---|---|
| Range | 0–100 |
maxItems=integer
specifies a maximum basket size, such that baskets larger than the specified value are rejected.
| Default | 1000 |
|---|---|
| Range | 0–1000 |
minItems=integer
specifies a minimum basket size, such that baskets smaller than the specified value are rejected.
| Default | 1 |
|---|---|
| Range | 0–20 |
nLHS_range={nLHSRHSOpts}
The nLHSRHSOpts value can be one or more of the following:
* "lower":integer
specifies the minimum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1 |
|---|---|
| Range | 1–1000 |
* "upper":integer
specifies the maximum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1000 |
|---|---|
| Range | 1–1000 |
norm=True | False
when set to True, normalizes the values of the target variable and the items in the out tables.
| Default | False |
|---|
nRHS_range={nLHSRHSOpts}
The nLHSRHSOpts value can be one or more of the following:
* "lower":integer
specifies the minimum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1 |
|---|---|
| Range | 1–1000 |
* "upper":integer
specifies the maximum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1000 |
|---|---|
| Range | 1–1000 |
out={casouttable}
specifies the table to contain frequent item sets to generate rules. This output table also includes transaction counts and support.
For more information about specifying the out parameter, see the common casouttable parameter (Appendix A: Common Parameters).
outfreq={casouttable}
specifies the table to contain the unique frequent items along with their transaction counts and support.
For more information about specifying the outfreq parameter, see the common casouttable parameter (Appendix A: Common Parameters).
outrule={casouttable}
specifies the table to contain the rules. This output table includes variables that identify the left-hand and right-hand sides of the rule, the support, and the lift.
For more information about specifying the outrule parameter, see the common casouttable parameter (Appendix A: Common Parameters).
saveState={casouttable}
specifies the table in which to save the model for future scoring.
For more information about specifying the saveState parameter, see the common casouttable parameter (Appendix A: Common Parameters).
separator="string"
specifies the separator character in the antecedent (left-hand side) or the consequent (right-hand side) of a rule. The default value is "&".
sup_lift=double
specifies the minimum support lift necessary to generate a rule.
| Default | 0 |
|---|
supmin=double
specifies the minimum level of support for a rule. This represents the minimum allowable frequency of an item. This parameter overrides the suppct parameter.
| Minimum value | 0 |
|---|
suppct=double
specifies the minimum level of support for a rule as a percentage of the number of baskets in the input data table.
| Range | 0–100 |
|---|
* table={castable}
specifies the settings for an input table.
For more information about specifying the table parameter, see the common castable parameter (Appendix A: Common Parameters).
* tgtVariable="variable-name"
specifies a single nominal variable to use as the target variable. If this variable is not present in the data table that is specified in the table parameter, then the action exits with an error.
mbanalysis Action
Performs rule generation for market basket analysis.
R Syntax
Summary: Input and Output Tables
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
— |
specifies one or more hierarchy tables. If you omit this parameter, then the mbanalysis action performs simple association analysis without a hierarchy. You can specify up to five tables; each table specifies one level of the hierarchy. | |
|
required parametertable |
— |
specifies the settings for an input table. |
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
— |
specifies the table to contain frequent item sets to generate rules. This output table also includes transaction counts and support. | |
|
— |
specifies the table to contain the unique frequent items along with their transaction counts and support. | |
|
— |
specifies the table to contain the rules. This output table includes variables that identify the left-hand and right-hand sides of the rule, the support, and the lift. | |
|
— |
specifies the table in which to save the model for future scoring. |
Parameter Descriptions
antecedentList=list("string-1" <, "string-2", ...>)
specifies the regular expression strings to match in the antecedent (left-hand side) of a rule.
conf=double
specifies the minimum confidence for the rules.
| Default | 50 |
|---|---|
| Range | 0–100 |
consequentList=list("string-1" <, "string-2", ...>)
specifies the regular expression strings to match in the consequent (right-hand side) of a rule.
hierarchy=list( list(castable-1) <, list(castable-2), ...>)
specifies one or more hierarchy tables. If you omit this parameter, then the mbanalysis action performs simple association analysis without a hierarchy. You can specify up to five tables; each table specifies one level of the hierarchy.
For more information about specifying the hierarchy parameter, see the common castable parameter (Appendix A: Common Parameters).
* idVariable="variable-name"
specifies variable that is used to group the target variable into baskets.
items=integer
specifies the number of items in a rule. The default value is 2 when either the out parameter or outrule parameter is specified and 1 otherwise.
| Default | 2 |
|---|---|
| Range | 1–1000 |
lift=double
specifies the minimum lift value necessary to generate a rule.
| Default | 1 |
|---|---|
| Range | 0–100 |
maxItems=integer
specifies a maximum basket size, such that baskets larger than the specified value are rejected.
| Default | 1000 |
|---|---|
| Range | 0–1000 |
minItems=integer
specifies a minimum basket size, such that baskets smaller than the specified value are rejected.
| Default | 1 |
|---|---|
| Range | 0–20 |
nLHS_range=list(nLHSRHSOpts)
The nLHSRHSOpts value can be one or more of the following:
* lower=integer
specifies the minimum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1 |
|---|---|
| Range | 1–1000 |
* upper=integer
specifies the maximum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1000 |
|---|---|
| Range | 1–1000 |
norm=TRUE | FALSE
when set to True, normalizes the values of the target variable and the items in the out tables.
| Default | FALSE |
|---|
nRHS_range=list(nLHSRHSOpts)
The nLHSRHSOpts value can be one or more of the following:
* lower=integer
specifies the minimum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1 |
|---|---|
| Range | 1–1000 |
* upper=integer
specifies the maximum number of items in the left-hand side or right-hand side (LHS/RHS) of a rule.
| Default | 1000 |
|---|---|
| Range | 1–1000 |
out=list(casouttable)
specifies the table to contain frequent item sets to generate rules. This output table also includes transaction counts and support.
For more information about specifying the out parameter, see the common casouttable parameter (Appendix A: Common Parameters).
outfreq=list(casouttable)
specifies the table to contain the unique frequent items along with their transaction counts and support.
For more information about specifying the outfreq parameter, see the common casouttable parameter (Appendix A: Common Parameters).
outrule=list(casouttable)
specifies the table to contain the rules. This output table includes variables that identify the left-hand and right-hand sides of the rule, the support, and the lift.
For more information about specifying the outrule parameter, see the common casouttable parameter (Appendix A: Common Parameters).
saveState=list(casouttable)
specifies the table in which to save the model for future scoring.
For more information about specifying the saveState parameter, see the common casouttable parameter (Appendix A: Common Parameters).
separator="string"
specifies the separator character in the antecedent (left-hand side) or the consequent (right-hand side) of a rule. The default value is "&".
sup_lift=double
specifies the minimum support lift necessary to generate a rule.
| Default | 0 |
|---|
supmin=double
specifies the minimum level of support for a rule. This represents the minimum allowable frequency of an item. This parameter overrides the suppct parameter.
| Minimum value | 0 |
|---|
suppct=double
specifies the minimum level of support for a rule as a percentage of the number of baskets in the input data table.
| Range | 0–100 |
|---|
* table=list(castable)
specifies the settings for an input table.
For more information about specifying the table parameter, see the common castable parameter (Appendix A: Common Parameters).
* tgtVariable="variable-name"
specifies a single nominal variable to use as the target variable. If this variable is not present in the data table that is specified in the table parameter, then the action exits with an error.