CASL Functions Listed Alphabetically
|
Name
|
Syntax and Description
|
|---|---|
|
ABS(expression)
Returns the absolute value.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ACTIONQ(<"session-reference ">,
<"yes">);
Displays the action queue.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ADD_TABLE_ATTR(table-name, dictionary-1<, dictionary-2, ..., dictionary-n>)
Adds attributes to a result table.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ADDBYGROUP (result-table-name);
Creates a new table from a BY-group table. The BY
variables are added as the first variables of each row. The attributes
for BY-group processing are removed.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ADDROW (table, row-1<, row-2,
... row-N>);
Adds one or more rows to a table.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ADDUNIQUE
(array,
value);
Adds a value to an array, if the value does not
already exist within the array.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
AIRY(x)
Returns the value of the Airy function.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ANYALNUM(string <,start>)
Searches a character string for an alphanumeric
character, and returns the first position at which the character is
found.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ANYALPHA(string <,start>)
Searches a character string for an alphabetic character,
and returns the first position at which the character is found.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ANYCNTRL(string <,start>)
Searches a character string for a control character,
and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ANYFIRST(string <,start>)
Searches a character string for a character that
is valid as the first character in a SAS variable name under VALIDVARNAME=V7,
and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ANYGRAPH(string <,start>)
Searches a character string for a graphical character,
and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ANYLOWER(string <,start>)
Searches a character string for a lowercase letter,
and returns the first position at which the letter is found.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ANYNAME(string <,start>)
Searches a character string for a character that
is valid in a SAS variable name under VALIDVARNAME=V7, and returns
the first position at which that character is found.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ANYPRINT(string <,start>)
Searches a character string for a printable character,
and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ANYPUNCT(string <,start>)
Searches a character string for a punctuation character,
and returns the first position at which that character is found.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
Decodes a string, integer, double array, or a binary object to Base64.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
base64Encode("name")
Encodes a string, integer, double array, or a binary object to Base64.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CANCELACTION
(“session-reference”);
Cancels the action running on the given session.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CANCELACTIONS
({list-of-session-references});
Cancels the action running on the given list of
sessions.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CASL2JSON(dictionary)
Converts the contents of a CASL dictionary to a
string containing JSON formatted text.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CLEAR (<variable-1<, variable-2 ..., variable-n>>);
Clears all specified variables. If no variables
are specified, all variables are cleared.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CODETOSTATUS (status_code);
Converts the action status into a dictionary.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
COMBINE_TABLES (list-of-tables, <“key-pattern”> );
Create a new table that has the name of the first
table and contains all of the rows from all the tables. If this is
a BY-group table, add the BY-group variables as the first variables
of the table.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
CREATE_PARALLEL_SESSION (<number-of-workers>);
Starts a session with the same identity as the calling action. You can call this
function to create multiple sessions.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DICTIONARY (dictionary, string);
Searches for a key in the given dictionary and,
if found, returns its associated value.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
DIM (array-name);
Retrieves the dimensions of an array or dictionary.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
ENCODING( );
Returns an encoding string for the current session
encoding.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
EXECUTE("code ");
Compiles and executes
the given code.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
EXISTS (dictionary, key);
EXISTS (variable-name);
Determines whether a variable exists or whether
a dictionary contains a specified key.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
EXIT;
EXIT ( {severity = severity-code, reason = reason-code, statuscode = status-number, formatted =
“message”
} );
Exits the block of CASL code with the given status.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
FINDTABLE
(variable);
Searches the given variable for the first table
it sees. This is useful when a result from an action returns a copy
of a result table.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
FMTVAR(format-name, <format-width>, <d>);
Creates a CASL format variable that can be used
as a substitute for a SAS format.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GETCOLUMN(table-name, column-name | column-number);
Extracts the column into an array.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GETENV(<string>);
Returns the environment variable for the given string.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
GETRESULT("session-reference", <action-tag><id>);
Retrieves results associated with ID or tag.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
INPUT_FORMAT (string);
Converts the string to the best numeric value.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
isType (value-1, <value-1><,...><, value-n>);
Returns TRUE or FALSE based on whether an expression results
in a value of a specified type.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
JSON2CASL(string)
Converts a string containing JSON formatted text
to a CASL dictionary.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LIST_PARALLEL_SESSIONS< ("session-reference")>;
Lists parallel sessions.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
LOC
(table-name, column, value);
Returns the row number in which the given value
is found in the given column.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
MEMORYSTATS ();
Displays CPU and memory statistics.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
NEWTABLE(“table-name”, column-name, data-type, row-1<, row-2, ... row-N>);
Creates a new table.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
PUT (value, format);
Formats a value with the given format and returns
it as a string.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
READFILE("file-reference"
);
Reads and returns the contents of the specified file reference.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
READPATH ("file-name");
Reads and returns the contents of the specified filename.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
RESULT_BY_COL
(table-name,
“column-name”, column_number);
Creates a new table with the given columns.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
RESULT_BY_TYPE
(table-name,
“<data
types>”);
Creates a new table with columns that match the
type specifications.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SEND_RESPONSE (result);
Sends the specified result back to the client.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SLEEP (<value>);
Sleep in the operating system (OS) for the number
of seconds specified.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SORT (list);
Returns a list sorted in ascending order.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SORT_REV
(list);
Returns a list sorted in descending order.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SYMDEL (“macro-variable”);
Deletes the specified macro variable.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SYMGET(macro-variable-name);
Returns the value of a macro variable.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SYMPUT
(macro-variable-name, value);
Stores a value in a SAS macro variable.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
SYMPUTX (macro-variable-name, macro-variable-value, <symbol-table>);
Assigns a value to a macro variable, and removes
both leading and trailing blanks.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TABCOLUMNS
(table-name);
Returns the names and labels of columns from a result table into a dictionary. For
each item in the dictionary, the key is the name of a column, and the value is the
label of the
column.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TABTYPES
(table-name);
Extracts the data types from a result table into
a dictionary.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TERM_PARALLEL_SESSION (<session-reference-1>, <session-reference-N>);
Terminates a parallel session.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
TIMESTAMP
(<expression> | <format>)
Returns the current date and time in a specified format.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
UNIQUE
(array,
<value>);
Searches an array to determine if a value exists
in the array.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
unpackData("name")
Unpacks the string, packed by base64Encode, according
to the given format.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
UUID
("session-reference");
Returns the universally unique identifier (UUID)
for the given session.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
| |
|
WAIT_FOR_NEXT_ACTION
(job-name);
Wait for a completed action.
Product: Base SAS
Document: SAS Cloud Analytic Services: CASL Reference
|
Last updated: July 17, 2025