SAS Parser
Parser Documentation

Version: 1.5.2


This document was generated on 2023/11/09.


Introduction

This parser is based on Kolasu, an application of the StarLasu methodology on the Java Virtual Machine (JVM).

Usage

The main entry point is the class com.strumenta.sas.SASLanguage which is the SAS implementation of a Kolasu parser.

After constructing a SASLanguage instance, we can invoke one of the parse method overloads to obtain a result including:

  • the AST, the main result of the parsing, a tree structure modeling the contents of the source code. This document lists the types of nodes that can make up the AST for SAS code. These are all Kolasu nodes that we can traverse, transform, etc.
  • a list of issues encountered during parsing (errors, warnings, and informative messages).

Documentation

Classes

Identifier Class

An identifier, i.e., a name for a variable, function, etc. Note that identifiers in SAS may be composed of a fixed part and a variable part computed as a macro expansion, e.g., foo&bar.

Super Classes
Local Features
Name Type
name String
namespace
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

NodeWithAutoChildren Class

A node that automatically adds other nodes as children when passed into its constructor.

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses

SourceFile Class

An entire SAS source file.

Local Features
Name Type
statementsAndDeclarations List<ASTNode>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

Abstract Classes and Interfaces

InputSpecification Class (Abstract) A

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

InputVariableSpecification Class (Abstract) A

Super Classes
Local Features
Name Type
suppress Boolean
suppressNoError Boolean
variable
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses

PointerControl Class (Abstract) A

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

SetOption Class (Abstract) A

A SET statement option.

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

Statements

ArrayStatement Class

An ARRAY statement.

Super Classes
Local Features
Name Type
autoDim Boolean
dimensions
List<Expression> A
dollar Boolean
from
Identifier?
list
List<Identifier>
name
Identifier?
to
Identifier?

AssignmentStatement Class

An assignment to a variable.

Super Classes
Local Features
Name Type
name
Identifier?
value
Expression? A

AttribStatement Class

An ATTRIB statement.

Super Classes
Local Features
Name Type
attrib List<ASTNode>

CallStatement Class

A CALL statement.

Super Classes
Local Features

DeclareOption Class

An option in a DECLARE statement.

Super Classes
Local Features
Name Type
dataset
DatasetSpec?
expression
Expression? A
name
Identifier?
Used In

DeclareStatement Class

A DECLARE statement.

Super Classes
Local Features

DeleteStatement Class

A DELETE statement.

Super Classes
Local Features
Name Type
identifier
Identifier?

DoStatement Class

A DO statement.

Super Classes
Local Features
Name Type
body
List<DataStatement> A
iterateBy
Expression? A
iterateFrom
Expression? A
iterateTo
Expression? A
iterateUntil
Expression? A
iterateWhile
Expression? A
iterationVariable
Identifier?

DropStatement Class

A DROP statement.

Super Classes
Local Features
Name Type
datasets
List<DatasetSpec>

EmptyStatement Class

An empty statement (i.e. a lone semicolon).

Super Classes

ExpressionStatement Class

An expression statement.

Super Classes
Local Features
Name Type
expression
Expression? A

FileSendStatement Class

FILE SEND statement.

Super Classes
Local Features
Name Type
from List<String>
subject String
to List<String>

FileStatement Class

A FILE statement.

Super Classes
Local Features
Name Type
expression
Expression? A
options
List<FileOption>

FormatStatement Class

A FORMAT statement.

Super Classes
Local Features
Name Type
formats
List<FormatSpec>

IfStatement Class

An IF statement.

Super Classes
Local Features
Name Type
condition
Expression? A
elseStatement
DataStatement? A
thenStatement
DataStatement? A

InputStatement Class

Input statement. See https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000146292.htm

Super Classes
Local Features
Name Type
holdAcross Boolean
holdWithin Boolean
specifications
List<InputSpecification> A

KeepStatement Class

A KEEP statement.

Super Classes
Local Features
Name Type
variables
VariableList? A

LabelStatement Class

A LABEL statement.

Super Classes
Local Features
Name Type
expression
List<Expression> A
names
List<Identifier>

LengthStatement Class

A LENGTH statement.

Super Classes
Local Features
Name Type
specs
List<LengthSpec>

MacroStatementWrapper Class

A macro statement in a data step context.

Super Classes
Local Features
Name Type
macroStatement
Statement? A

MergeStatement Class

A MERGE statement.

Super Classes
Local Features
Name Type
datasets
List<DatasetSpec>

OutputStatement Class

An OUTPUT statement.

Super Classes
Local Features
Name Type
identifier
Identifier?

PutLogStatement Class

PUTLOG statement.

Super Classes
Local Features
Name Type
identifier
Identifier?
informat String?
message String

PutStatement Class

A PUT statement.

Super Classes
Local Features
Name Type
at Boolean
dollar Boolean
putBuilder
DoStatement?
specifications
List<PutSpecification>

RenameStatement Class

A RENAME statement.

Super Classes
Local Features
Name Type
expression
List<Expression> A
names
List<Identifier>

