In SAS Customer Intelligence Studio, incorrect counts are generated when you use the same range for different date-type fields (for example, day<=10 combined with month<=10) in a Select node.
When you view the audit log of the campaign, the counts that are returned for the September 10-October 7 range only return September records. For this example, the generated SQL code is similar to the following:
) <= 1.0 AND ( ( ( ( month( ( table0.Last_Expected_MC_Renewal_Date ) ) ) >= 9.0 AND ( month( ( table0.Last_Expected_Renewal_Date ) ) ) <= 9.0) AND ( day( ( table0.Last_Expected_Renewal_Date ) ) ) <= 30.0) OR ( ( ( month( ( table0.Last_Expected_Renewal_Date ) ) ) <= 10.0 AND ( day( ( table0.Last_Expected_Renewal_Date ) ) ) >= 1.0) AND ( day( ( table0.Last_Expected_Renewal_Date ) ) ) <= 7.0) ) AND ( day( ( table0.Last_Expected_Renewal_Date ) ) ) >= 10.0 ) table3 ;
In this code, the comparison operator (<=) does not take into account the different date-type fields.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Marketing Automation | Microsoft® Windows® for x64 | 6.4 | 6.5 | 9.4 TS1M3 | |
Microsoft Windows 8 Enterprise 32-bit | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows 8 Enterprise x64 | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows 8 Pro 32-bit | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows 8 Pro x64 | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows 8.1 Enterprise 32-bit | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows 8.1 Enterprise x64 | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows 8.1 Pro | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows 8.1 Pro 32-bit | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows Server 2008 | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows Server 2008 R2 | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows Server 2008 for x64 | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows Server 2012 Datacenter | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows Server 2012 R2 Datacenter | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows Server 2012 R2 Std | 6.4 | 6.5 | 9.4 TS1M3 | |||
Microsoft Windows Server 2012 Std | 6.4 | 6.5 | 9.4 TS1M3 | |||
Windows 7 Enterprise 32 bit | 6.4 | 6.5 | 9.4 TS1M3 | |||
Windows 7 Enterprise x64 | 6.4 | 6.5 | 9.4 TS1M3 | |||
Windows 7 Home Premium 32 bit | 6.4 | 6.5 | 9.4 TS1M3 | |||
Windows 7 Home Premium x64 | 6.4 | 6.5 | 9.4 TS1M3 | |||
Windows 7 Professional 32 bit | 6.4 | 6.5 | 9.4 TS1M3 | |||
Windows 7 Professional x64 | 6.4 | 6.5 | 9.4 TS1M3 | |||
Windows 7 Ultimate 32 bit | 6.4 | 6.5 | 9.4 TS1M3 | |||
Windows 7 Ultimate x64 | 6.4 | 6.5 | 9.4 TS1M3 | |||
64-bit Enabled AIX | 6.4 | 6.5 | 9.4 TS1M3 | |||
64-bit Enabled Solaris | 6.4 | 6.5 | 9.4 TS1M3 | |||
HP-UX IPF | 6.4 | 6.5 | 9.4 TS1M3 | |||
Linux for x64 | 6.4 | 6.5 | 9.4 TS1M3 | |||
Solaris for x64 | 6.4 | 6.5 | 9.4 TS1M3 |