Problem Note 63355: An incorrect date (-1 day) is passed when you use a custom-written stored process in SAS® Customer Intelligence Studio
In SAS Customer Intelligence Studio, an incorrect date (-1 day) is passed to the SAS® code for a Process node. This problem happens when you perform steps similar to the following:
- Create a custom-written stored process that contains a macro variable for the date value.
- In SAS® Management Console, create a prompt that you can use to enter the date value.
- In SAS Customer Intelligence Studio, add the stored process to a Process node and enter a date value (for example, August 31, 2018).
- Click OK in the Process node.
- Re-open the Process node. When you do this, the date value that is shown is one day earlier (minus one): August 30, 2018.
If you update the Process node, the stored process or the pooled workspace-server log shows an earlier (-1) date value, regardless of what time zone is set:
98 +%PUT INFO >> Execution Date is &mExe_dt;
INFO >> Execution Date is 30Oct2018
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Customer Intelligence Studio | Microsoft® Windows® for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows 8 Enterprise 32-bit | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows 8 Enterprise x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows 8 Pro 32-bit | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows 8 Pro x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows 8.1 Enterprise 32-bit | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows 8.1 Enterprise x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows 8.1 Pro 32-bit | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows 8.1 Pro x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows 10 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows Server 2008 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows Server 2008 R2 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows Server 2008 for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows Server 2012 Datacenter | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows Server 2012 R2 Datacenter | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows Server 2012 R2 Std | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Microsoft Windows Server 2012 Std | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Windows 7 Enterprise 32 bit | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Windows 7 Enterprise x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Windows 7 Home Premium 32 bit | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Windows 7 Home Premium x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Windows 7 Professional 32 bit | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Windows 7 Professional x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Windows 7 Ultimate 32 bit | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Windows 7 Ultimate x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
64-bit Enabled AIX | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
64-bit Enabled Solaris | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
HP-UX IPF | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Linux for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Solaris for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-02-08 10:52:54 |
Date Created: | 2018-12-10 14:55:30 |