search: Search support.sas.com KNOWLEDGE BASE     System Requirements     Install Center     Product Documentation     Papers     Samples & SAS Notes     Focus Areas SUPPORT     License Assistance     Administrator Services     Downloads & Hot Fixes LEARNING CENTER     Bookstore     Training     Certification     SAS Learning Edition     Higher Education Resources     SAS OnDemand For Academics COMMUNITY     User Groups     Events     E-Newsletters

• Print |
• E-mail  |
• Bookmark

Overview

You want to create a filter selection list for a category data item with a numeric data type. You know that some values might be missing and you want the list to include a missing value as a filter choice. However, by default, SAS Web Report Studio does not include missing values in filter selection lists. This sample explains how to work around this limitation by using a simple user-defined format. This sample is based on the SASHELP.CLASS library, which you will use to create a new table that includes missing values for Weight.

Notes

• This sample includes code that you can submit in Base SAS^® or in SAS^® Enterprise Guide.
• To register the table created in this sample, you must have the ability to perform tasks in SAS^® Management Console.

Create the Sample Data

1. Submit the following code to create a table named Sample where all of the weights for females are missing.

/* substitute your own library name and path */ libname orgold 'c:\orion\orgold'; /* Create the sample table */ data orgold.sample; set sashelp.class; if sex = 'F' then weight = .; run;

2. Submit the following code to create the user-defined format.

/* substitute your own SASFormats path */ libname formats 'C:\SAS\EBI\Lev1\SASMain\SASEnvironment\SASFormats'; proc format library=formats; value missing . = '. '; run;

Note: For more information about where to save user-defined formats in a SAS BI environment, see "Make User-Defined Formats Available" on page 4 of SAS Information Map Studio 3.1: Tips and Techniques at http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/infomap31_tips_9310.pdf

3. Register the table named Sample in SAS Management Console.

Modify the Properties for the Weight Data Item

1. Open SAS Information Map Studio, insert the Sample table, and open the properties for the Weight data item.
2. On the Classifications/Formats tab, change the type to be Category and then select the user-defined format that you created in step 3. Your Classifications/Formats tab should look like the following:

   

3. On the Permissions/Value Generation tab, select Dynamically generate a list that contains all of the data item's values.

   

4. Save the information map.

Create the Filter

1. Open SAS Web Report Studio to create a new report, selecting the information map that you just created.
2. Create a filter for the Weight data item as shown below.

   

View the Results

To see how the filter works, click the Results tab at the top of this sample.

Additional Documentation

For a list of available documentation for SAS Web Report Studio, see http://support.sas.com/documentation/onlinedoc/wrs/index.html.

For a list of available documentation for SAS Information Map Studio, see http://support.sas.com/documentation/onlinedoc/ims/index.html.

For a list of available documentation for SAS Management Console, see http://support.sas.com/documentation/onlinedoc/sasmc/index.html.

---

Using the Filter in SAS Web Report Studio

1. Click View Report to display the prompt window.



2. The filter selection list includes a dot that represents missing values. Select the dot to display results like those shown below.

   

By default, SAS Web Report Studio does not include missing values in filter selection lists. This sample explains how to work around this limitation by using a simple user-defined format.

Type:	Sample
Topic:	Query and Reporting ==> Creating Reports Query and Reporting ==> Interactive Querying Data Management ==> Data Sources ==> Information map

Date Modified:	2008-09-26 15:01:41
Date Created:	2008-09-26 09:03:56

Operating System and Release Information

Product Family	Product	Host	Product Release		SAS Release
			Starting	Ending	Starting	Ending
SAS System	SAS Web Report Studio	Microsoft® Windows® for x64	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Advanced Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Datacenter Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Professional	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Datacenter Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Enterprise Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Standard Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows XP Professional	3.1		9.1 TS1M3 SP4
		Windows Vista	3.1		9.1 TS1M3 SP4
		64-bit Enabled AIX	3.1		9.1 TS1M3 SP4
		64-bit Enabled Solaris	3.1		9.1 TS1M3 SP4
		HP-UX IPF	3.1		9.1 TS1M3 SP4