About Lookup Tables and Functions

SAS Decision 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 Decision Manager. You can re-import updated CSV files as needed to refresh the lookup tables.
CSV File Imported Into SAS Decision Manager
Image Showing CSV File Imported Into SAS Business Rules Manager
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 Decision 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.
Copyright © SAS Institute Inc. All rights reserved.