Retain Class

A single element in a RETAIN statement.

Super Classes
Local Features
Name Type
expression
Expression? A
identifiers
List<Identifier>
Used In

RetainStatement Class

A RETAIN statement.

Super Classes
Local Features
Name Type
retains
List<Retain>

ReturnStatement Class

A RETURN statement.

Super Classes

SelectClause Class

A single clause in a SELECT statement.

Super Classes
Local Features
Name Type
condition
Expression? A
statement
DataStatement? A
Used In

SelectStatement Class

A SELECT statement.

Super Classes
Local Features
Name Type
clauses
List<SelectClause>

SetStatement Class

A SET statement. https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000173782.htm

Super Classes
Local Features

StopStatement Class

Super Classes

UpdateStatement Class

An UPDATE statement in a DATA STEP.

Super Classes
Local Features
Name Type
by
ByStatement?
master
DatasetSpec?
transaction
DatasetSpec?

Classes

ColumnInput Class

Super Classes
Local Features
Name Type
character Boolean
end Integer?
start Integer
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
suppress Boolean
suppressNoError Boolean
variable
Identifier?

ColumnPointerControl Class

Super Classes
Local Features
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DataStep Class

A DATA step.

Local Features
Name Type
datasets
List<DatasetSpec>
options
List<Option>
statements
List<Statement>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

EndSetOption Class

An END option in a SET statement.

Super Classes
Local Features
Name Type
end
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

FormatSpec Class

A format specification.

Super Classes
Local Features
Name Type
format String
names
List<FormatVariableRange>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

FormatVariableRange Class

Super Classes
Local Features
Name Type
toVariable
Identifier?
variable
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

FormattedInput Class

Super Classes
Local Features
Name Type
informat String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
suppress Boolean
suppressNoError Boolean
variable
Identifier?

InputSpecification Class (Abstract) A

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

InputVariableSpecification Class (Abstract) A

Super Classes
Local Features
Name Type
suppress Boolean
suppressNoError Boolean
variable
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses

KeySetOption Class

A KEY option in a SET statement.

Super Classes
Local Features
Name Type
key
Identifier?
unique Boolean
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

LengthSpec Class

A length specification as part of a LENGTH statement.

Local Features
Name Type
character Boolean
format String
name String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

LinePointerControl Class

Super Classes
Local Features
Name Type
next Boolean?
to
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ListInput Class

Super Classes
Local Features
Name Type
blanks Boolean
character Boolean
informat String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
suppress Boolean
suppressNoError Boolean
variable
Identifier?

NamedInput Class

Super Classes
Local Features
Name Type
character Boolean
informat String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
suppress Boolean
suppressNoError Boolean
variable
Identifier?

Option Class

A DATA step option.

Local Features
Name Type
name
Identifier?
value String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

PointerControl Class (Abstract) A

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

PrefixSetSpecification Class

An clause in a SET statement with a prefix.

Super Classes
Local Features
Name Type
prefix
DatasetSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

PutSpecification Class

An individual clause in a PUT statement. See https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000161869.htm

Local Features
Name Type
named
Identifier?
pointerControl
PointerControl? A
string String?
times Integer?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

SetOption Class (Abstract) A

A SET statement option.

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

SetSpecification Class

An individual clause in a SET statement.

Local Features
Name Type
name
DatasetSpec?
value
DatasetSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

SingleAttribStatement Class

A portion of an ATTRIB statement which is related to a single identifier.

Local Features
Name Type
format String?
identifier
Identifier?
informat String?
label String?
length String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

StatementError Class

An invalid or otherwise unsupported data step statement.

Inherited Features
Name Type
message String

Abstract Classes and Interfaces

Statement Class (Abstract) A

Statements

AbortStatement Class

A %ABORT statement.

Super Classes
Local Features
Name Type
returnValue
Expression? A
type String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

Comment Class

A commented-out macro statement.

Super Classes
Local Features
Name Type
text String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DoStatement Class

A %DO statement.

Super Classes
Local Features
Name Type
body List<ASTNode>
iterateFrom
Expression? A
iterateTo
Expression? A
iterationVariable String?
untilCondition
Expression? A
whileCondition
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

ExpressionStatement Class

A statement consisting of a single expression (e.g., a function call whose return value is ignored).

Super Classes
Local Features
Name Type
expression
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

GlobalStatement Class

A %GLOBAL statement.

Super Classes
Local Features
Name Type
variables
List<Identifier>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

GotoStatement Class

A %GOTO statement.

Super Classes
Local Features
Name Type
label String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

IfStatement Class

An %IF statement.

Super Classes
Local Features
Name Type
alternative List<ASTNode>
condition
Expression? A
consequence List<ASTNode>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

IncludeStatement Class

A %INCLUDE statement.

Super Classes
Local Features
Name Type
resource
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

LabelStatement Class

A %LABEL statement.

Super Classes
Local Features
Name Type
label String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

LocalStatement Class

A %LOCAL statement.

Super Classes
Local Features
Name Type
variables
List<Identifier>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

PlainTextStatement Class

