SQL DICTIONARY Tables for the Information Maps Engine

DICTIONARY.FILTERS Table

The SQL DICTIONARY.FILTERS table contains a row for each filter in all of the information maps that are available through the Information Maps engine. The table contains the following variables:

LIBNAME: Information Maps engine libref for the information map that contains the filter
MEMNAME: SAS name for the information map that contains the filter
NAME: SAS name for the filter
FILTERNAME: Filter name
ID: Filter ID
PATH: Location of the filter within the metadata server
DESCRIPTION: Description of the filter

The following example shows how you can query the DICTIONARY.FILTERS table to retrieve information about the available filters:

libname mymaps infomaps mappath="/Users/myUserID/My Folder";

proc sql;
   select f.memname, f.filtername, f.id, f.description
      from DICTIONARY.FILTERS as f;

Output from DICTIONARY.FILTERS Table Query

Member Name                       Filter Name         Filter ID           Filter Description
--------------------------------------------------------------------------------------------
Employee Statistics Sample        Cary Employees      Cary Employees      Employees who work
                                                                          in Cary, North
                                                                          Carolina.
Employee Statistics Sample        Which department?   Which department?   Filters based on
                                                                          selected
                                                                          departments.

Top of Page