DOCUMENTATION
Sign In

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

SAS Viya Platform System Programming Guide
 
CASL
Lua
Python
R

Table Action Set: Syntax

Provides actions for accessing and managing data

append Action

Append one table to another.

Requirement:The target table must be an in-memory table.
See: Appending Tables
Examples: Append a Table
Append a Table Using the Where Parameter

CASL Syntax

Expand allCollapse all
table.append <result=results> <status=rc> /
required parameter source
={
caslib="string",
dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>},
required parameter name="table-name",
singlePass=TRUE | FALSE,
where="where-expression"
},
required parameter target
={
caslib="string",
required parameter name="table-name"
}
;
indicates a required parameter

Summary: Input 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 parametersource

—

specifies the name of the input table.

required parametertarget

—

specifies the name of the input table.

Parameter Descriptions

* source={castable}

specifies the name of the input table.

Long formsource={name="table-name"}
Shortcut formsource="table-name"
Aliasdata

The castable value can be one or more of the following:

caslib="string"

specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.

dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>}

specifies data source options.

Aliasesoptions
dataSource
* name="table-name"

specifies the name of the input table.

singlePass=TRUE | FALSE

when set to True, does not create a transient table on the server. Setting this parameter to True can be efficient, but the data might not have stable ordering upon repeated runs.

DefaultFALSE
where="where-expression"

specifies an expression for subsetting the input data.

* target={castable}

specifies the name of the input table.

Long formtarget={name="table-name"}
Shortcut formtarget="table-name"
Aliasbase

The castable value can be one or more of the following:

caslib="string"

specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.

* name="table-name"

specifies the name of the input table.

append Action

Append one table to another.

Requirement:The target table must be an in-memory table.
See: Appending Tables
Examples: Append a Table
Append a Table Using the Where Parameter

Lua Syntax

Expand allCollapse all
results, info = s:table_append{
required parameter source
={
caslib="string",
dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>},
required parameter name="table-name",
singlePass=true | false,
where="where-expression"
},
required parameter target
={
caslib="string",
required parameter name="table-name"
}
}
indicates a required parameter

Summary: Input 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 parametersource

—

specifies the name of the input table.

required parametertarget

—

specifies the name of the input table.

Parameter Descriptions

* source={castable}

specifies the name of the input table.

Long formsource={name="table-name"}
Shortcut formsource="table-name"
Aliasdata

The castable value can be one or more of the following:

caslib="string"

specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.

dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>}

specifies data source options.

Aliasesoptions
dataSource
* name="table-name"

specifies the name of the input table.

singlePass=true | false

when set to True, does not create a transient table on the server. Setting this parameter to True can be efficient, but the data might not have stable ordering upon repeated runs.

Defaultfalse
where="where-expression"

specifies an expression for subsetting the input data.

* target={castable}

specifies the name of the input table.

Long formtarget={name="table-name"}
Shortcut formtarget="table-name"
Aliasbase

The castable value can be one or more of the following:

caslib="string"

specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.

* name="table-name"

specifies the name of the input table.

append Action

Append one table to another.

Requirement:The target table must be an in-memory table.
See: Appending Tables
Examples: Append a Table
Append a Table Using the Where Parameter

Python Syntax

Expand allCollapse all
results=s.table.append(
required parameter source
={
"caslib":"string",
"dataSourceOptions":{"key-1":{any-list-or-data-type-1} <, "key-2":{any-list-or-data-type-2}, ...>},
required parameter "name":"table-name",
"singlePass":True | False,
"where":"where-expression"
},
required parameter target
={
"caslib":"string",
required parameter "name":"table-name"
}
)
indicates a required parameter

Summary: Input 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 parametersource

—

specifies the name of the input table.

required parametertarget

—

specifies the name of the input table.

Parameter Descriptions

* source={castable}

specifies the name of the input table.

Long formsource={"name":"table-name"}
Shortcut formsource="table-name"
Aliasdata

The castable value can be one or more of the following:

"caslib":"string"

specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.

"dataSourceOptions":{"key-1":{any-list-or-data-type-1} <, "key-2":{any-list-or-data-type-2}, ...>}

specifies data source options.

Aliasesoptions
dataSource
* "name":"table-name"

specifies the name of the input table.

"singlePass":True | False

when set to True, does not create a transient table on the server. Setting this parameter to True can be efficient, but the data might not have stable ordering upon repeated runs.

DefaultFalse
"where":"where-expression"

specifies an expression for subsetting the input data.

* target={castable}

specifies the name of the input table.

Long formtarget={"name":"table-name"}
Shortcut formtarget="table-name"
Aliasbase

The castable value can be one or more of the following:

"caslib":"string"

specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.

* "name":"table-name"

specifies the name of the input table.

append Action

Append one table to another.

Requirement:The target table must be an in-memory table.
See: Appending Tables
Examples: Append a Table
Append a Table Using the Where Parameter

R Syntax

Expand allCollapse all
results <– cas.table.append(s,
required parameter source
=list(
caslib="string",
dataSourceOptions=list(key-1=list(any-list-or-data-type-1) <, key-2=list(any-list-or-data-type-2), ...>),
required parameter name="table-name",
singlePass=TRUE | FALSE,
where="where-expression"
),
required parameter target
=list(
caslib="string",
required parameter name="table-name"
)
)
indicates a required parameter

Summary: Input 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 parametersource

—

specifies the name of the input table.

required parametertarget

—

specifies the name of the input table.

Parameter Descriptions

* source=list(castable)

specifies the name of the input table.

Long formsource=list(name="table-name")
Shortcut formsource="table-name"
Aliasdata

The castable value can be one or more of the following:

caslib="string"

specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.

dataSourceOptions=list(key-1=list(any-list-or-data-type-1) <, key-2=list(any-list-or-data-type-2), ...>)

specifies data source options.

Aliasesoptions
dataSource
* name="table-name"

specifies the name of the input table.

singlePass=TRUE | FALSE

when set to True, does not create a transient table on the server. Setting this parameter to True can be efficient, but the data might not have stable ordering upon repeated runs.

DefaultFALSE
where="where-expression"

specifies an expression for subsetting the input data.

* target=list(castable)

specifies the name of the input table.

Long formtarget=list(name="table-name")
Shortcut formtarget="table-name"
Aliasbase

The castable value can be one or more of the following:

caslib="string"

specifies the caslib for the input table that you want to use with the action. By default, the active caslib is used. Specify a value only if you need to access a table from a different caslib.

* name="table-name"

specifies the name of the input table.

Last updated: November 18, 2025