Macro text that couldn't be parsed as valid SAS or SQL code.

Super Classes
Local Features
Name Type
text String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

PutStatement Class

A %PUT statement.

Super Classes
Local Features
Name Type
expression
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

Statement Class (Abstract) A

VariableDeclaration Class

A macro variable declaration ( %LET foo = ... ).

Super Classes
Local Features
Name Type
expression
Expression? A
name String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

Expressions

ConstantTextExpression Class

Literal text used as an expression.

Super Classes
Local Features
Name Type
text String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DateConstantExpression Class

A date constant.

Super Classes
Local Features
Name Type
constant LocalDate?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DateTimeConstantExpression Class

A date and time constant.

Super Classes
Local Features
Name Type
constant LocalDateTime?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

FloatConstantExpression Class

A floating-point literal in a macro.

Super Classes
Local Features
Name Type
constant EBigDecimal
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

InformatExpression Class

An informat expression.

Super Classes
Local Features
Name Type
format String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

IntConstantExpression Class

An integer literal in a macro.

Super Classes
Local Features
Name Type
constant EBigInteger
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

MacroFunctionCallExpression Class

An invocation of a macro function.

Super Classes
Local Features
Name Type
arguments
List<MacroArgument>
macroName String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

OperatorApplicationExpression Class

Any kind of operator application like 1 + 2 + 3 . If there's only one argument, it's a unary operator application, such as -&x. or not %foo() . If the operator is in or not in , then the object represents the expression in/not in ( ... ) .

Super Classes
Local Features
Name Type
arguments
List<Expression> A
operator String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

StringConstantExpression Class

A string literal in a macro.

Super Classes
Local Features
Name Type
constant String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

SystemFunctionCallExpression Class

An invocation of a system function.

Super Classes
Local Features
Name Type
arguments
List<MacroArgument>
functionName String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

TextConcatExpression Class

A text concatenation expression.

Super Classes
Local Features
Name Type
expressions
List<Expression> A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

UnparsableDateConstantExpression Class

A date constant that could not be parsed into a LocalDate .

Super Classes
Local Features
Name Type
constant String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

UnparsableDateTimeConstantExpression Class

A date and time constant that could not be parsed into a LocalDateTime .

Super Classes
Local Features
Name Type
constant String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

VariableExpression Class

An expression whose value is the value of the given macro variable.

Super Classes
Local Features
Name Type
variable String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

Classes

ExpressionError Class

An invalid or otherwise unsupported macro expression.

Inherited Features
Name Type
message String

MacroArgument Class

A macro argument, either in a macro definition or in a macro function call .

Super Classes
Local Features
Name Type
name String?
value
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

MacroDefinition Class

A macro function definition.

Local Features
Name Type
arguments
List<MacroArgument>
body List<ASTNode>
name String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

StatementError Class

An invalid or otherwise unsupported macro statement.

Inherited Features
Name Type
message String

Abstract Classes and Interfaces

DatasetOption Class (Abstract) A

DatasetProcedureOption Class (Abstract) A

A PROC DATASETS option.

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

FreqProcedureOption Class (Abstract) A

An option for PROC FREQ .

Super Classes
Local Features
Name Type
name
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

ModelOption Class (Abstract) A

An option for PROC MODEL and PROC TMODEL .

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

PrintToProcedureOption Class (Abstract) A

An option for PROC PRINTTO .

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

SortProcedureOption Class (Abstract) A

An option for PROC SORT .

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

TimeseriesProcedureOption Class (Abstract) A

An option for PROC TIMESERIES .

Local Features
Name Type
name
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

TransposeProcedureOption Class (Abstract) A

An option for PROC TRANSPOSE .

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

VariableList Class (Abstract) A

A specification of one of more variables, such as in an "of" expression . This is an abstract class; see its subclasses for possible implementations.

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

Statements

ByStatement Class

BY statement, that can appear in various PROCedures and in the DATA step.

Super Classes
Local Features
Name Type
specifications
List<BySpecification>
Used In

ClassStatement Class

Super Classes

Comment Class

A commented-out statement.

Super Classes
Local Features
Name Type
text String

DatasetsChangeStatement Class

A CHANGE statement in a PROC DATASETS section.

Super Classes
Local Features

DatasetsCopyStatement Class

A COPY statement in a PROC DATASETS section.

Super Classes
Local Features
Name Type
in String?
options
List<CopyOption>
out String

DatasetsCreateIndexStatement Class

A CREATE INDEX statement in a PROC DATASETS section.

Super Classes
Local Features
Name Type
name String

DatasetsDeleteStatement Class

A DELETE statement in a PROC DATASETS section.

Super Classes
Local Features
Name Type
dataset
List<DatasetSpec>

DatasetsModifyStatement Class

A MODIFY statement in a PROC DATASETS section.

Super Classes
Local Features
Name Type
name String

DatasetsRenameStatement Class

A RENAME statement in a PROC DATASETS section.

Super Classes
Local Features

DatasetsSelectStatement Class

A SELECT statement in a PROC DATASETS section.

