Problem Note 67530: An error occurs when SAS® Visual Analytics report objects are filtered with the DateTimeFromTimeMDY or the TimePart operator and/or the Now() function
 |  |  |  |  |
SAS Visual Analytics report objects might return an error if the data source filter includes the DateTimeFromTimeMDY operator, the TimePart operator, and/or the Now() function. In this scenario, either some report object sections or the entire report object might fail with a red 'x' and the following error:
The error does not occur if you use the DateTimeFromTimeMDY operator, the TimePart operator, and/or the Now() function in a filter directly on the report object.
The following SAS® Visual Statistics report objects are affected:
- Decision Tree
- Generalized Additive Model
- Nonparametric Logistic Regression
The following SAS® Visual Data Mining and Machine Learning report objects are affected:
- Forest
- Gradient Boosting
- Neural Network
As a workaround, first create a calculated date/time data item that includes the operator or function in the expression. For example, the expression for dateTime_Calc would be as follows:
Next, reference the calculated date/time data item in the data source filter. For example, the data source filter would be as follows:
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics (on SAS Viya) | Microsoft® Windows® for x64 | 8.3.1 | Viya | ||
| Linux for x64 | 8.3.1 | Viya | ||||
| Cloud Foundry | 8.3.1 | Viya | ||||