DOCUMENTATION
Sign In

Get access to My SAS, trials, communities and more.

SAS Visual Analytics Programming Guide
 
CASL
Lua
Python
R

Sequence Rule Mining Action Set: Syntax

Provides actions for sequence rule mining

seqmc Action

Performs sequence mining using a Monte Carlo sampling algorithm.

CASL Syntax

Expand allCollapse all
sequence.seqmc <result=results> <status=rc> /
casOut
={
caslib="string",
compress=TRUE | FALSE,
indexVars={"variable-name-1" <, "variable-name-2", ...>},
label="string",
lifetime=64-bit-integer,
maxMemSize=64-bit-integer,
memoryFormat="DVR" | "INHERIT" | "STANDARD",
name="table-name",
promote=TRUE | FALSE,
replace=TRUE | FALSE,
replication=integer,
tableRedistUpPolicy="DEFER" | "NOREDIST" | "REBALANCE",
threadBlockSize=64-bit-integer,
timeStamp="string",
where={"string-1" <, "string-2", ...>}
},
required parameter eventId="variable-name",
required parameter itemId="variable-name",
k=integer,
minSupport=double,
nSamples=64-bit-integer,
nSamplesToVerify=64-bit-integer,
seed=64-bit-integer,
required parameter sequenceId="variable-name",
supportCnt=64-bit-integer,
required parameter table
={
caslib="string",
computedOnDemand=TRUE | FALSE,
computedVars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
computedVarsProgram="string",
dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>},
groupBy
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
groupByMode="NOSORT" | "REDISTRIBUTE",
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters},
required parameter name="table-name",
orderBy
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
singlePass=TRUE | FALSE,
vars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
where="where-expression",
whereTable
={
casLib="string"
dataSourceOptions={adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | hadoop-parameters | hana-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | path-parameters | postgres-parameters | redshift-parameters | s3-parameters | sapiq-parameters | sforce-parameters | singlestore_standard-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | ss_noreq-parameters | teradata-parameters | vertica-parameters | yellowbrick-parameters}
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters}
required parameter name="table-name"
vars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}}
where="where-expression"
}
}
;
indicates a required parameter

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.

Parameters for Reading Input Tables

Parameter

Subparameter

Description

required parametertable

—

specifies the input table that contains input sequences for analysis.

Parameters for Creating Output Tables

Parameter

Subparameter

Description

 casOut

—

specifies the output table. The output table contains frequent sequences and the support of the frequent sequences.

Parameter Descriptions

casOut={casouttable}

specifies the output table. The output table contains frequent sequences and the support of the frequent sequences.

For more information about specifying the casOut parameter, see the common casouttable parameter.

* eventId="variable-name"

specifies the event or time column of the input table.

* itemId="variable-name"

specifies the item column of the input table.

k=integer

specifies the number of items in an output sequence.

Default1
Minimum value1

minSupport=double

specifies the minimum level of support for a sequence.

AliasminSup
Range0–1

nSamples=64-bit-integer

specifies the number of candidates to sample.

Default1000000
Minimum value1000

nSamplesToVerify=64-bit-integer

specifies the number of sample candidates to verify.

Default10000

seed=64-bit-integer

specifies the seed to use for random number generation.

Default0

* sequenceId="variable-name"

specifies the sequence or customer column of the input table.

supportCnt=64-bit-integer

specifies the minimum number of transactions that must occur for a sequence.

Aliassupcnt
Minimum value1

* table={castable}

specifies the input table that contains input sequences for analysis.

For more information about specifying the table parameter, see the common castable parameter.

seqmc Action

Performs sequence mining using a Monte Carlo sampling algorithm.

Lua Syntax

Expand allCollapse all
results, info = s:sequence_seqmc{
casOut
={
caslib="string",
compress=true | false,
indexVars={"variable-name-1" <, "variable-name-2", ...>},
label="string",
lifetime=64-bit-integer,
maxMemSize=64-bit-integer,
memoryFormat="DVR" | "INHERIT" | "STANDARD",
name="table-name",
promote=true | false,
replace=true | false,
replication=integer,
tableRedistUpPolicy="DEFER" | "NOREDIST" | "REBALANCE",
threadBlockSize=64-bit-integer,
timeStamp="string",
where={"string-1" <, "string-2", ...>}
},
required parameter eventId="variable-name",
required parameter itemId="variable-name",
k=integer,
minSupport=double,
nSamples=64-bit-integer,
nSamplesToVerify=64-bit-integer,
seed=64-bit-integer,
required parameter sequenceId="variable-name",
supportCnt=64-bit-integer,
required parameter table
={
caslib="string",
computedOnDemand=true | false,
computedVars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
computedVarsProgram="string",
dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>},
groupBy
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
groupByMode="NOSORT" | "REDISTRIBUTE",
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters},
required parameter name="table-name",
orderBy
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
singlePass=true | false,
vars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}},
where="where-expression",
whereTable
={
casLib="string"
dataSourceOptions={adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | hadoop-parameters | hana-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | path-parameters | postgres-parameters | redshift-parameters | s3-parameters | sapiq-parameters | sforce-parameters | singlestore_standard-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | ss_noreq-parameters | teradata-parameters | vertica-parameters | yellowbrick-parameters}
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters}
required parameter name="table-name"
vars
={{
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
}, {...}}
where="where-expression"
}
}
}
indicates a required parameter

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.