Super Classes
Local Features
Name Type
name String

EmptyStatement Class

An empty statement, i.e. a lone semicolon.

Super Classes

FilenameStatement Class

A FILENAME statement. See https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000211297.htm and https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/hosto390/n06xm17q99z0x6n1tskpswfrgp27.htm

Super Classes
Local Features
Name Type
accessMethod String?
externalFile
List<Expression> A
fileref
Identifier?
options
List<FileOption>

IdStatement Class

Super Classes

LibraryNameStatement Class

A LIBNAME statement.

Super Classes
Local Features
Name Type
all Boolean
clear Boolean
library
Identifier?
list Boolean
options
List<Option>
specifications
List<LibrarySpecification>

ODSStatement Class

Super Classes

Option Class

A single option in an OPTION statement .

Super Classes
Local Features
Used In

OptionsStatement Class

An OPTION statement.

Super Classes
Local Features
Name Type
options
List<Option>

OutputStatement Class

Super Classes

PerformanceOption Class

An option for a PERFORMANCE statement .

Super Classes
Local Features
Name Type
name String
value Integer
Used In

PerformanceStatement Class

PERFORMANCE statement, only valid in PROC TMODEL. http://documentation.sas.com/doc/it/pgmsascdc/9.4_3.4/etsug/etsug_tmodel_syntax08.htm

Super Classes
Local Features
Name Type
options
List<PerformanceOption>

QuitStatement Class

A QUIT statement.

Super Classes

RunStatement Class

A RUN statement.

Super Classes

TitleStatement Class

A TITLE statement. http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000220968.htm

Super Classes
Local Features
Name Type
expression
Expression? A
line Integer

TransposeIdStatement Class

An ID statement for PROC TRANSPOSE .

Super Classes
Local Features
Name Type
id
Identifier?

VarStatement Class

Super Classes

WhereStatement Class

A WHERE statement.

Super Classes
Local Features
Name Type
expression
Expression? A

Expressions

ArrayAccessExpression Class

An expression representing the access of an array element by index.

Super Classes
Local Features
Name Type
array
Expression? A
subscript
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DateConstantExpression Class

A date constant.

Super Classes
Local Features
Name Type
constant LocalDate?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DateTimeConstantExpression Class

A date and time constant.

Super Classes
Local Features
Name Type
constant LocalDateTime?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DotExpression Class

A dot (.) expression.

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

FloatConstantExpression Class

A float literal.

Super Classes
Local Features
Name Type
constant EBigDecimal
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

FunctionCallExpression Class

A function call.

Super Classes
Local Features
Name Type
arguments
List<Argument>
function String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

InformatExpression Class

An informat expression.

Super Classes
Local Features
Name Type
format String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

IntConstantExpression Class

An integer literal.

Super Classes
Local Features
Name Type
constant EBigInteger
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

MacroExpression Class

An expression resulting from the expansion of a macro.

Super Classes
Local Features
Name Type
constant ASTNode?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

MethodCallExpression Class

A method call (e.g. foo.bar() ).

Super Classes
Local Features
Name Type
arguments
List<Argument>
method String
receiver String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

OfExpression Class

An "of" expression.

Super Classes
Local Features
Name Type
variables
VariableList? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

OperatorApplicationExpression Class

An operator application such as a sum, subtraction, multiplication, ...

Super Classes
Local Features
Name Type
operands
List<Expression> A
operator String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

SetMembershipCheckExpression Class

An expression representing a membership test against a set (e.g. x in (1, 2, 3) ). Can also be negated, as in "not in".

Super Classes
Local Features
Name Type
element
Expression? A
negated Boolean
set
VariableExpression?
values
List<Expression> A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

StringConstantExpression Class

A string literal.

Super Classes
Local Features
Name Type
constant String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

UnparsableDateConstantExpression Class

A date constant that we could not parse into a LocalDate object.

Super Classes
Local Features
Name Type
constant String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

UnparsableDateTimeConstantExpression Class

A date and time constant that we could not parse into a LocalDateTime object.

Super Classes
Local Features
Name Type
constant String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

VariableExpression Class

An expression whose value is the value of a variable.

Super Classes
Local Features
Name Type
variable String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

Classes

AppendProcedure Class

PROC APPEND.

Local Features
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

AppendProcedureOption Class

An option for PROC APPEND .

Local Features
Name Type
name
Identifier?
value
DatasetSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

Argument Class

A function argument consisting of a value and an optional name.

Local Features
Name Type
name
Identifier?
value
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

BySpecification Class

A single element in a BY statement .

Local Features
Name Type
descending Boolean
identifier
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

CompareProcedure Class

PROC COMPARE.

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ComputedDatasetOption Class

A dataset option or options computed by a macro.

Super Classes
Local Features
Name Type
computedWith
Statement? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ContentsProcedure Class

PROC CONTENTS.

Local Features
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ContentsProcedureOption Class

An option for PROC CONTENTS .

Local Features
Name Type
name
Identifier?
value
DatasetSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

CopyOption Class

An option in a COPY statement.

