The SAS® Web Report Studio Filter and Rank dialog box fails with the "No values to filter on have been selected" message


This SAS KB article contains the following sections:

Table of Contents

The Filter and Rank Dialog Box in SAS Web Report Studio Fails

The Filter and Rank dialog box in SAS Web Report Studio fails with the No values to filter on have been selected message in the following scenarios: 

The No values to filter on have been selected message is displayed when you complete steps similar to the following:

  1. Open your report in SAS Web Report Studio.
    SAS Web Report Studio - TEST_LV-POLICIERT
  2. Right-click any value within the report and select Filter and Rank… to apply a filter.
    "Filer and Rank" option
  3. Select a Category and select the Filter Type.
  4. Select one or more values from the Available value list that is displayed in the left pane and add them to the Selected values list in the right pane.
    Filter and Rank panes: select values from the left pane and add them to the Selected values list in the right pane. 
  5. Click OK in the “Filter and Rank” dialog box to confirm the selected values to filter. 

Immediately, the following pop-up message is displayed:

"No values to filter on have been selected."

As a result, you cannot save the selected values.

To continue working on your report, click the OK button in the pop-up box. Then, in the Filter and Rank dialog box, click Cancel to exit.

The Isolate Option

Note that the Isolation option is not affected by this issue. As a result, you can filter a table on those values by completing the following steps:

  1. Select a row or column and right-click it.
  2. Click Isolate.
  3. The table is displayed and filtered by the value.
    Click “Isolate ****"

Workaround

Special Characters (“<”, “>”, and “=”)  

If the special characters come from a format applied to your data, to circumvent this issue, remove the special character from the format. Change the format where the characters “<” and “>=” occur and substitute them with “less then”, “greater than", or "equal to”. 

Here is an example:

Original Format

proc format library = DATASTAR;                                                             
   value  $lrrv1f      '1'    = "1  bis < 10 "  
                       '2'    = "10 bis < 20"    
                       '3'    = "20 bis < 30"  
                       '4'    = "30 bis < 40"  
                       '5'    = "40 bis < 50"  
                       '6'    = "50 bis < 60"
                       '7'    = ">= 60"       
                       '9'    = "nicht definiert"   
   ;                                                
...

New Format

proc format library = DATASTAR;
   value  $lrrv1f      '1'    = "1  bis less then 10 "    
                       '2'    = "10 bis less then 20"  
                       '3'    = "20 bis less then 30"  
                       '4'    = "30 bis less then 40"  
                       '5'    = "40 bis less then 50" 
                       '6'    = "50 bis less then 60"  
                       '7'    = "greater than or equal to 60"   
                       '9'    = "nicht definiert"

 ;                                                
...

A hot fix is available for this issue.

Note: After installing the hot fix for this issue, the Umlauts letters related issue occurs.

Umlauts Letters (Ä, Ö, Ü, ä, ö, ü) 

A hot fix is planned for this issue. SAS Technical Support will update this section when the hot fix is available.