Parameters for Reading Input Tables

Parameter

Subparameter

Description

required parametertable

—

specifies the input table that contains input sequences for analysis.

Parameters for Creating Output Tables

Parameter

Subparameter

Description

 casOut

—

specifies the output table. The output table contains frequent sequences and the support of the frequent sequences.

Parameter Descriptions

casOut={casouttable}

specifies the output table. The output table contains frequent sequences and the support of the frequent sequences.

For more information about specifying the casOut parameter, see the common casouttable parameter.

* eventId="variable-name"

specifies the event or time column of the input table.

* itemId="variable-name"

specifies the item column of the input table.

k=integer

specifies the number of items in an output sequence.

Default1
Minimum value1

minSupport=double

specifies the minimum level of support for a sequence.

AliasminSup
Range0–1

nSamples=64-bit-integer

specifies the number of candidates to sample.

Default1000000
Minimum value1000

nSamplesToVerify=64-bit-integer

specifies the number of sample candidates to verify.

Default10000

seed=64-bit-integer

specifies the seed to use for random number generation.

Default0

* sequenceId="variable-name"

specifies the sequence or customer column of the input table.

supportCnt=64-bit-integer

specifies the minimum number of transactions that must occur for a sequence.

Aliassupcnt
Minimum value1

* table={castable}

specifies the input table that contains input sequences for analysis.

For more information about specifying the table parameter, see the common castable parameter.

seqmc Action

Performs sequence mining using a Monte Carlo sampling algorithm.

Python Syntax

