About Lookup Tables and Functions

SAS Business Rules Manager provides the ability to import lookup tables and reference them from rules. Lookup tables are tables of key-value pairs. For example, you can use a lookup table to retrieve a part name based on the part code number or to retrieve the full name for a country based on its abbreviation.

You can import lookup data from comma-separated-values (CSV) files such as those created by Microsoft Excel into lookup tables in SAS Business Rules Manager. You can re-import updated CSV files as needed to refresh the lookup tables.

In a lookup table, each lookup key is associated with a lookup value. Lookup keys must be unique within each lookup table. Lookup values are limited to 512 characters.

SAS Business Rules Manager provides two functions, Lookup and LookupValue, that enable you to determine whether a lookup key exists in a lookup table and to retrieve a lookup value from a lookup table.