Local Features
Name Type
name String
value String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

DatasetOption Class (Abstract) A

DatasetProcedureOption Class (Abstract) A

A PROC DATASETS option.

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

DatasetProcedureOptionFlag Class

A PROC DATASETS option which is a boolean flag (present = true, absent = false).

Super Classes
Local Features
Name Type
name String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DatasetProcedureOptionGennum Class

A PROC DATASETS GENNUM option.

Super Classes
Local Features
Name Type
value String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DatasetProcedureOptionSwitch Class

A PROC DATASETS option which can have a value (foo=bar).

Super Classes
Local Features
Name Type
name String
value String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DatasetsProcedure Class

A PROC DATASETS section.

Local Features
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DeleteProcedure Class

PROC DELETE.

Local Features
Name Type
dataFile
DatasetSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DropDatasetOption Class

A DROP dataset option.

Super Classes
Local Features
Name Type
variables
VariableList? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ExpandConvertStatement Class

A CONVERT statement for PROC EXPAND .

Local Features
Name Type
newName
Identifier?
variable
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ExpandIdStatement Class

An ID statement for PROC EXPAND .

Local Features
Name Type
name String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ExpandProcedure Class

PROC EXPAND.

Local Features
Name Type
options
List<ExpandProcedureOption>
statements List<ASTNode>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ExpandProcedureOption Class

An option for PROC EXPAND .

Local Features
Name Type
name
Identifier?
value
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

ExportProcedure Class

PROC EXPORT.

Local Features
Name Type
dataset
DatasetSpec?
dbms
Identifier?
label Boolean
outFile
Expression? A
outTable
Expression? A
replace Boolean
statements
List<ExportStatement>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ExportStatement Class

An export statement for PROC EXPORT .

Local Features
Name Type
name
Identifier?
value
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

ExpressionError Class

A node representing a malformed expression.

Inherited Features
Name Type
message String

ExtendObsCounterDatasetOption Class

An EXTENDOBSCOUNTER dataset option.

Super Classes
Local Features
Name Type
extend Boolean
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

FileOption Class

A file option.

Local Features
Name Type
expression
Expression? A
identifier
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

FormatProcedure Class

PROC FORMAT.

Local Features
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

FormatProcedureOption Class

An option for PROC FORMAT .

Local Features
Name Type
name
Identifier?
value
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

FreqProcedure Class

PROC FREQ.

Local Features
Name Type
options
List<FreqProcedureOption> A
statements List<ASTNode>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

FreqProcedureOption Class (Abstract) A

An option for PROC FREQ .

Super Classes
Local Features
Name Type
name
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

FreqProcedureOptionDataset Class

A dataset option for PROC FREQ .

Super Classes
Local Features
Name Type
value
DatasetSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
name
Identifier?

FreqProcedureOptionVariable Class

A variable option for PROC FREQ .

Super Classes
Local Features
Name Type
variable
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
name
Identifier?

FreqProcedureTableOption Class

An option in a TABLE statement for PROC FREQ .

Local Features
Name Type
name
Identifier?
value
DatasetSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

FreqProcedureTableStatement Class

A TABLE statement for PROC FREQ .

Local Features
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

FreqProcedureTablesStatement Class

A TABLES statement for PROC FREQ .

Local Features
Name Type
options
List<Identifier>
tables
List<Identifier>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

GenNumDatasetOption Class

A GENNUM dataset option.

Super Classes
Local Features
Name Type
value String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

GenericDatasetOption Class

Generic dataset option that's either a flag (value == null) or a parameter (value != null).

Super Classes
Local Features
Name Type
name String
value String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

HttpOption Class

An option for PROC IMPORT .

Local Features
Name Type
name
Identifier?
value
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

HttpProcedure Class

PROC HTTP.

Local Features
Name Type
options
List<HttpOption>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ImportOption Class

An option for PROC IMPORT .

Local Features
Name Type
name
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

ImportOptionDataset Class

A dataset option for PROC IMPORT .

Super Classes
Local Features
Name Type
dataset
DatasetSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
name
Identifier?

ImportOptionString Class

A string option for PROC IMPORT .

Super Classes
Local Features
Name Type
value String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
name
Identifier?

ImportProcedure Class

PROC IMPORT.

Local Features
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ImportStatement Class

A statement for PROC IMPORT .

Local Features
Name Type
datasetValue
DatasetSpec?
name
Identifier?
stringValue String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

InDatasetOption Class

An IN dataset option.

Super Classes
Local Features
Name Type
variables
VariableList? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

IndexDatasetOption Class

An INDEX dataset option, see https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000131138.htm.

Super Classes
Local Features
Name Type
name String?
variables
List<Identifier>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

KeepDatasetOption Class

A KEEP dataset option.

Super Classes
Local Features
Name Type
variables
VariableList? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

LabelDatasetOption Class

A LABEL dataset option.

Super Classes
Local Features
Name Type
label String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

LibrarySpecification Class

A single library specification in a LIBNAME statement .

Local Features
Name Type
name String?
reference
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

MeansProcedure Class

