Components Listed Alphabetically

C J S T

Name	Syntax and Description
CALCULATED Component	CALCULATED column-alias Refers to columns already calculated in the SELECT clause. Product: Base SAS Document: SAS Viya Workbench: SQL Procedure User’s Guide
column-definition Component	column data-type <column-modifier(s)> Defines PROC SQL's data types and dates Product: Base SAS Document: SAS Viya Workbench: SQL Procedure User’s Guide
column-modifier Component	column-modifier Sets column attributes. Product: Base SAS Document: SAS Viya Workbench: SQL Procedure User’s Guide
column-name Component	column-name Specifies the column to select. Product: Base SAS Document: SAS Viya Workbench: SQL Procedure User’s Guide
CONNECTION TO Component	CONNECTION TO dbms-name \| alias \| (dbms-query) Retrieves and uses DBMS data in a PROC SQL query or view Product: Accessing External Data Sources Document: Accessing External Data Sources with SAS®Viya Workbench
CONNECTION TO Component	CONNECTION TO data- source AS alias (connect statement arguments) (database connection-options); Retrieves and uses data source data in a PROC SQL query or view. Product: SAS/ACCESS Interface to SYSTEM 2000 Document: SAS/ACCESS Interface to PC Files: Reference for SAS Viya Workbench
CONNECTION TO Component	CONNECTION TO dbms-name (dbms-query) CONNECTION TO alias (dbms-query) Retrieves and uses DBMS data in a PROC SQL query or view. Product: Base SAS Document: SAS Viya Workbench: SQL Procedure User’s Guide
joined-table Component	table-name-1 <<AS> alias-1>, table-name-2 <<AS> alias-2> <, table-name-3 <<AS> alias-3, ...>> table-name-1 <<AS> alias-1> <INNER> JOIN table-name-2 <<AS> alias-2> ON sql-expression table-name-1 <<AS> alias-1> LEFT JOIN \| RIGHT JOIN \| FULL JOIN table-name-2 <<AS> alias-2> ON sql-expression table-name-1 <<AS> alias-1> CROSS JOIN table-name-2 <<AS> alias-2> table-name-1 <<AS> alias-1> UNION JOIN table-name-2 <<AS> alias-2> table-name-1 <<AS> alias-1> NATURAL <INNER \| FULL <OUTER> \| LEFT <OUTER> \| RIGHT <OUTER>> JOIN table-name-2 <<AS> alias-2> Joins a table with itself or with other tables or views. Product: Base SAS Document: SAS Viya Workbench: SQL Procedure User’s Guide
sql-expression Component	operand operator operand Produces a value from a sequence of operands and operators. Product: Base SAS Document: SAS Viya Workbench: SQL Procedure User’s Guide
summary-function Component	summary-function (<DISTINCT \| ALL> sql-expression) Performs statistical summary calculations. Product: Base SAS Document: SAS Viya Workbench: SQL Procedure User’s Guide
table-expression Component	SELECT <DISTINCT> object-item-1 <, object-item-2, ...> <INTO :macro-variable-specification-1 <, :macro-variable-specification-2, ...>> FROM from-list <WHERE sql-expression> <GROUP BY group-by-item-1 <, group-by-item-2, ...>> <HAVING sql-expression> Defines part or all of a query expression. Product: Base SAS Document: SAS Viya Workbench: SQL Procedure User’s Guide

Last updated: June 5, 2026