Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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 3.1 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.

Note: Beginning with SAS Information Map Studio 4.2, you have the option to add "(missing values)" as a prompt choice. Beginning with SAS Web Report Studio 4.3, prompts automatically include (missing values) as a choice if the data contains missing values.

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.

---

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.

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.

   

Operating System and Release Information