Term
|
Definition
|
---|---|
combining data horizontally
|
A technique in which
data is retrieved from an auxiliary source or sources, based on the
values of variables in the primary source.
|
performing a table lookup
|
A technique in which
data is retrieved from an auxiliary source or sources, based on the
values of variables in the primary source.
|
base table
|
The primary source in
a horizontal combination. In this chapter, the base table is always
a SAS data set.
|
lookup table or tables
|
Any input data source,
except the base table, that is used in a horizontal combination.
|
lookup values or return
value
|
The data value or values
that are retrieved from the lookup table or tables during a horizontal
combination.
|
key variable or variables
|
One or more variables
that reside in both the base table and the lookup table. Usually,
key values are unique in the lookup table but are not necessarily
unique in the base table.
|
key value or values
|
A lookup is successful
when the key value in the base table finds a matching key value in
the lookup table.
|