Expand allCollapse all
results=s.sequence.seqmc(
casOut
={
"caslib":"string",
"compress":True | False,
"indexVars":["variable-name-1" <, "variable-name-2", ...>],
"label":"string",
"lifetime":64-bit-integer,
"maxMemSize":64-bit-integer,
"memoryFormat":"DVR" | "INHERIT" | "STANDARD",
"name":"table-name",
"promote":True | False,
"replace":True | False,
"replication":integer,
"tableRedistUpPolicy":"DEFER" | "NOREDIST" | "REBALANCE",
"threadBlockSize":64-bit-integer,
"timeStamp":"string",
"where":["string-1" <, "string-2", ...>]
},
required parameter eventId="variable-name",
required parameter itemId="variable-name",
k=integer,
minSupport=double,
nSamples=64-bit-integer,
nSamplesToVerify=64-bit-integer,
seed=64-bit-integer,
required parameter sequenceId="variable-name",
supportCnt=64-bit-integer,
required parameter table
={
"caslib":"string",
"computedOnDemand":True | False,
"computedVars"
:[{
"format":"string",
"formattedLength":integer,
"label":"string",
required parameter "name":"variable-name",
"nfd":integer,
"nfl":integer
}<, {...}>],
"computedVarsProgram":"string",
"dataSourceOptions":{"key-1":{any-list-or-data-type-1} <, "key-2":{any-list-or-data-type-2}, ...>},
"groupBy"
:[{
"format":"string",
"formattedLength":integer,
"label":"string",
required parameter "name":"variable-name",
"nfd":integer,
"nfl":integer
}<, {...}>],
"groupByMode":"NOSORT" | "REDISTRIBUTE",
"importOptions":{"fileType":"ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters},
required parameter "name":"table-name",
"orderBy"
:[{
"format":"string",
"formattedLength":integer,
"label":"string",
required parameter "name":"variable-name",
"nfd":integer,
"nfl":integer
}<, {...}>],
"singlePass":True | False,
"vars"
:[{
"format":"string",
"formattedLength":integer,
"label":"string",
required parameter "name":"variable-name",
"nfd":integer,
"nfl":integer
}<, {...}>],
"where":"where-expression",
"whereTable"
:{
"casLib":"string"
"dataSourceOptions":{adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | hadoop-parameters | hana-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | path-parameters | postgres-parameters | redshift-parameters | s3-parameters | sapiq-parameters | sforce-parameters | singlestore_standard-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | ss_noreq-parameters | teradata-parameters | vertica-parameters | yellowbrick-parameters}
"importOptions":{"fileType":"ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters}
required parameter "name":"table-name"
"vars"
:[{
"format":"string",
"formattedLength":integer,
"label":"string",
required parameter "name":"variable-name",
"nfd":integer,
"nfl":integer
}<, {...}>]
"where":"where-expression"
}
}
)
indicates a required parameter

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.

Parameters for Reading Input Tables

Parameter

Subparameter

Description

required parametertable

—

specifies the input table that contains input sequences for analysis.

Parameters for Creating Output Tables

Parameter

Subparameter

Description

 casOut

—

specifies the output table. The output table contains frequent sequences and the support of the frequent sequences.

Parameter Descriptions

casOut={casouttable}

specifies the output table. The output table contains frequent sequences and the support of the frequent sequences.

For more information about specifying the casOut parameter, see the common casouttable parameter.

* eventId="variable-name"

specifies the event or time column of the input table.

* itemId="variable-name"

specifies the item column of the input table.

k=integer

specifies the number of items in an output sequence.

Default1
Minimum value1

minSupport=double

specifies the minimum level of support for a sequence.

AliasminSup
Range0–1

nSamples=64-bit-integer

specifies the number of candidates to sample.

Default1000000
Minimum value1000

nSamplesToVerify=64-bit-integer

specifies the number of sample candidates to verify.

Default10000

seed=64-bit-integer

specifies the seed to use for random number generation.

Default0

* sequenceId="variable-name"

specifies the sequence or customer column of the input table.

supportCnt=64-bit-integer

specifies the minimum number of transactions that must occur for a sequence.

Aliassupcnt
Minimum value1

* table={castable}

specifies the input table that contains input sequences for analysis.

For more information about specifying the table parameter, see the common castable parameter.

seqmc Action

Performs sequence mining using a Monte Carlo sampling algorithm.

R Syntax

Expand allCollapse all
results <– cas.sequence.seqmc(s,
casOut
=list(
caslib="string",
compress=TRUE | FALSE,
indexVars=list("variable-name-1" <, "variable-name-2", ...>),
label="string",
lifetime=64-bit-integer,
maxMemSize=64-bit-integer,
memoryFormat="DVR" | "INHERIT" | "STANDARD",
name="table-name",
promote=TRUE | FALSE,
replace=TRUE | FALSE,
replication=integer,
tableRedistUpPolicy="DEFER" | "NOREDIST" | "REBALANCE",
threadBlockSize=64-bit-integer,
timeStamp="string",
where=list("string-1" <, "string-2", ...>)
),
required parameter eventId="variable-name",
required parameter itemId="variable-name",
k=integer,
minSupport=double,
nSamples=64-bit-integer,
nSamplesToVerify=64-bit-integer,
seed=64-bit-integer,
required parameter sequenceId="variable-name",
supportCnt=64-bit-integer,
required parameter table
=list(
caslib="string",
computedOnDemand=TRUE | FALSE,
computedVars
=list( list(
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
) <, list(...)>),
computedVarsProgram="string",
dataSourceOptions=list(key-1=list(any-list-or-data-type-1) <, key-2=list(any-list-or-data-type-2), ...>),
groupBy
=list( list(
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
) <, list(...)>),
groupByMode="NOSORT" | "REDISTRIBUTE",
importOptions=list(fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters),
required parameter name="table-name",
orderBy
=list( list(
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
) <, list(...)>),
singlePass=TRUE | FALSE,
vars
=list( list(
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
) <, list(...)>),
where="where-expression",
whereTable
=list(
casLib="string"
dataSourceOptions=list(adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | hadoop-parameters | hana-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | path-parameters | postgres-parameters | redshift-parameters | s3-parameters | sapiq-parameters | sforce-parameters | singlestore_standard-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | ss_noreq-parameters | teradata-parameters | vertica-parameters | yellowbrick-parameters)
importOptions=list(fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters)
required parameter name="table-name"
vars
=list( list(
format="string",
formattedLength=integer,
label="string",
required parameter name="variable-name",
nfd=integer,
nfl=integer
) <, list(...)>)
where="where-expression"
)
)
)
indicates a required parameter

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.

Parameters for Reading Input Tables

Parameter

Subparameter

Description

required parametertable

—

specifies the input table that contains input sequences for analysis.

Parameters for Creating Output Tables

Parameter

Subparameter

Description

 casOut

—

specifies the output table. The output table contains frequent sequences and the support of the frequent sequences.

Parameter Descriptions

casOut=list(casouttable)

specifies the output table. The output table contains frequent sequences and the support of the frequent sequences.

For more information about specifying the casOut parameter, see the common casouttable parameter.

* eventId="variable-name"

specifies the event or time column of the input table.

* itemId="variable-name"

specifies the item column of the input table.

k=integer

specifies the number of items in an output sequence.

Default1
Minimum value1

minSupport=double

specifies the minimum level of support for a sequence.

AliasminSup
Range0–1

nSamples=64-bit-integer

specifies the number of candidates to sample.

Default1000000
Minimum value1000

nSamplesToVerify=64-bit-integer

specifies the number of sample candidates to verify.

Default10000

seed=64-bit-integer

specifies the seed to use for random number generation.

Default0

* sequenceId="variable-name"

specifies the sequence or customer column of the input table.

supportCnt=64-bit-integer

specifies the minimum number of transactions that must occur for a sequence.

Aliassupcnt
Minimum value1

* table=list(castable)

specifies the input table that contains input sequences for analysis.

For more information about specifying the table parameter, see the common castable parameter.

Last updated: March 19, 2025