SAS Parser
Parser Documentation
Version: 1.6.1
This document was generated on 2026/02/18.
Introduction
This parser is based on Kolasu, an application of the
StarLasu methodology on the Java Virtual Machine (JVM). The parser has been tested with JVM version 11. Issues related
to serialization have been reported with later versions of the JVM starting with version 16.
Usage
The main entry point is the class com.strumenta.sas.parser.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
Statements
Statement Class
Expressions
ArrayAccessExpression Class
An expression representing the access of an array element by index.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| array |
optional
Expression
A
|
| subscript |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
DateConstantExpression Class
A date constant.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| constant | LocalDate? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
DateTimeConstantExpression Class
A date and time constant.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| constant | LocalDateTime? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
DotExpression Class
A dot (.) expression.
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ExpandedMacroExpression Class
An expression resulting from the expansion of a macro.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| constant | ASTNode? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Expression Class (Abstract) A
An expression as used e.g. in a DATA step.
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
ArrayAccessExpression
DateConstantExpression
DateTimeConstantExpression
DotExpression
ExpandedMacroExpression
ExpressionError
FloatConstantExpression
InformatExpression
IntConstantExpression
OfExpression
OperatorApplicationExpression
SASString
SASStringComposed
SASStringConstant
SASStringMacroVariable
SetMembershipCheckExpression
StringConstantExpression
UnparsableDateConstantExpression
UnparsableDateTimeConstantExpression
VariableExpression
Used In
Argument
ArrayAccessExpression
OperatorApplicationExpression
SetMembershipCheckExpression
VariableDeclaration
MacroPutMacroStatement
MacroIfMacroStatement
MacroDoMacroStatement
IncludeMacroStatement
AbortMacroStatement
MacroArgument
FileOption
OptionStatement
WhereStatement
ExpandProcedureOption
ExportStatement
FormatProcedureOption
HttpOption
FilenameStatement
ExportProcedure
TitleStatement
Query
Projection
JoinRelation
PartitionClauseValue
UpdateColumn
SqlUpdateSqlStatement
SqlMergeSqlStatement
SqlDeleteSqlStatement
RowExpression
CreateIndexTableClause
CommentSqlStatement
ConnectOption
CaseExpression
CastExpression
SqlFunctionCallExpression
SetExpression
SelectClause
Retain
RenameStatement
LinePointerControl
ColumnPointerControl
LabelStatement
IfStatement
FileStatement
ExpressionStatement
DoStatement
DeclareOption
AssignmentStatement
ArrayStatement
ExpressionError Class
A node representing a malformed expression.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| message | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
FloatConstantExpression Class
A float literal.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| constant | EBigDecimal |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
InformatExpression Class
An informat expression.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| format | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
IntConstantExpression Class
An integer literal.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| constant | EBigInteger |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
OfExpression Class
An "of" expression.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| variables |
optional
VariableList
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
OperatorApplicationExpression Class
An operator application such as a sum, subtraction, multiplication, ...
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| operands |
list of
Expression
A
|
| operator | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SASString Class (Abstract) A
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
SASStringComposed Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| stringContents |
list of
SASString
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SASStringConstant Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| text | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
SASStringMacroVariable Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| macro |
optional
VariableExpression
|
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| element |
optional
Expression
A
|
| negated | Boolean |
| set |
optional
VariableExpression
|
| values |
list of
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
StringConstantExpression Class
A string literal.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| constant | String |
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| constant | String |
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| constant | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
VariableExpression Class
An expression whose value is the value of a variable.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| variable | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
Classes
Argument Class
A function argument consisting of a value and an optional name.
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
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 and Description |
|---|---|
| name | String |
| namespace |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
Identifier
VariableRangeWithPrefix
VariableRangeByNumber
VariableRangeByName
Variable
Argument
LocalMacroStatement
GlobalMacroStatement
FileOption
BySpecification
OptionStatement
DatasetsRenameStatement
IndexDatasetOption
DatasetsChangeStatement
AppendProcedureOption
ContentsProcedureOption
ExpandProcedureOption
ExpandConvertStatement
ExportStatement
FormatProcedureOption
FreqProcedureOption
A
FreqProcedureOptionVariable
FreqProcedureTableOption
FreqProcedureTableStatement
FreqProcedureTablesStatement
HttpOption
ImportOption
ImportStatement
PrintToProcedureOptionSwitch
TimeseriesProcedureOption
A
TimeseriesProcedureOptionValues
TimeseriesIdStatement
TimeseriesVarOption
TransposeProcedureOptionString
TransposeProcedureOptionFlag
TransposeProcedureOptionDataset
FilenameStatement
ExportProcedure
LibrarySpecification
LibraryNameStatement
TimeseriesVarStatement
TransposeIdStatement
QueryRelation
Projection
NativeQueryRelation
PartitionClauseName
SqlRenameSqlStatement
CreateIndexClusterClause
ConnectOption
ConnectSqlStatement
Option
KeySetOption
EndSetOption
Retain
RenameStatement
InputVariableSpecification
A
PutSpecification
PutLogStatement
OutputStatement
LabelStatement
FormatVariableRange
DoStatement
DeleteStatement
DeclareStatement
DeclareOption
SingleAttribStatement
AssignmentStatement
ArrayStatement
NodeWithAutoChildren Class
A node that automatically adds other nodes as children when passed into its constructor.
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
ArrayAccessExpression
DateConstantExpression
DateTimeConstantExpression
DotExpression
ExpandedMacroExpression
Expression
ExpressionError
FloatConstantExpression
Identifier
InformatExpression
IntConstantExpression
OfExpression
OperatorApplicationExpression
SASString
SASStringComposed
SASStringConstant
SASStringMacroVariable
SetMembershipCheckExpression
StringConstantExpression
UnparsableDateConstantExpression
UnparsableDateTimeConstantExpression
Variable
VariableExpression
VariableList
VariableRangeByName
VariableRangeByNumber
VariableRangeWithPrefix
Variables
SasConstantString Class
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
SasStringContents Class
Local Features
| Name | Type and Description |
|---|---|
| constantString |
list of
SasConstantString
|
| stringLiteral |
list of
SasStringLiteral
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
SasStringLiteral Class
Local Features
| Name | Type and Description |
|---|---|
| stringContents |
optional
SasStringContents
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
SourceFile Class
An entire SAS source file.
Local Features
| Name | Type and Description |
|---|---|
| statementsAndDeclarations | List<ASTNode> |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
TypeSpec Class
A type specification like `varchar(255 char)`
Local Features
| Name | Type and Description |
|---|---|
| name | String |
| precision | Integer? |
| scale | Integer? |
| size | Integer? |
| unit | String? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
Variable Class
A single variable.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
VariableList Class (Abstract) A
A specification of one of more variables, such as in an ["of" expression] [OfExpression] . This is an abstract class; see its subclasses for possible implementations.
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| 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
| Name | Type and Description |
|---|---|
| from |
optional
Identifier
|
| to |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
VariableRangeByNumber Class
A range of numbered variables, e.g. v1-v9.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| from |
optional
Identifier
|
| to |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
VariableRangeWithPrefix Class
Variables having the same prefix, e.g., `of dateof:`.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| prefix |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| variables |
list of
VariableList
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Statements
ArrayStatement Class
An ARRAY statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| autoDim | Boolean |
| dimensions |
list of
Expression
A
|
| dollar | Boolean |
| from |
optional
Identifier
|
| list |
list of
Identifier
|
| name |
optional
Identifier
|
| to |
optional
Identifier
|
AssignmentStatement Class
An assignment to a variable.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
Expression
A
|
AttribStatement Class
An ATTRIB statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| attrib |
list of
SingleAttribStatement
|
CallStatement Class
A CALL statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| call |
optional
OtherFunctionCallExpression
|
DataStatement Class (Abstract) A
A statement belonging to a DATA step.
Super Classes
Subclasses
ArrayStatement
AssignmentStatement
AttribStatement
CallStatement
DataStepEmptyStatement
DeclareOption
DeclareStatement
DeleteStatement
DoStatement
DropStatement
ExpressionStatement
FileSendStatement
FileStatement
FormatStatement
IfStatement
InputStatement
KeepStatement
LabelStatement
LengthStatement
MacroStatementWrapper
MergeStatement
OutputStatement
PutLogStatement
PutStatement
RenameStatement
Retain
RetainStatement
ReturnStatement
SelectClause
SelectStatement
SetStatement
StatementError
StopStatement
UpdateStatement
Used In
DataStepEmptyStatement Class
DeclareOption Class
An option in a DECLARE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| dataset |
optional
DatasetSpec
|
| expression |
optional
Expression
A
|
| name |
optional
Identifier
|
Used In
DeclareStatement Class
A DECLARE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| options |
list of
DeclareOption
|
| type |
optional
Identifier
|
DeleteStatement Class
A DELETE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| identifier |
optional
Identifier
|
DoStatement Class
A DO statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| body |
list of
DataStatement
A
|
| iterateBy |
optional
Expression
A
|
| iterateFrom |
optional
Expression
A
|
| iterateTo |
optional
Expression
A
|
| iterateUntil |
optional
Expression
A
|
| iterateWhile |
optional
Expression
A
|
| iterationVariable |
optional
Identifier
|
DropStatement Class
A DROP statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| datasets |
list of
DatasetSpec
|
ExpressionStatement Class
An expression statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| expression |
optional
Expression
A
|
FileSendStatement Class
FILE SEND statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| from |
list of
SASString
A
|
| subject | String |
| to |
list of
SASString
A
|
FileStatement Class
A FILE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| expression |
optional
Expression
A
|
| options |
list of
FileOption
|
FormatStatement Class
A FORMAT statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| formats |
list of
FormatSpec
|
IfStatement Class
An IF statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| condition |
optional
Expression
A
|
| elseStatement |
optional
DataStatement
A
|
| thenStatement |
optional
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 and Description |
|---|---|
| holdAcross | Boolean |
| holdWithin | Boolean |
| specifications |
list of
InputSpecification
A
|
KeepStatement Class
A KEEP statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| variables |
optional
VariableList
A
|
LabelStatement Class
A LABEL statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| expression |
list of
Expression
A
|
| names |
list of
Identifier
|
LengthStatement Class
MacroStatementWrapper Class
A macro statement in a data step context.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| macroStatement |
optional
Statement
|
MergeStatement Class
A MERGE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| datasets |
list of
DatasetSpec
|
OutputStatement Class
An OUTPUT statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| identifier |
optional
Identifier
|
PutLogStatement Class
PUTLOG statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| identifier |
optional
Identifier
|
| informat | String? |
| message | String |
PutStatement Class
A PUT statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| at | Boolean |
| dollar | Boolean |
| putBuilder |
optional
MacroDoMacroStatement
|
| specifications |
list of
PutSpecification
|
RenameStatement Class
A RENAME statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| expression |
list of
Expression
A
|
| names |
list of
Identifier
|
Retain Class
A single element in a RETAIN statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| expression |
optional
Expression
A
|
| identifiers |
list of
Identifier
|
Used In
RetainStatement Class
ReturnStatement Class
SelectClause Class
A single clause in a SELECT statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| condition |
optional
Expression
A
|
| statement |
optional
DataStatement
A
|
Used In
SelectStatement Class
A SELECT statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| clauses |
list of
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
| Name | Type and Description |
|---|---|
| options |
list of
SetOption
A
|
| setBuilder |
optional
MacroDoMacroStatement
|
| sets |
list of
SetSpecification
|
StatementError Class
An invalid or otherwise unsupported data step statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| message | String |
StopStatement Class
Super Classes
UpdateStatement Class
An UPDATE statement in a DATA STEP.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| by |
optional
ByStatement
|
| master |
optional
DatasetSpec
|
| transaction |
optional
DatasetSpec
|
Classes
ColumnInput Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| character | Boolean |
| end | Integer? |
| start | Integer |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| suppress | Boolean |
| suppressNoError | Boolean |
| variable |
optional
Identifier
|
ColumnPointerControl Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| by |
optional
Expression
A
|
| to |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
DataStep Class
A DATA step.
Local Features
| Name | Type and Description |
|---|---|
| datasets |
list of
DatasetSpec
|
| options |
list of
Option
|
| statements |
list of
Statement
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
EndSetOption Class
An END option in a SET statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| end |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
FormatSpec Class
A format specification.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| format | String |
| names |
list of
FormatVariableRange
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
FormatVariableRange Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| toVariable |
optional
Identifier
|
| variable |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
FormattedInput Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| informat | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| suppress | Boolean |
| suppressNoError | Boolean |
| variable |
optional
Identifier
|
InputSpecification Class (Abstract) A
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
ColumnInput
ColumnPointerControl
FormattedInput
InputVariableSpecification
LinePointerControl
ListInput
NamedInput
PointerControl
Used In
InputVariableSpecification Class (Abstract) A
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| suppress | Boolean |
| suppressNoError | Boolean |
| variable |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
KeySetOption Class
A KEY option in a SET statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| key |
optional
Identifier
|
| unique | Boolean |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
LengthSpec Class
A length specification as part of a LENGTH statement.
Local Features
| Name | Type and Description |
|---|---|
| character | Boolean |
| format | String |
| names |
list of
SASString
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
LinePointerControl Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| next | Boolean? |
| to |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ListInput Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| blanks | Boolean |
| character | Boolean |
| informat | String? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| suppress | Boolean |
| suppressNoError | Boolean |
| variable |
optional
Identifier
|
NamedInput Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| character | Boolean |
| informat | String? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| suppress | Boolean |
| suppressNoError | Boolean |
| variable |
optional
Identifier
|
Option Class
A DATA step option.
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
PointerControl Class (Abstract) A
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| prefix |
optional
DatasetSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| named |
optional
Identifier
|
| pointerControl |
optional
PointerControl
A
|
| string | String? |
| times | Integer? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
SetOption Class (Abstract) A
A SET statement option.
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
SetSpecification Class
An individual clause in a SET statement.
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
DatasetSpec
|
| value |
optional
DatasetSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| format | String? |
| identifier |
optional
Identifier
|
| informat | String? |
| label | String? |
| length | String? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
Statements
AbortMacroStatement Class
A %ABORT statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| returnValue |
optional
Expression
A
|
| type | String |
GlobalMacroStatement Class
A %GLOBAL statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| variables |
list of
Identifier
|
IncludeMacroStatement Class
A %INCLUDE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| resource |
optional
Expression
A
|
LocalMacroStatement Class
A %LOCAL statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| variables |
list of
Identifier
|
MacroComment Class
A commented-out macro statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| text | String |
MacroDoMacroStatement Class
A %DO statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| body | List<ASTNode> |
| iterateFrom |
optional
Expression
A
|
| iterateTo |
optional
Expression
A
|
| iterationVariable | String? |
| untilCondition |
optional
Expression
A
|
| whileCondition |
optional
Expression
A
|
Used In
MacroGotoMacroStatement Class
A %GOTO statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| label | String |
MacroIfMacroStatement Class
An %IF statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| alternative | List<ASTNode> |
| condition |
optional
Expression
A
|
| consequence | List<ASTNode> |
MacroLabelMacroStatement Class
A %LABEL statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| label | String |
MacroPutMacroStatement Class
A %PUT statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| expression |
optional
Expression
A
|
MacroStatement Class (Abstract) A
A macro statement.
Super Classes
Subclasses
MacroStatementError Class
An invalid or otherwise unsupported macro statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| message | String |
PlainTextMacroStatement Class
Macro text that couldn't be parsed as valid SAS or SQL code.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| text | String |
VariableDeclaration Class
A macro variable declaration (`%LET foo = ...`).
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| expression |
optional
Expression
A
|
| name | String |
Expressions
MacroArgument Class
A macro argument, either in a [macro definition] [MacroDefinition] or in a [macro function call] [MacroFunctionCallExpression] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name | String? |
| value |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
MacroExpression Class (Abstract) A
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
MacroExpressionError Class
An invalid or otherwise unsupported macro expression.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| message | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Classes
MacroDefinition Class
A macro function definition.
Local Features
| Name | Type and Description |
|---|---|
| arguments |
list of
MacroArgument
|
| body | List<ASTNode> |
| name | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Statements
ByStatement Class
BY statement, that can appear in various PROCedures and in the DATA step.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| specifications |
list of
BySpecification
|
Used In
ClassStatement Class
Super Classes
Comment Class
A commented-out statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| text | String |
DatasetsChangeStatement Class
A CHANGE statement in a PROC DATASETS section.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| from |
optional
Identifier
|
| to |
optional
Identifier
|
DatasetsCopyStatement Class
A COPY statement in a PROC DATASETS section.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| in | String? |
| options |
list of
CopyOption
|
| out | String |
DatasetsCreateIndexStatement Class
A CREATE INDEX statement in a PROC DATASETS section.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name | String |
DatasetsDeleteStatement Class
A DELETE statement in a PROC DATASETS section.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| dataset |
list of
DatasetSpec
|
DatasetsModifyStatement Class
A MODIFY statement in a PROC DATASETS section.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name | String |
DatasetsRenameStatement Class
A RENAME statement in a PROC DATASETS section.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| from |
optional
Identifier
|
| to |
optional
Identifier
|
DatasetsSelectStatement Class
A SELECT statement in a PROC DATASETS section.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name | String |
DatasetsStatement Class (Abstract) A
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 and Description |
|---|---|
| accessMethod | String? |
| externalFile |
list of
Expression
A
|
| fileref |
optional
Identifier
|
| options |
list of
FileOption
|
IdStatement Class
Super Classes
LibraryNameStatement Class
A LIBNAME statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| all | Boolean |
| clear | Boolean |
| library |
optional
Identifier
|
| list | Boolean |
| options |
list of
OptionStatement
|
| specifications |
list of
LibrarySpecification
|
ODSStatement Class
Super Classes
OptionStatement Class
A single option in an [OPTION statement] [OptionsStatement] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| values |
list of
Expression
A
|
Used In
OptionsStatement Class
An OPTION statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
OptionStatement
|
OtherEmptyStatement Class
PerformanceOption Class
An option for a [PERFORMANCE statement] [PerformanceStatement.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| options |
list of
PerformanceOption
|
QuitStatement Class
RunStatement Class
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 and Description |
|---|---|
| expression |
optional
Expression
A
|
| line | Integer |
TransposeIdStatement Class
An ID statement for [PROC TRANSPOSE] [TransposeProcedure.statements] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| tid |
optional
Identifier
|
VarStatement Class
Super Classes
WhereStatement Class
A WHERE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| expression |
optional
Expression
A
|
Expressions
MethodCallExpression Class
A method call (e.g. `foo.bar()`).
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| arguments |
list of
Argument
|
| method | String |
| receiver | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
OtherFunctionCallExpression Class
A function call.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| arguments |
list of
Argument
|
| function | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
Classes
AppendProcedure Class
PROC APPEND.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
AppendProcedureOption
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
AppendProcedureOption Class
An option for [PROC APPEND] [AppendProcedure.options] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
DatasetSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
BySpecification Class
A single element in a [BY statement] [ByStatement] .
Local Features
| Name | Type and Description |
|---|---|
| descending | Boolean |
| identifier |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
CompareProcedure Class
PROC COMPARE.
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ComputedDatasetOption Class
A dataset option or options computed by a macro.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| computedWith |
optional
Statement
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ContentsProcedure Class
PROC CONTENTS.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
ContentsProcedureOption
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ContentsProcedureOption Class
An option for [PROC CONTENTS] [ContentsProcedure.options] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
DatasetSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
CopyOption Class
An option in a COPY statement.
Local Features
| Name | Type and Description |
|---|---|
| name | String |
| value | String? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
DatasetOption Class (Abstract) A
A dataset option.
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
ComputedDatasetOption
DropDatasetOption
ExtendObsCounterDatasetOption
GenNumDatasetOption
GenericDatasetOption
InDatasetOption
IndexDatasetOption
KeepDatasetOption
LabelDatasetOption
RenameDatasetOption
WhereDatasetOption
Used In
DatasetProcedureOption Class (Abstract) A
A PROC DATASETS option.
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| name | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
DatasetProcedureOptionGennum Class
A PROC DATASETS GENNUM option.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| value | String |
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| name | String |
| value | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
DatasetSpec Class
A dataset specification.
Local Features
| Name | Type and Description |
|---|---|
| computedWith | ASTNode? |
| library | String? |
| name | ASTNode? |
| options |
list of
DatasetOption
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
DatasetsDeleteStatement
AppendProcedureOption
ContentsProcedureOption
DeleteProcedure
FreqProcedureOptionDataset
FreqProcedureTableOption
SortProcedureOutOption
SortProcedureOptionSwitch
SortProcedureDataOption
TimeseriesProcedureOptionDataset
TransposeProcedureOptionDataset
ExportProcedure
ImportOptionDataset
DataStep
UpdateStatement
SetSpecification
MergeStatement
DropStatement
DeclareOption
PrefixSetSpecification
DatasetsProcedure Class
A PROC DATASETS section.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
DatasetProcedureOption
A
|
| statements |
list of
DatasetsStatement
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
DeleteProcedure Class
PROC DELETE.
Local Features
| Name | Type and Description |
|---|---|
| dataFile |
optional
DatasetSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
DropDatasetOption Class
A DROP dataset option.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| variables |
optional
VariableList
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ExpandConvertStatement Class
A CONVERT statement for [PROC EXPAND] [ExpandProcedure.statements] .
Local Features
| Name | Type and Description |
|---|---|
| newName |
optional
Identifier
|
| variable |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ExpandIdStatement Class
An ID statement for [PROC EXPAND] [ExpandProcedure.statements] .
Local Features
| Name | Type and Description |
|---|---|
| name | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ExpandProcedure Class
PROC EXPAND.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
ExpandProcedureOption
|
| statements | List<ASTNode> |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ExpandProcedureOption Class
An option for [PROC EXPAND] [ExpandProcedure.options] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
ExportProcedure Class
PROC EXPORT.
Local Features
| Name | Type and Description |
|---|---|
| dataset |
optional
DatasetSpec
|
| dbms |
optional
Identifier
|
| label | Boolean |
| outFile |
optional
Expression
A
|
| outTable |
optional
Expression
A
|
| replace | Boolean |
| statements |
list of
ExportStatement
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ExportStatement Class
An export statement for [PROC EXPORT] [ExportProcedure.statements] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
ExtendObsCounterDatasetOption Class
An EXTENDOBSCOUNTER dataset option.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| extend | Boolean |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
FileOption Class
A file option.
Local Features
| Name | Type and Description |
|---|---|
| expression |
optional
Expression
A
|
| identifier |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
FormatProcedure Class
PROC FORMAT.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
FormatProcedureOption
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
FormatProcedureOption Class
An option for [PROC FORMAT] [FormatProcedure.options] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
FreqProcedure Class
PROC FREQ.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
FreqProcedureOption
A
|
| statements | List<ASTNode> |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
FreqProcedureOption Class (Abstract) A
An option for [PROC FREQ] [FreqProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
FreqProcedureOptionDataset Class
A dataset option for [PROC FREQ] [FreqProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| value |
optional
DatasetSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| name |
optional
Identifier
|
FreqProcedureOptionVariable Class
A variable option for [PROC FREQ] [FreqProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| variable |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| name |
optional
Identifier
|
FreqProcedureTableOption Class
An option in a TABLE statement for [PROC FREQ] [FreqProcedure.statements] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
DatasetSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
FreqProcedureTableStatement Class
A TABLE statement for [PROC FREQ] [FreqProcedure.statements] .
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
FreqProcedureTableOption
|
| table |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
FreqProcedureTablesStatement Class
A TABLES statement for [PROC FREQ] [FreqProcedure.statements] .
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
Identifier
|
| tables |
list of
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
GenNumDatasetOption Class
A GENNUM dataset option.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| value | String |
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| name | String |
| value | String? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
HttpOption Class
An option for [PROC IMPORT] [ImportProcedure.options] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
HttpProcedure Class
PROC HTTP.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
HttpOption
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ImportOption Class
An option for [PROC IMPORT] [ImportProcedure.options] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
ImportOptionDataset Class
A dataset option for [PROC IMPORT] [ImportProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| dataset |
optional
DatasetSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| name |
optional
Identifier
|
ImportOptionString Class
A string option for [PROC IMPORT] [ImportProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| value |
optional
SASString
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| name |
optional
Identifier
|
ImportProcedure Class
PROC IMPORT.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
ImportOption
|
| statements |
list of
ImportStatement
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ImportStatement Class
A statement for [PROC IMPORT] [ImportProcedure.statements] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value | ASTNode? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
InDatasetOption Class
An IN dataset option.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| variables |
optional
VariableList
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| name | String? |
| variables |
list of
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
KeepDatasetOption Class
A KEEP dataset option.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| variables |
optional
VariableList
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
LabelDatasetOption Class
A LABEL dataset option.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| label | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
LibrarySpecification Class
A single library specification in a [LIBNAME statement] [LibraryNameStatement] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
SASString
A
|
| reference |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
MeansProcedure Class
PROC MEANS.
Local Features
| Name | Type and Description |
|---|---|
| statements |
list of
Statement
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ModelDataOption Class
A dataset option for [PROC MODEL] [ModelProcedure.options] and [PROC TMODEL] [TModelProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| datasetName | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ModelNoPrintOption Class
A NOPRINT option for [PROC MODEL] [ModelProcedure.options] and [PROC TMODEL] [TModelProcedure.options] .
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ModelOption Class (Abstract) A
An option for [PROC MODEL] [ModelProcedure.options] and [PROC TMODEL] [TModelProcedure.options] .
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
ModelProcedure Class
PROC MODEL.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
ModelOption
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
PrintToProcedure Class
PROC PRINTTO.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
PrintToProcedureOption
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
PrintToProcedureOption Class (Abstract) A
An option for [PROC PRINTTO] [PrintToProcedure.options] .
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
PrintToProcedureOptionFlag Class
An option for [PROC PRINTTO] [PrintToProcedure.options] that can only be present or absent.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
PrintToProcedureOptionSwitch Class
An option for [PROC PRINTTO] [PrintToProcedure.options] that has an associated value.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name | String |
| stringValue | String? |
| variableValue |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Rename Class
A single rename specification in a RENAME dataset option.
Local Features
| Name | Type and Description |
|---|---|
| from | String |
| to | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
RenameDatasetOption Class
A RENAME dataset option.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| renames |
list of
Rename
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SGPlotProcedure Class
PROC SGPLOT.
Local Features
| Name | Type and Description |
|---|---|
| statements | List<ASTNode> |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SortProcedure Class
PROC SORT.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
SortProcedureOption
A
|
| statements | List<ASTNode> |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SortProcedureDataOption Class
A DATA option for [PROC SORT] [SortProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| dataset |
optional
DatasetSpec
|
| datasetFile | String? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SortProcedureOption Class (Abstract) A
An option for [PROC SORT] [SortProcedure.options] .
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
SortProcedureDataOption
SortProcedureOptionFlag
SortProcedureOptionSwitch
SortProcedureOutOption
SortProcedureSizeOption
Used In
SortProcedureOptionFlag Class
An option for [PROC SORT] [SortProcedure.options] that can only be present or absent.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SortProcedureOptionSwitch Class
An option for [PROC SORT] [SortProcedure.options] that has an associated value.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name | String |
| stringValue | String? |
| value |
optional
DatasetSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SortProcedureOutOption Class
An OUT option for [PROC SORT] [SortProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| dataset |
optional
DatasetSpec
|
| datasetFile | String? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SortProcedureSizeOption Class
A SORTSIZE option for [PROC SORT] [SortProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| memorySpec | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SummaryProcedure Class
PROC SUMMARY.
Local Features
| Name | Type and Description |
|---|---|
| statements |
list of
Statement
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
TModelProcedure Class
PROC TMODEL.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
ModelOption
A
|
| statements | List<ASTNode> |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
TimeseriesIdStatement Class
An ID statement for [PROC TIMESERIES] [TimeseriesProcedure.statements] .
Local Features
| Name | Type and Description |
|---|---|
| interval |
optional
Identifier
|
| ptid |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
TimeseriesProcedure Class
PROC TIMESERIES.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
TimeseriesProcedureOption
A
|
| statements | List<ASTNode> |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
TimeseriesProcedureOption Class (Abstract) A
An option for [PROC TIMESERIES] [TimeseriesProcedure.options] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
TimeseriesProcedureOptionDataset Class
A dataset option for [PROC TIMESERIES] [TimeseriesProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| value |
optional
DatasetSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| name |
optional
Identifier
|
TimeseriesProcedureOptionValues Class
A values option for [PROC TIMESERIES] [TimeseriesProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| values |
list of
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| name |
optional
Identifier
|
TimeseriesVarOption Class
An option for the [VAR statement] [TimeseriesVarStatement] for [PROC TIMESERIES] [TimeseriesProcedure.statements] .
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
TimeseriesVarStatement Class
A VAR statement for [PROC TIMESERIES] [TimeseriesProcedure.statements] .
Local Features
| Name | Type and Description |
|---|---|
| cross | Boolean |
| options |
list of
TimeseriesVarOption
|
| variables |
list of
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
TransposeProcedure Class
PROC TRANSPOSE.
Local Features
| Name | Type and Description |
|---|---|
| options |
list of
TransposeProcedureOption
A
|
| statements | List<ASTNode> |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
TransposeProcedureOption Class (Abstract) A
An option for [PROC TRANSPOSE] [TransposeProcedure.options] .
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
TransposeProcedureOptionDataset Class
A dataset option for [PROC TRANSPOSE] [TransposeProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
DatasetSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
TransposeProcedureOptionFlag Class
An option for [PROC TRANSPOSE] [TransposeProcedure.options] that can only be present or absent.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
TransposeProcedureOptionString Class
A string option for [PROC TRANSPOSE] [TransposeProcedure.options] .
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
WhereDatasetOption Class
A WHERE dataset option.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| condition | Expression? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Expressions
AllColumnsExpression Class
"All columns", that is, `*` as in `select * from customers`
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| table |
optional
TableRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
CaseExpression Class
A case...when... expression.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| conditions |
list of
Expression
A
|
| elseResult |
optional
Expression
A
|
| expression |
optional
Expression
A
|
| results |
list of
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
CastExpression Class
A cast expression, such as `CAST (a + b) AS FLOAT`
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| expression |
optional
Expression
A
|
| type |
optional
TypeSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ColumnExpression Class
An expression referring to a column, like `a.b` in `a.b + 1`
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| column |
optional
ColumnRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
ExistsExpression Class
(not) exists (select ...)
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| negated | Boolean |
| query |
optional
Query
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
NoJoinCondition Class
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
NullConstantExpression Class
A literal NULL
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
QueryExpression Class
Select query expression, as in `where foo = (select foo from bar)`
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| query |
optional
Query
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
RowExpression Class
A single row in a values expression. see ValuesExpression
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| values |
list of
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
SetExpression Class
Set membership expression such as `x IN ...`
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| element |
optional
Expression
A
|
| op | String |
| query |
optional
Query
|
| values |
list of
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SqlFunctionCallExpression Class
A function call such as `MIN(foo)`.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| arguments |
list of
Expression
A
|
| function | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
TrimFunctionCallExpression Class
A call to the TRIM function using specialized syntax, such as `TRIM(LEADING FROM foo)`.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| leading | Boolean |
| trailing | Boolean |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| arguments |
list of
Expression
A
|
| function | 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 and Description |
|---|---|
| rows |
list of
RowExpression
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
Classes
AlterTableSqlStatement Class (Abstract) A
A SQL ALTER TABLE statement.
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
AnalyzeSqlStatement Class
A SQL ANALYZE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| statisticClause |
optional
StatisticClause
A
|
| table |
optional
TableRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
ColumnDefinition Class
The definition of a single column in a CREATE TABLE statement.
Local Features
| Name | Type and Description |
|---|---|
| constraints |
list of
Constraint
A
|
| name | String |
| type |
optional
TypeSpec
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
ColumnRef Class
A (possibly scoped) reference to a column.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| calculated | Boolean |
| column | String |
| table |
optional
TableRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
CommentSqlStatement Class
A SQL COMMENT statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| comment | String |
| ref |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
CommitSqlStatement Class
A SQL COMMIT statement.
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
ConnectOption Class
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
| value |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
ConnectSqlStatement Class
A connect statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| connection |
optional
Identifier
|
| kind |
optional
Identifier
|
| options |
list of
ConnectOption
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
Constraint Class (Abstract) A
A SQL constraint.
Local Features
| Name | Type and Description |
|---|---|
| name | String? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
CreateIndexClause Class (Abstract) A
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
CreateIndexClusterClause Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| cluster |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
CreateIndexSqlStatement Class
A SQL CREATE INDEX statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| clause |
optional
CreateIndexClause
A
|
| index |
optional
ColumnRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
CreateIndexTableClause Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| indexes |
list of
Expression
A
|
| table |
optional
TableRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
CreateTableSqlStatement Class
A SQL CREATE TABLE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| columnDefinitions |
list of
ColumnDefinition
|
| constraints |
list of
Constraint
A
|
| ifNotExists | Boolean |
| on | String? |
| query |
optional
Query
|
| table |
optional
TableRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
CreateViewSqlStatement Class
A SQL CREATE VIEW statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| query |
optional
Query
|
| view |
optional
TableRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
DescribeSqlStatement Class
A SQL DESCRIBE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| table |
optional
TableRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
DisconnectSqlStatement Class
A disconnect statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| connection | String? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
ExecuteSqlStatement Class
An execute statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| by | String? |
| nativeSQL |
optional
NativeSQL
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
Grouping Class (Abstract) A
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
IdentityConstraint Class
An identity constraint.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| increment | Integer |
| seed | Integer |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| name | String? |
InsertSqlStatement Class
A SQL INSERT statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| columns |
list of
ColumnRef
|
| hints |
list of
SASStringConstant
|
| query |
optional
Query
|
| table |
optional
TableRef
|
| values |
optional
ValuesExpression
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
JoinRelation Class
A join relation, as in `SELECT * FROM foo JOIN bar...`.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| conditions |
list of
Expression
A
|
| joinTypes |
list of
JoinTypeValue
|
| relations |
list of
Relation
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
JoinTypeValue Class
Local Features
| Name | Type and Description |
|---|---|
| value |
JoinType
E
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
MacroSqlStatement Class
A macro statement inside PROC SQL.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| statement | ASTNode? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
NativeQueryRelation Class
A native subquery relation, as in `SELECT * FROM CONNECTION TO ... (SELECT ...)`.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| alias | String? |
| connection |
optional
Identifier
|
| query |
optional
NativeSQL
|
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| parsed | ASTNode? |
| text | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
NullabilityConstraint Class
A NULL/NOT NULL constraint.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| nullsAllowed | Boolean |
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| ascending | Boolean |
| column |
optional
ColumnRef
|
| columnIndex | Integer? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
PartitionClauseName Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| name |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
PartitionClauseValue Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| expression |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
PartitionExtensionClause Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| partitions |
list of
PartitionExtensionRef
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
PartitionExtensionOption Class (Abstract) A
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
PartitionExtensionRef Class (Abstract) A
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
PrimaryKeyConstraint Class
A primary key constraint.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| columns |
list of
SASStringConstant
|
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| alias |
optional
Identifier
|
| expression |
optional
Expression
A
|
| format | String? |
| label | String? |
| length | String? |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
Query Class
A SQL SELECT query.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| condition |
optional
Expression
A
|
| distinct | Boolean |
| groupings |
list of
Grouping
A
|
| havingCondition |
optional
Expression
A
|
| orderings |
list of
Ordering
|
| projections |
list of
Projection
|
| relations |
list of
Relation
A
|
| resultsStore |
list of
QueryResultsStore
|
| union |
optional
Query
|
| unionAll | Boolean |
| unique | Boolean |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
Used In
QueryRelation Class
A subquery relation, as in `SELECT * FROM (SELECT ...)`.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| alias | String? |
| connection |
optional
Identifier
|
| query |
optional
Query
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
QueryResultsStore Class
The target of a SELECT INTO clause.
Local Features
| Name | Type and Description |
|---|---|
| separatedBy | String? |
| toVariable | String? |
| variable | String |
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
RelationError Class
An invalid relation, due to some error in the source code.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| message | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SQLComment Class
Local Features
| Name | Type and Description |
|---|---|
| text | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
SchemaRef Class
A (possibly scoped) reference to a schema.
Local Features
| Name | Type and Description |
|---|---|
| catalog | String? |
| schema | String |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
SqlDeleteSqlStatement Class
A SQL DELETE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| condition |
optional
Expression
A
|
| hints |
list of
SASStringConstant
|
| table |
optional
TableRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
SqlDropSqlStatement Class
A SQL DROP TABLE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| table |
optional
TableRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
SqlEmptySqlStatement Class
An empty statement, i.e. a lone semicolon.
Super Classes
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
SqlMergeSqlStatement Class
A MERGE statement (MS SQL Server only).
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| hints |
list of
SASStringConstant
|
| into |
optional
TableRelation
|
| on |
optional
Expression
A
|
| using |
optional
Relation
A
|
| whenMatched |
optional
SqlStatement
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
SqlProcedure Class
PROC SQL.
Local Features
| Name | Type and Description |
|---|---|
| feedback | Boolean |
| noPrint | Boolean |
| sqlStatements |
list of
SqlStatement
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
SqlRenameSqlStatement Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| from |
optional
Identifier
|
| to |
optional
Identifier
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
SqlStatement Class (Abstract) A
A SQL statement or query.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
AlterTableSqlStatement
AnalyzeSqlStatement
CommentSqlStatement
CommitSqlStatement
ConnectSqlStatement
CreateIndexSqlStatement
CreateTableSqlStatement
CreateViewSqlStatement
DescribeSqlStatement
DisconnectSqlStatement
ExecuteSqlStatement
InsertSqlStatement
MacroSqlStatement
Query
SqlDeleteSqlStatement
SqlDropSqlStatement
SqlEmptySqlStatement
SqlMergeSqlStatement
SqlRenameSqlStatement
SqlUpdateSqlStatement
TruncateSqlStatement
Used In
SqlUpdateSqlStatement Class
A SQL UPDATE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| condition |
optional
Expression
A
|
| table |
optional
TableRelation
|
| updates |
list of
Update
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
StatisticClause Class (Abstract) A
A STATISTIC clause.
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
SubpartitionExtensionClause Class
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| subpartitions |
list of
PartitionExtensionRef
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
TableRef Class
A (possibly scoped) reference to a table or view.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| schema |
optional
SchemaRef
|
| table | String |
Inherited Features
| Name | Type and Description |
|---|---|
| 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 and Description |
|---|---|
| alias | String? |
| partition |
optional
PartitionExtensionOption
A
|
| table |
optional
TableRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Used In
TruncateSqlStatement Class
A SQL TRUNCATE TABLE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| table |
optional
TableRef
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| comments |
list of
SQLComment
|
| replacedVariables | Boolean |
UniqueConstraint Class
A UNIQUE constraint.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| columns |
list of
SASStringConstant
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
| name | String? |
Update Class (Abstract) A
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Subclasses
Used In
UpdateColumn Class
The update of a single column as part of a SQL UPDATE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| column |
optional
ColumnRef
|
| expression |
optional
Expression
A
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
UpdateWithQuery Class
The update of multiple columns with a Query as part of a SQL UPDATE statement.
Super Classes
Local Features
| Name | Type and Description |
|---|---|
| columns |
list of
ColumnRef
|
| query |
optional
Query
|
Inherited Features
| Name | Type and Description |
|---|---|
| position | Position? |
| origin | Origin? |
| destination | Destination? |
Data Types
JoinType E
Types of SQL join.
Values
- INNER
- CROSS
- OUTER_FULL
- OUTER_LEFT
- OUTER_RIGHT