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

Filter identifier

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.