Table Action Set: Syntax
Provides actions for accessing and managing data
loadTable Action
Loads a table from a caslib's data source.
Summary: 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 the settings for an output table. |
Parameter Descriptions
attrTable="string"
specifies the name of an existing extended attributes table to use with an ADD, UPDATE, or CONVERT task. For CONVERT, this parameter names the table to use for storing the extended attributes.
caslib="string"
specifies the caslib for the data source to load the file from. By default, the active caslib is used. Specify a value only if you need to access data from a different caslib.
| Alias | sourceCaslib |
|---|
casOut={casouttablebasic}
specifies the settings for an output table.
| Long form | casOut={name="table-name"} |
|---|---|
| Shortcut form | casOut="table-name" |
The casouttablebasic value can be one or more of the following:
caslib="string"
specifies the name of the caslib for the output table.
indexVars={"variable-name-1" <, "variable-name-2", ...>}
specifies the list of variables to create indexes for in the output data.
label="string"
specifies the descriptive label to associate with the table.
lifetime=64-bit-integer
specifies the number of seconds to keep the table in memory after it is last accessed. The table is dropped if it is not accessed for the specified number of seconds.
| Default | 0 |
|---|---|
| Minimum value | 0 |
memoryFormat="DVR" | "INHERIT" | "STANDARD"
specifies the memory format for the output table.
| Default | INHERIT |
|---|
DVR
use the duplicate value reduction memory format. This memory format can reduce the memory consumption and file size when the input data contains duplicate values.
name="table-name"
specifies the name for the output table.
promote=TRUE | FALSE
when set to True, adds the output table with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | FALSE |
|---|
replace=TRUE | FALSE
when set to True, overwrites an existing table that has the same name.
| Default | FALSE |
|---|
replication=integer
specifies the number of copies of the table to make for fault tolerance. Larger values result in slower performance and use more memory, but provide high availability for data in the event of a node failure. Data redundancy applies to distributed servers only.
| Default | 1 |
|---|---|
| Minimum value | 0 |
dataSourceOptions={adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | greenplum-parameters | hadoop-parameters | hana-parameters | hdfs-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | netezza-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}
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
For more information about specifying the dataSourceOptions parameter, see the common dataSourceOptions parameter.
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters}
specifies the settings for reading a table from a data source.
| Alias | import |
|---|
The value that you specify for the fileType parameter determines the other parameters that apply. For more information about this common parameter, see importOptions.
loadAttrs=TRUE | FALSE
when set to True, attributes are automatically loaded from a file that is named table-name.ATTRS.sashdat.
| Default | FALSE |
|---|
maximumRecords=64-bit-integer
specifies the maximum number of records for a multi-part table to load from disk and to retain in memory.
| Aliases | maxRec |
|---|---|
| maxRecs | |
| Default | 0 |
| Minimum value | -1 |
* path="string"
specifies the file, directory, or table name.
| Alias | source |
|---|
promote=TRUE | FALSE
when set to True, the view is added with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | FALSE |
|---|
readAhead=TRUE | FALSE
when set to True, loads the table into memory immediately. By default, a table is loaded into memory when it is first used.
| Default | FALSE |
|---|
vars={{casinvardesc-1} <, {casinvardesc-2}, ...>}
specifies the variables to use in the action.
For more information about specifying the vars parameter, see the common casinvardesc parameter.
where="where-expression"
specifies an expression for subsetting the input data.
Result Descriptions
caslib
The result is a string. You can access the value from results.caslib.
tableName
The result is a string. You can access the value from results.tableName.
loadTable Action
Loads a table from a caslib's data source.
Summary: 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 the settings for an output table. |
Parameter Descriptions
attrTable="string"
specifies the name of an existing extended attributes table to use with an ADD, UPDATE, or CONVERT task. For CONVERT, this parameter names the table to use for storing the extended attributes.
caslib="string"
specifies the caslib for the data source to load the file from. By default, the active caslib is used. Specify a value only if you need to access data from a different caslib.
| Alias | sourceCaslib |
|---|
casOut={casouttablebasic}
specifies the settings for an output table.
| Long form | casOut={name="table-name"} |
|---|---|
| Shortcut form | casOut="table-name" |
The casouttablebasic value can be one or more of the following:
caslib="string"
specifies the name of the caslib for the output table.
indexVars={"variable-name-1" <, "variable-name-2", ...>}
specifies the list of variables to create indexes for in the output data.
label="string"
specifies the descriptive label to associate with the table.
lifetime=64-bit-integer
specifies the number of seconds to keep the table in memory after it is last accessed. The table is dropped if it is not accessed for the specified number of seconds.
| Default | 0 |
|---|---|
| Minimum value | 0 |
memoryFormat="DVR" | "INHERIT" | "STANDARD"
specifies the memory format for the output table.
| Default | INHERIT |
|---|
DVR
use the duplicate value reduction memory format. This memory format can reduce the memory consumption and file size when the input data contains duplicate values.
name="table-name"
specifies the name for the output table.
promote=true | false
when set to True, adds the output table with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | false |
|---|
replace=true | false
when set to True, overwrites an existing table that has the same name.
| Default | false |
|---|
replication=integer
specifies the number of copies of the table to make for fault tolerance. Larger values result in slower performance and use more memory, but provide high availability for data in the event of a node failure. Data redundancy applies to distributed servers only.
| Default | 1 |
|---|---|
| Minimum value | 0 |
dataSourceOptions={adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | greenplum-parameters | hadoop-parameters | hana-parameters | hdfs-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | netezza-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}
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
For more information about specifying the dataSourceOptions parameter, see the common dataSourceOptions parameter.
importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters}
specifies the settings for reading a table from a data source.
| Alias | import |
|---|
The value that you specify for the fileType parameter determines the other parameters that apply. For more information about this common parameter, see importOptions.
loadAttrs=true | false
when set to True, attributes are automatically loaded from a file that is named table-name.ATTRS.sashdat.
| Default | false |
|---|
maximumRecords=64-bit-integer
specifies the maximum number of records for a multi-part table to load from disk and to retain in memory.
| Aliases | maxRec |
|---|---|
| maxRecs | |
| Default | 0 |
| Minimum value | -1 |
* path="string"
specifies the file, directory, or table name.
| Alias | source |
|---|
promote=true | false
when set to True, the view is added with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | false |
|---|
readAhead=true | false
when set to True, loads the table into memory immediately. By default, a table is loaded into memory when it is first used.
| Default | false |
|---|
vars={{casinvardesc-1} <, {casinvardesc-2}, ...>}
specifies the variables to use in the action.
For more information about specifying the vars parameter, see the common casinvardesc parameter.
where="where-expression"
specifies an expression for subsetting the input data.
Result Descriptions
caslib
The result is a string. You can access the value from results.caslib.
tableName
The result is a string. You can access the value from results.tableName.
loadTable Action
Loads a table from a caslib's data source.
Summary: 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 the settings for an output table. |
Parameter Descriptions
attrTable="string"
specifies the name of an existing extended attributes table to use with an ADD, UPDATE, or CONVERT task. For CONVERT, this parameter names the table to use for storing the extended attributes.
caslib="string"
specifies the caslib for the data source to load the file from. By default, the active caslib is used. Specify a value only if you need to access data from a different caslib.
| Alias | sourceCaslib |
|---|
casOut={casouttablebasic}
specifies the settings for an output table.
| Long form | casOut={"name":"table-name"} |
|---|---|
| Shortcut form | casOut="table-name" |
The casouttablebasic value can be one or more of the following:
"caslib":"string"
specifies the name of the caslib for the output table.
"indexVars":["variable-name-1" <, "variable-name-2", ...>]
specifies the list of variables to create indexes for in the output data.
"label":"string"
specifies the descriptive label to associate with the table.
"lifetime":64-bit-integer
specifies the number of seconds to keep the table in memory after it is last accessed. The table is dropped if it is not accessed for the specified number of seconds.
| Default | 0 |
|---|---|
| Minimum value | 0 |
"memoryFormat":"DVR" | "INHERIT" | "STANDARD"
specifies the memory format for the output table.
| Default | INHERIT |
|---|
DVR
use the duplicate value reduction memory format. This memory format can reduce the memory consumption and file size when the input data contains duplicate values.
"name":"table-name"
specifies the name for the output table.
"promote":True | False
when set to True, adds the output table with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | False |
|---|
"replace":True | False
when set to True, overwrites an existing table that has the same name.
| Default | False |
|---|
"replication":integer
specifies the number of copies of the table to make for fault tolerance. Larger values result in slower performance and use more memory, but provide high availability for data in the event of a node failure. Data redundancy applies to distributed servers only.
| Default | 1 |
|---|---|
| Minimum value | 0 |
dataSourceOptions={adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | greenplum-parameters | hadoop-parameters | hana-parameters | hdfs-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | netezza-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}
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
For more information about specifying the dataSourceOptions parameter, see the common dataSourceOptions parameter.
importOptions={"fileType":"ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters}
specifies the settings for reading a table from a data source.
| Alias | import_ |
|---|
The value that you specify for the fileType parameter determines the other parameters that apply. For more information about this common parameter, see importOptions.
loadAttrs=True | False
when set to True, attributes are automatically loaded from a file that is named table-name.ATTRS.sashdat.
| Default | False |
|---|
maximumRecords=64-bit-integer
specifies the maximum number of records for a multi-part table to load from disk and to retain in memory.
| Aliases | maxRec |
|---|---|
| maxRecs | |
| Default | 0 |
| Minimum value | -1 |
* path="string"
specifies the file, directory, or table name.
| Alias | source |
|---|
promote=True | False
when set to True, the view is added with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | False |
|---|
readAhead=True | False
when set to True, loads the table into memory immediately. By default, a table is loaded into memory when it is first used.
| Default | False |
|---|
vars=[{casinvardesc-1} <, {casinvardesc-2}, ...>]
specifies the variables to use in the action.
For more information about specifying the vars parameter, see the common casinvardesc parameter.
where="where-expression"
specifies an expression for subsetting the input data.
Result Descriptions
caslib
The result is a string. You can access the value from results.caslib.
tableName
The result is a string. You can access the value from results.tableName.
loadTable Action
Loads a table from a caslib's data source.
Summary: 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 the settings for an output table. |
Parameter Descriptions
attrTable="string"
specifies the name of an existing extended attributes table to use with an ADD, UPDATE, or CONVERT task. For CONVERT, this parameter names the table to use for storing the extended attributes.
caslib="string"
specifies the caslib for the data source to load the file from. By default, the active caslib is used. Specify a value only if you need to access data from a different caslib.
| Alias | sourceCaslib |
|---|
casOut=list(casouttablebasic)
specifies the settings for an output table.
| Long form | casOut=list(name="table-name") |
|---|---|
| Shortcut form | casOut="table-name" |
The casouttablebasic value can be one or more of the following:
caslib="string"
specifies the name of the caslib for the output table.
indexVars=list("variable-name-1" <, "variable-name-2", ...>)
specifies the list of variables to create indexes for in the output data.
label="string"
specifies the descriptive label to associate with the table.
lifetime=64-bit-integer
specifies the number of seconds to keep the table in memory after it is last accessed. The table is dropped if it is not accessed for the specified number of seconds.
| Default | 0 |
|---|---|
| Minimum value | 0 |
memoryFormat="DVR" | "INHERIT" | "STANDARD"
specifies the memory format for the output table.
| Default | INHERIT |
|---|
DVR
use the duplicate value reduction memory format. This memory format can reduce the memory consumption and file size when the input data contains duplicate values.
name="table-name"
specifies the name for the output table.
promote=TRUE | FALSE
when set to True, adds the output table with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | FALSE |
|---|
replace=TRUE | FALSE
when set to True, overwrites an existing table that has the same name.
| Default | FALSE |
|---|
replication=integer
specifies the number of copies of the table to make for fault tolerance. Larger values result in slower performance and use more memory, but provide high availability for data in the event of a node failure. Data redundancy applies to distributed servers only.
| Default | 1 |
|---|---|
| Minimum value | 0 |
dataSourceOptions=list(adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | greenplum-parameters | hadoop-parameters | hana-parameters | hdfs-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | netezza-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)
specifies data source options.
| Aliases | options |
|---|---|
| dataSource |
For more information about specifying the dataSourceOptions parameter, see the common dataSourceOptions parameter.
importOptions=list(fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters)
specifies the settings for reading a table from a data source.
| Alias | import |
|---|
The value that you specify for the fileType parameter determines the other parameters that apply. For more information about this common parameter, see importOptions.
loadAttrs=TRUE | FALSE
when set to True, attributes are automatically loaded from a file that is named table-name.ATTRS.sashdat.
| Default | FALSE |
|---|
maximumRecords=64-bit-integer
specifies the maximum number of records for a multi-part table to load from disk and to retain in memory.
| Aliases | maxRec |
|---|---|
| maxRecs | |
| Default | 0 |
| Minimum value | -1 |
* path="string"
specifies the file, directory, or table name.
| Alias | source |
|---|
promote=TRUE | FALSE
when set to True, the view is added with a global scope. This enables other sessions to access the table, subject to access controls. The target caslib must also have a global scope.
| Default | FALSE |
|---|
readAhead=TRUE | FALSE
when set to True, loads the table into memory immediately. By default, a table is loaded into memory when it is first used.
| Default | FALSE |
|---|
vars=list( list(casinvardesc-1) <, list(casinvardesc-2), ...>)
specifies the variables to use in the action.
For more information about specifying the vars parameter, see the common casinvardesc parameter.
where="where-expression"
specifies an expression for subsetting the input data.
Result Descriptions
caslib
The result is a string. You can access the value from results.caslib.
tableName
The result is a string. You can access the value from results.tableName.