Overview

By default in SAS Information Map Studio, prompts that enable users to type in values are case sensitive, which means that users must always know the exact casing of the value that they want to filter on. This sample explains how to create a case-insensitive, single-selection prompt. Case insensitivity is useful for manual data-entry prompts and for prompts that enable users to specify additional unformatted values.

Before you begin

• This sample uses a map named shoesmap, which is based on a copy of the SASHELP.SHOES table. You can create the information map by submitting the code on the Full Code tab, or you can follow along using your own information map.

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

Create the filter

1. Select Insert ► New Filter.
2. For the Name, enter Subsidiary Filter.
3. For the Data item, select Subsidiary, and then click Edit Data Item.
4. In the Expression Text box, add the UPCASE function to the name of the data item as shown in the following display. Note the parentheses around the name of the data item.



5. Click OK to return to the New Filter dialog box.
6. For the Value, select Prompt user for value and then click New.
7. On the General tab, enter Subsidiary Prompt as both the Name and the Displayed text for the prompt.

Note: The name of your prompt must not match the name of any data item in the information map.

8. Click the Prompt Type and Values tab and complete these steps:
1. For the Prompt type, select Text.
2. For the Method for populating prompt, select one of the three options. This sample uses User enters values.
3. For the Number of values, select Single value.
4. (Optional) Specify a default value.
5. Click OK to return to the New Filter dialog box.
9. Change the Value selection from Prompt user for values to Use an expression and then click Create Expression
10. In the Expression Text box, reference the prompt using the following form:

UPCASE(prompt::<<prompt name>>

The following display shows how the expression looks using the Subsidiary Prompt created previously.



11. Click OK to return to the New Filter dialog box.
12. In the warning message that appears, click OK. The New Filter dialog box should look similar to this display.



13. Click OK to close the dialog box and save the filter.

Test the filter

Select Tools ► Run a Test Query. Select all of the data items, including the filter. You can use any casing for the filter value and still see results. In this example, the value is entered with a mix of letter casing.

Results return as expected.

Using the other prompt types

If you create a prompt that presents a dynamic list that enables users to enter additional unformatted values, then you have the option to search for values. The Search dialog box also enables you to enter case-insensitive values, as shown in the following display.

If the prompt presents a static list, you do not have a search option, but you can enter case-insensitive values into the prompt field.

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:

• Make a copy of the SASHELP.SHOES table, and then register the location of the copy as a library 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), the PROC INFOMAPS statement, and the INSERT DATASOURCE statement must be modified to use the correct values for your environment.

---

%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";

new infomap "shoesmap" auto_replace=yes;

insert datasource
  sasserver="SASApp"
  table="yourlib".shoes
  id="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.

By default in SAS Information Map Studio, prompts that enable users to type in values are case sensitive, which means that users must always know the exact casing of the value that they want to filter on. This sample explains how to create a case-insensitive, single-selection prompt.

Type:

Sample

Date Modified:	2012-06-01 12:00:13
Date Created:	2012-05-31 16:45:54

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® for x64	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 Datacenter Edition	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 Enterprise Edition	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