SUPPORT / SAMPLES & SAS NOTES
Problem Note 61089: In SAS® Visual Analytics, the NotMissing operator might return an unexpected value when a parameter is not set
 |  |  |  |  |
In release 7.4, SAS Visual Analytics evaluates expressions that use the NotMissing operator differently than it does in earlier releases. Specifically, in release 7.3 and earlier, parameters that are empty are treated as missing. For example, when evaluating the following expression, SAS Visual Analytics 7.3 and earlier return Model when no value has been set for the parameter.
IF ( 'Origin Parameter'p NotMissing )
RETURN 'Make'n
ELSE 'Model'n
RETURN 'Make'n
ELSE 'Model'n
In release 7.4, the same expression returns Make instead.
There are two workarounds for this issue:
- Instead of NotMissing, use the GetLength operator to check if the parameter has a length greater than 0.
- Modify the expression to use the Missing operator instead of the NotMissing operator. The Missing operator is evaluated as expected.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After the hot fix is applied, the NotMissing operator works the same way it does in previous releases of SAS Visual Analytics.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.4 | 8.2 | 9.4 TS1M4 | Viya |
| Linux for x64 | 7.4 | 8.2 | 9.4 TS1M4 | Viya | ||