PROC MEANS.

Local Features
Name Type
statements
List<Statement>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ModelDataOption Class

A dataset option for PROC MODEL and PROC TMODEL .

Super Classes
Local Features
Name Type
datasetName String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ModelNoPrintOption Class

A NOPRINT option for PROC MODEL and PROC TMODEL .

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ModelOption Class (Abstract) A

An option for PROC MODEL and PROC TMODEL .

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

ModelProcedure Class

PROC MODEL.

Local Features
Name Type
options
List<ModelOption> A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

PrintToProcedure Class

PROC PRINTTO.

Local Features
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

PrintToProcedureOption Class (Abstract) A

An option for PROC PRINTTO .

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

PrintToProcedureOptionFlag Class

An option for PROC PRINTTO that can only be present or absent.

Super Classes
Local Features
Name Type
name String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

PrintToProcedureOptionSwitch Class

An option for PROC PRINTTO that has an associated value.

Super Classes
Local Features
Name Type
name String
stringValue String?
variableValue
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

Rename Class

A single rename specification in a RENAME dataset option.

Local Features
Name Type
from String
to String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

RenameDatasetOption Class

A RENAME dataset option.

Super Classes
Local Features
Name Type
renames
List<Rename>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

SGPlotProcedure Class

PROC SGPLOT.

Local Features
Name Type
statements List<ASTNode>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

SortProcedure Class

PROC SORT.

Local Features
Name Type
options
List<SortProcedureOption> A
statements List<ASTNode>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

SortProcedureDataOption Class

A DATA option for PROC SORT .

Super Classes
Local Features
Name Type
dataset
DatasetSpec?
datasetFile String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

SortProcedureOption Class (Abstract) A

An option for PROC SORT .

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

SortProcedureOptionFlag Class

An option for PROC SORT that can only be present or absent.

Super Classes
Local Features
Name Type
name String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

SortProcedureOptionSwitch Class

An option for PROC SORT that has an associated value.

Super Classes
Local Features
Name Type
name String
stringValue String?
value
DatasetSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

SortProcedureOutOption Class

An OUT option for PROC SORT .

Super Classes
Local Features
Name Type
dataset
DatasetSpec?
datasetFile String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

SortProcedureSizeOption Class

A SORTSIZE option for PROC SORT .

Super Classes
Local Features
Name Type
memorySpec String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

SummaryProcedure Class

PROC SUMMARY.

Local Features
Name Type
statements
List<Statement>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

TModelProcedure Class

PROC TMODEL.

Local Features
Name Type
options
List<ModelOption> A
statements List<ASTNode>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

TimeseriesIdStatement Class

An ID statement for PROC TIMESERIES .

Local Features
Name Type
id
Identifier?
interval
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

TimeseriesProcedure Class

PROC TIMESERIES.

Local Features
Name Type
options
List<TimeseriesProcedureOption> A
statements List<ASTNode>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

TimeseriesProcedureOption Class (Abstract) A

An option for PROC TIMESERIES .

Local Features
Name Type
name
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

TimeseriesProcedureOptionDataset Class

A dataset option for PROC TIMESERIES .

Super Classes
Local Features
Name Type
value
DatasetSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
name
Identifier?

TimeseriesProcedureOptionValues Class

A values option for PROC TIMESERIES .

Super Classes
Local Features
Name Type
values
List<Identifier>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
name
Identifier?

TimeseriesVarOption Class

An option for the VAR statement for PROC TIMESERIES .

Local Features
Name Type
name
Identifier?
value
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

TimeseriesVarStatement Class

A VAR statement for PROC TIMESERIES .

Local Features
Name Type
cross Boolean
options
List<TimeseriesVarOption>
variables
List<Identifier>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

TransposeProcedure Class

PROC TRANSPOSE.

Local Features
Name Type
options
List<TransposeProcedureOption> A
statements List<ASTNode>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

TransposeProcedureOption Class (Abstract) A

An option for PROC TRANSPOSE .

Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

TransposeProcedureOptionDataset Class

A dataset option for PROC TRANSPOSE .

Super Classes
Local Features
Name Type
name
Identifier?
value
DatasetSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

TransposeProcedureOptionFlag Class

An option for PROC TRANSPOSE that can only be present or absent.

Super Classes
Local Features
Name Type
name
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

TransposeProcedureOptionString Class

A string option for PROC TRANSPOSE .

Super Classes
Local Features
Name Type
name
Identifier?
value String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

Variable Class

A single variable.

Super Classes
Local Features
Name Type
name
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

VariableList Class (Abstract) A

A specification of one of more variables, such as in an "of" expression . This is an abstract class; see its subclasses for possible implementations.

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

VariableRangeByName Class

A range of variables by position in the dataset, e.g. name--address.

Super Classes
Local Features
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

VariableRangeByNumber Class

A range of numbered variables, e.g. v1-v9.

Super Classes
Local Features
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

VariableRangeWithPrefix Class

Variables having the same prefix, e.g., of dateof: .

Super Classes
Local Features
Name Type
prefix
Identifier?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

