Problem Note 59206: SAS® Visual Scenario Designer and SAS® Event Stream Processing produce different values for WEEKDAY function when the day field is a single digit
 |  |  |  |  |
In SAS Visual Scenario Designer, you can create a scenario that uses the WEEKDAY function. You can also create a deployment that contains a scenario, and run the deployment in a SAS Event Stream Processing server. However, in SAS Event Stream Processing, the WEEKDAY function produces incorrect results. The problem occurs when you use only one digit to indicate the day field in a date in SAS Visual Scenario Designer.
Example:
The WEEKDAY function for the 5AUG2011 date generates the value of 6 in SAS Visual Scenario Designer. However, SAS Event Stream Processing server generates an incorrect value of 2.
There are no errors or warnings to indicate a problem.
To avoid the problem, use 2 digits for day field in a date in SAS Visual Scenario Designer.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you apply the hot fix, you are not allowed to enter a single digit for a day value in a date in SAS Visual Scenario Designer.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Scenario Designer | Linux for x64 | 6.3_M1 | 9.4 TS1M3 | ||
| SAS System | SAS Event Stream Processing Engine | Microsoft® Windows® for x64 | 3.2 | |||
| Linux for x64 | 3.2 | |||||
A fix for this issue for SAS Visual Scenario Designer 6.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z53.html#59206| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2020-03-11 16:07:01 |
| Date Created: | 2016-10-21 15:23:49 |