Overview

When you open an information map from SAS Enterprise Guide 4.1 or the SAS Add-In 2.1 for Microsoft Office, you can apply static filters that are built into the information map, but you do not have access to prompted filters. This sample describes how to use a stored process in order to gain the ability to interactively specify filter values when you open the information map.

Note: Beginning with version 4.3, SAS Enterprise Guide and the SAS Add-In support prompted filters in information maps. In addition, you can create custom filters that persist for the current session (see SAS Note 42032).

Before You Begin

You must be able to perform tasks in SAS^® Management Console. You must know how to register a stored process and a table in metadata. This sample uses the SASHELP.CLASS table, which is shipped with SAS.

Create the Information Map

In SAS Information Map Studio, insert the columns from the SASHELP.CLASS table and save the information map as Class_Map.

Create the Stored Process

Use the following sample code to create a stored process that prompts the user to specify a value for the Sex variable.

*ProcessBody;

%stpbegin;
%global sex;

  /* use the IMLE (Information Map Libname Engine) to connect to map  */
            libname mylib sasioime metauser=sasdemo
            metapass=Password1234
            metaserver=myserver.com
            metaport=8561
            mappath="/BIP Tree/ReportStudio/Maps"
            metarepository=Foundation;
			
  /* print the map and apply the value of the sex prompt that is passed in */

            proc print data = mylib.class_map;
            where upcase(sex) = upcase("&sex");
            run;
			
          libname mylib clear;
          %stpend;

Register the Stored Process

In SAS Management Console, use the New Stored Process Wizard to register the stored process. During the registration, add a parameter (prompt) named sex.

Note: See Managing Stored Process Metadata: Registering the Stored Process Metadata.

Open the Information Map

1. In Microsoft Excel, select SAS ► Reports.
2. Navigate to the stored process that you previously registered.
3. When you are prompted, enter M
   
4. Click Run to see these results.
   

Security Considerations

Because the credentials are hard coded into the stored process, this sample introduces some security concerns. To hide the credentials, you can create a SAS macro using the SECURE option and reference the macro in the stored process. The contents of the macro are not revealed to the user. For more information, see SAS Sample 33559.

Additional Documentation

For more information about registering tables, see Connecting to Common Data Sources: Registering and Verifying Tables.

For more information about using SAS Enterprise Guide, see the SAS Enterprise Guide documentation page.

For more information about using the SAS Add-In for Microsoft Office, see the SAS Add-In for Microsoft Office documentation page.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Operating System and Release Information