Variables Class

Multiple variable lists, as in, of a, b--e, f1-f5 .

Super Classes
Local Features
Name Type
variables
List<VariableList> A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

WhereDatasetOption Class

A WHERE dataset option.

Super Classes
Local Features
Name Type
condition
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

Abstract Classes and Interfaces

Constraint Class (Abstract) A

A SQL constraint.

Local Features
Name Type
name String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

Relation Class (Abstract) A

A relation is anything that can go in a SELECT FROM clause.

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

Statement Class (Abstract) A

Statements

ConnectStatement Class

A connect statement.

Super Classes
Local Features
Name Type
connection
Identifier?
kind
Identifier?
options
List<ConnectOption>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

CreateTableStatement Class

A SQL CREATE TABLE statement.

Super Classes
Local Features
Name Type
columnDefinitions
List<ColumnDefinition>
constraints
List<Constraint> A
ifNotExists Boolean
on String?
query
Query?
table
TableRef?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

CreateViewStatement Class

A SQL CREATE VIEW statement.

Super Classes
Local Features
Name Type
query
Query?
view
TableRef?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DeleteStatement Class

A SQL DELETE statement.

Super Classes
Local Features
Name Type
condition
Expression? A
hints List<String>
table
TableRef?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DescribeStatement Class

A SQL DESCRIBE statement.

Super Classes
Local Features
Name Type
table
TableRef?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DisconnectStatement Class

A disconnect statement.

Super Classes
Local Features
Name Type
connection String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

DropStatement Class

A SQL DROP TABLE statement.

Super Classes
Local Features
Name Type
table
TableRef?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

EmptyStatement Class

An empty statement, i.e. a lone semicolon.

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

ExecuteStatement Class

An execute statement.

Super Classes
Local Features
Name Type
by String?
nativeSQL
NativeSQL?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

InsertStatement Class

A SQL INSERT statement.

Super Classes
Local Features
Name Type
columns
List<ColumnRef>
hints List<String>
query
Query?
table
TableRef?
values
ValuesExpression?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

MacroStatement Class

A macro statement inside PROC SQL.

Super Classes
Local Features
Name Type
statement ASTNode?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

MergeStatement Class

A MERGE statement (MS SQL Server only).

Super Classes
Local Features
Name Type
hints List<String>
into
TableRelation?
on
Expression? A
using
Relation? A
whenMatched
Statement? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

Query Class

A SQL SELECT query.

Super Classes
Local Features
Name Type
condition
Expression? A
distinct Boolean
groupings
List<Grouping>
havingCondition
Expression? A
orderings
List<Ordering>
projections
List<Projection>
relations
List<Relation> A
resultsStore
List<QueryResultsStore>
union
Query?
unionAll Boolean
unique Boolean
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

Statement Class (Abstract) A

TruncateStatement Class

A SQL TRUNCATE TABLE statement.

Super Classes
Local Features
Name Type
table
TableRef?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

UpdateStatement Class

A SQL UPDATE statement.

Super Classes
Local Features
Name Type
condition
Expression? A
table
TableRef?
updates
List<Update>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

Expressions

AllColumnsExpression Class

"All columns", that is, * as in select * from customers

Super Classes
Local Features
Name Type
table
TableRef?

CaseExpression Class

A case...when... expression.

Super Classes
Local Features
Name Type
conditions
List<Expression> A
elseResult
Expression? A
expression
Expression? A
results
List<Expression> A

CastExpression Class

A cast expression, such as CAST (a + b) AS FLOAT

Super Classes
Local Features
Name Type
expression
Expression? A
type
TypeSpec?

ColumnExpression Class

An expression referring to a column, like a.b in a.b + 1

Super Classes
Local Features
Name Type
column
ColumnRef?

DateConstantExpression Class

A literal date value

Super Classes
Local Features
Name Type
constant LocalDate?

DateTimeConstantExpression Class

A literal datetime value

Super Classes
Local Features
Name Type
constant LocalDateTime?

DotExpression Class

The dot, .

Super Classes

ExistsExpression Class

(not) exists (select ...)

Super Classes
Local Features
Name Type
negated Boolean
query
Query?

FloatConstantExpression Class

A literal floating-point value

Super Classes
Local Features
Name Type
constant EBigDecimal

FunctionCallExpression Class

A function call such as MIN(foo) .

Super Classes
Local Features
Name Type
arguments
List<Expression> A
function String
Subclasses

InformatExpression Class

An informat expression.

Super Classes
Local Features
Name Type
format String

IntConstantExpression Class

A literal integer value

Super Classes
Local Features
Name Type
constant EBigInteger

NoJoinCondition Class

Super Classes

NullConstantExpression Class

A literal NULL

Super Classes

OperatorApplicationExpression Class

Any kind of operator application like 1 + 2 + 3

Super Classes
Local Features
Name Type
arguments
List<Expression> A
op String

QueryExpression Class

Select query expression, as in where foo = (select foo from bar)

Super Classes
Local Features
Name Type
query
Query?

RowExpression Class

A single row in a values expression.

