Overview

When creating a dynamically populated prompt, you might want to dynamically filter the values that are displayed to users. For example, your data might contain 10 international regions, but you want the prompt to display regions only in North and South America. This sample explains how to use a hidden prompt to accomplish this task. Essentially, you make your dynamic prompt dependent on the default values specified for the hidden prompt.

Tip: If you do not need all of the values that are generated for your dynamic prompt, then using this technique can improve performance when your list includes many values.

This sample was written using SAS Information Map Studio 4.2_M2. The sample can be used with version 4.2 and later.

About the sample data

To create the Shoe Sales information map used in the sample, you can submit the PROC INFOMAPS code on the Full Code tab in this sample. The steps in the sample refer to this information map.

Prepare the data items

1. Open the Shoe Sales information map in SAS Information Map Studio.
2. Press and hold the CTRL key and select the Product, Region, and Subsidiary data items.
3. Right-click on the selected data items and select Properties.
4. Select the Value-Generation Method tab and then select User selects values from a dynamic list.
5. Click OK.

Create the hidden prompt

1. Select Tools ► Manage Prompts.
2. On the General tab, complete these steps:
1. Click New and enter Restrict List as both the Name and the Displayed text for the prompt.
2. Select the Hide from user option.
3. Click the Prompt Type and Values tab and complete these steps:
1. For the Method for populating prompt, select User selects values from a static list.
2. For the Number of values, select Multiple values.
3. Under List of values, click Get Values.
4. In the Get Values dialog box, select Region as the data item.
5. From the Available values list, select Canada, South America, and United States, as shown in Figure 1.



Figure 1. Select the values that will be used to subset the visible prompt.

6. Click OK to return to the New Prompt dialog box.
4. Enable the Defaults option for Canada, South America, and United States, as shown in Figure 2.



Figure 2. All of your selected values should be specified as defaults.

5. Click OK to return to the Manage Prompts dialog box.

Create the visible prompt

Tip: The visible prompt does not have to use the same data item as the hidden prompt. You could, for example, use a hidden prompt on Region to subset a list of values from a Subsidiaries data item.

1. Click New and enter Region Prompt as the Name and Select a region as the Displayed text.
2. Click the Prompt Type and Values tab and complete these steps:
1. For the Method for populating prompt, select User selects values from a dynamic list.
2. For the Number of values, select Multiple values.
3. Under Unformatted Values, select Region as the data item.
3. Click OK to return to the Manage Prompts dialog box.
4. Click OK.

Figure 3 shows what your Manage Prompts dialog box looks like at this point.

Figure 3. Your hidden prompt (Restrict List) and visible prompt (Region Prompt).

Create the filter

1. Select Insert ► New Filter.
2. Enter Region Filter for the Name.
3. Select Region for the Data item.
4. Select Prompt user for value(s), and then select &Restrict List [Restrict List], which is the hidden prompt.
5. Click the Combinations button, and then click Add. Figure 4 shows what your filter looks like at this point.



Figure 4. The first expression in the combination is your hidden filter.

6. Repeat steps 3 and 4, but, this time, select &Region Prompt [Region Prompt].
7. Click Add.
8. Beneath the Filter combinations box, select Establish dependencies between prompts. Figure 5 shows what your filter looks like at this point.



Figure 5. The complete filter expression.

9. Click OK.

Test the filter

1. Select Tools ► Run a Test Query.
2. Select all data items.
3. Click Run Test.

As shown in Figure 6, only the Region Prompt is displayed, and it contains only those values that you specified as the default values for the Restrict List prompt.

Figure 6. The Restrict List prompt subsets the list of values displayed for the dynamically populated Region Prompt.

Additional Documentation

For more information about SAS Information Map Studio, see the SAS Information Map Studio 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.

Before submitting this code, these tasks must be done:

• The SHOES table and its library (in this sample, SASHELP) must be registered in metadata.

Note: For information about registering SAS libraries and tables, see Establishing Connectivity to a Library of SAS Data Sets.

• The location of the information map (specified by mpath) and the PROC INFOMAPS statement must be modified to use the correct values for your environment.
• After you initially create the information map, remove the comment tag from the DELETE statement for subsequent submissions.

---

%let mpath=/Shared Data/your-map-folder;

proc infomaps metauser="your-userID"
	metapass="your-password"
	metaserver="your-metadata-server.com"
	metaport=8561
	metarepository=Foundation
	mappath="&mpath";

* delete infomap "Shoe Sales";

open infomap "Shoe Sales";
insert datasource sasserver="SASApp"
	table="SASHELP"."Shoes" _all_;
save;

* list _all_;

run;

---

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.

This sample explains how to use a hidden prompt to filter a list of values displayed in a dynamically populated prompt.

Type:

Sample

Date Modified:	2011-12-20 10:46:32
Date Created:	2011-12-19 17:00:00

Operating System and Release Information

Product Family	Product	Host	Product Release		SAS Release
			Starting	Ending	Starting	Ending
SAS System	SAS Information Map Studio	Microsoft Windows Server 2003 Enterprise Edition	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 Datacenter Edition	4.2		9.2 TS2M0
		Microsoft® Windows® for x64	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 Standard Edition	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 for x64	4.2		9.2 TS2M0
		Microsoft Windows Server 2008 for x64	4.2		9.2 TS2M0
		Microsoft Windows XP Professional	4.2		9.2 TS2M0
		Windows Vista	4.2		9.2 TS2M0
		Windows Vista for x64	4.2		9.2 TS2M0