• Print |
• E-mail  |
• Bookmark

Overview

When you open an information map from SAS Enterprise Guide or the SAS Add-In 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.

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.

Operating System and Release Information