Super Classes
Local Features
Name Type
values
List<Expression> A
Used In

SetExpression Class

Set membership expression such as x IN ...

Super Classes
Local Features
Name Type
element
Expression? A
op String
query
Query?
values
List<Expression> A

StringConstantExpression Class

A literal string

Super Classes
Local Features
Name Type
constant String

TrimFunctionCallExpression Class

A call to the TRIM function using specialized syntax, such as TRIM(LEADING FROM foo) .

Super Classes
Local Features
Name Type
leading Boolean
trailing Boolean
Inherited Features
Name Type
arguments
List<Expression> A
function String

UnparsableDateConstantExpression Class

A date value that could not be parsed

Super Classes
Local Features
Name Type
constant String

UnparsableDateTimeConstantExpression Class

A datetime value that could not be parsed

Super Classes
Local Features
Name Type
constant String

ValuesExpression Class

Values expression ( values (a, b, c, ...) ). In general, it can contain multiple rows, although the typical case is with a single row.

Super Classes
Local Features
Name Type
rows
List<RowExpression>
Used In

Classes

ColumnDefinition Class

The definition of a single column in a CREATE TABLE statement.

Local Features
Name Type
constraints
List<Constraint> A
name String
type
TypeSpec?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

ColumnRef Class

A (possibly scoped) reference to a column.

Super Classes
Local Features
Name Type
calculated Boolean
column String
table
TableRef?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

ConnectOption Class

Local Features
Name Type
name
Identifier?
value
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

Constraint Class (Abstract) A

A SQL constraint.

Local Features
Name Type
name String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

Grouping Class

A definition of a grouping in a SQL query, as in GROUP BY FOO .

Local Features
Name Type
column
ColumnRef?
columnIndex Integer?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

IdentityConstraint Class

An identity constraint.

Super Classes
Local Features
Name Type
increment Integer
seed Integer
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
name String?

JoinRelation Class

A join relation, as in SELECT * FROM foo JOIN bar... .

Super Classes
Local Features
Name Type
conditions
List<Expression> A
joinTypes
List<JoinType> E
relations
List<Relation> A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

NativeQueryRelation Class

A native subquery relation, as in SELECT * FROM CONNECTION TO ... (SELECT ...) .

Super Classes
Local Features
Name Type
alias String?
connection
Identifier?
query
NativeSQL?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

NativeSQL Class

A node representing a native SQL query or statement. Initially, the native SQL is not parsed and is kept as text. By invoking the attemptParse method, we can try to interpret it as SQL code. If successful, the parsed SQL will become a child node of this node.

Local Features
Name Type
parsed ASTNode?
text String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

NullabilityConstraint Class

A NULL/NOT NULL constraint.

Super Classes
Local Features
Name Type
nullsAllowed Boolean
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
name String?

Ordering Class

A definition of an ordering in a SQL query, e.g. FOO ASC in an ORDER BY clause.

Local Features
Name Type
ascending Boolean
column
ColumnRef?
columnIndex Integer?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

PrimaryKeyConstraint Class

A primary key constraint.

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
name String?

Projection Class

A projection is any expression that can be returned by a SELECT query.

Super Classes
Local Features
Name Type
alias
Identifier?
expression
Expression? A
format String?
label String?
length String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

QueryRelation Class

A subquery relation, as in SELECT * FROM (SELECT ...) .

Super Classes
Local Features
Name Type
alias String?
connection
Identifier?
query
Query?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

QueryResultsStore Class

The target of a SELECT INTO clause.

Local Features
Name Type
separatedBy String?
toVariable String?
variable String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

Relation Class (Abstract) A

A relation is anything that can go in a SELECT FROM clause.

Super Classes
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Subclasses
Used In

RelationError Class

An invalid relation, due to some error in the source code.

Inherited Features
Name Type
message String

SchemaRef Class

A (possibly scoped) reference to a schema.

Local Features
Name Type
catalog String?
schema String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

SqlProcedure Class

PROC SQL.

Local Features
Name Type
feedback Boolean
noPrint Boolean
statements
List<Statement> A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?

TableRef Class

A (possibly scoped) reference to a table or view.

Super Classes
Local Features
Name Type
schema
SchemaRef?
table String
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

TableRelation Class

A single table relation, as in SELECT * FROM foo .

Super Classes
Local Features
Name Type
alias String?
table
TableRef?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

TypeSpec Class

A type specification like varchar(255 char)

Local Features
Name Type
name String
precision Integer?
scale Integer?
size Integer?
unit String?
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

UniqueConstraint Class

A UNIQUE constraint.

Super Classes
Local Features
Name Type
columns List<String>
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
name String?

Update Class

The update of a single column as part of a SQL UPDATE statement.

Local Features
Name Type
column
ColumnRef?
expression
Expression? A
Inherited Features
Name Type
position Position?
origin Origin?
destination Destination?
Used In

Data Types

JoinType E

Types of SQL join.

Values
  • INNER
  • CROSS
  • OUTER_FULL
  • OUTER_LEFT
  • OUTER_RIGHT