a keyword that causes the SQL procedure to remove duplicate rows from the output.
a type of join in the SQL procedure. For example, when two tables are joined in an
equijoin, the value of a column in the first table must equal the value of the column
in the second table in the SQL expression. See also join.
See SAS format.
a set of rows or observations that have the same value or values for one or more
common columns or variables.
a query expression that is nested in the SQL procedure's FROM clause. An in-line
view produces a table internally that the outer query uses to select data. You save a
programming step when you use an in-line view, because instead of creating a view
and then referring to it in another query, you can specify the view in-line in the
FROM clause. An in-line view can be referenced only in the query (or statement) in
which it is defined.
See SAS index.
a join between two tables that returns all of the rows in one table that have one or
more matching rows in the other table.
a data validation rule that restricts the data values that can be stored for a variable in
a SAS data file. Integrity constraints help preserve the validity and consistency of the
an operation that combines data from two or more tables. A join is typically created
by means of SQL (Structured Query Language) code or a user interface. See also
the set of parameters that determine how tables are to be joined. Join criteria are
usually specified in a WHERE expression or in an SQL ON clause. See also join,
a type of value for a variable that contains no data for a particular row or column. By
default, SAS writes a missing numeric value as a single period and a missing
character value as a blank space.
a type of join that returns selected rows from tables in which one or more columns in
each table have the same name and the same data type and contain the same value.
See also join.