SUPPORT / SAMPLES & SAS NOTES
Problem Note 56903: Exporting Numeric custom detail tags fails and returns a syntax error in SAS® Marketing Automation
 |  |  |  |  |
When you run an export in SAS Marketing Automation after you apply hot fix E88017, you encounter the following error in the SASMarketingAutomationCore5.4.log file when you use pipe (|) as a delimiter:
2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - 129 + NumExtractHNGWJYIKYUYOIAAA = scan(NumStringInHNGWJYIKYUYOIAAA ,LoopCountHNGWJYIKYUYOIAAA , &treatmentDelimchar. ,&scanModifier. ); 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - NOTE: Line generated by the macro variable "TREATMENTDELIMCHAR". 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - 129 '|' 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - _ 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - The SAS System 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - 386 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - _ 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - 200 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - 76 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - MPRINT(MAEXP): NumExtractHNGWJYIKYUYOIAAA = scan(NumStringInHNGWJYIKYUYOIAAA ,LoopCountHNGWJYIKYUYOIAAA , '|' ,'' ); 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - ERROR 386-185: Expecting an arithmetic expression. 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - ERROR 200-322: The symbol is not recognized and will be ignored. 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - 2015-10-20T09:14:03,471 INFO [00007426] 172:sasdemo@XXX - ERROR 76-322: Syntax error, statement will be ignored.
This problem only happens when the following two conditions are true:
- You set pipe (|) as the value for the option Separator for exported list values as shown below:
- You export Numeric custom detail tags as shown below:
There is one workaround. If you are not using Tab as a delimiter, then you can revert to the previous version of the maexp.sas macro before the hot fix E88017.
Click 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® for x64 | 5.41 | 6.1 | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Microsoft Windows Server 2003 for x64 | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Microsoft Windows Server 2008 | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Microsoft Windows Server 2008 R2 | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Microsoft Windows XP Professional | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Windows 7 Enterprise 32 bit | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Windows 7 Enterprise x64 | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Windows 7 Home Premium 32 bit | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Windows 7 Home Premium x64 | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Windows 7 Professional 32 bit | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Windows 7 Professional x64 | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Windows 7 Ultimate 32 bit | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Windows 7 Ultimate x64 | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Windows Vista | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Windows Vista for x64 | 5.41 | 6.1 | 9.3 TS1M0 | |||
| 64-bit Enabled AIX | 5.41 | 6.1 | 9.3 TS1M0 | |||
| 64-bit Enabled HP-UX | 5.41 | 6.1 | 9.3 TS1M0 | |||
| 64-bit Enabled Solaris | 5.41 | 6.1 | 9.3 TS1M0 | |||
| HP-UX IPF | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Linux for x64 | 5.41 | 6.1 | 9.3 TS1M0 | |||
| Solaris for x64 | 5.41 | 6.1 | 9.3 TS1M0 | |||