Going Beyond Simple Information Maps to Improve Access to Data Sources

Overview

SAS Information Maps provide users with easy access to rather simply-defined data sources. Although they can be directed to external relational databases, performance can be an issue due to the way in which queries are built and passed via the LIBNAME engine within the SAS/Access products. In addition, sometimes it is necessary to perform nested queries to databases in order to provide more meaningful information in reports. This paper will explore options to assure performance and go beyond simple table joins to provide easier access to end users.