Glossary
- alias
a temporary, alternate name assigned to a table for use in a join query.
- base table
a primary table.
- CALCULATED column
a column that is used in the same SELECT statement in which the calculation occurs.
- Cartesian product
a type of join that yields all the possible combinations of rows and columns.
- case expression
an expression that specifies relations among columns and values in conditional logic. Similar to IF-THEN logic.
- clause
part of an SQL statement, beginning with a keyword such as SELECT and generally containing an argument.
- column
a field or variable in a table. Each column has a unique name, contains data of a specific type, and has certain attributes.
- column-definition
refers to a column name and column attributes including ...
Get PROC SQL: Beyond the Basics Using SAS® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
