SUPPORT / SAMPLES & SAS NOTES
Problem Note 20048: SAS® Marketing Automation returns an error when you use the select node to query an aggregated date
 |  |  |  |  |
When you query an aggregate date, SAS® Marketing Automation cannot successfully execute the following syntax in the SQL HAVING clause it generates:
HAVING MAX( dateColumn ) > today() - 1000
Without the aggregate function MAX, SAS/ACCESS® engines correctly interpret "today() - 1000" as a date. When you add the MAX function, however, SAS/ACCESS engines interpret "today() - 1000" as a number and sends it to the database as a numeric value instead of a date value.
This problem occurs in Teradata, Oracle, DB2 and any non-SAS engine that is leveraged by SAS Marketing Automation.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Marketing Automation-Server | Microsoft Windows XP Professional | 4.4 | 5.3 | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 5.3 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 4.4 | 5.3 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 5.3 | 9.2 TS2M0 | |||
| Microsoft Windows 2000 Server | 4.4 | 5.3 | 9.2 TS2M0 | |||
| Microsoft Windows 2000 Professional | 4.4 | 5.3 | 9.2 TS2M0 | |||
| Microsoft Windows 2000 Datacenter Server | 4.4 | 5.3 | 9.2 TS2M0 | |||
| Microsoft Windows 2000 Advanced Server | 4.4 | 5.3 | 9.2 TS2M0 | |||
| 64-bit Enabled Solaris | 4.4 | 5.3 | 9.2 TS2M0 | |||
| Solaris | 4.4 | 5.3 | 9.2 TS2M0 | |||
| AIX | 4.4 | 5.3 | 9.2 TS2M0 | |||
| 64-bit Enabled AIX | 4.4 | 5.3 | 9.2 TS2M0 | |||
| HP-UX IPF | 4.4 | 5.3 | 9.2 TS2M0 | |||