Problem Note 60431: The sasmaextract utility in SAS® Customer Intelligence does not mask the ampersand (&) character correctly
When you use the SAS Customer Intelligence sasmaextract utility to extract your campaigns, you might encounter an issue with the ampersand character (&) when it is used in a custom detail that is populated by a SAS data set or a database table.
This problem happens when you perform steps similar to the following:
- Create a communication definition with a custom detail that is populated by a dynamic list (for example, SAS data set or a database) that contains values with an ampersand such as the following:
Call & Surf
Speedy Print & Stuff
- Create a campaign using the definition and select the two values.
- Use the sasmaextract utility to extract the campaign.
The ampersand should be masked, as shown below.
<String obj="p5" value="Call &amp; Surf "/>
<String obj="p4" value="Speedy Print &amp; Stuff "/>
However, when you extract the campaign in step 4 above, the ampersand is not masked in the output.xml file, which shows the following:
<String obj="p4" value="Call & Surf "/>
<String obj="p5" value="Speedy Print & Stuff "/>
Then, if you use this output.xml file, the following error is generated:
ERROR: entity name contains invalid sign.
ERROR: noticed during xmlinput analysis at or near row 9765 , column 62.
ERROR: the definition for table "EXTRACTEDFROM" has a false format or is damaged.
To work around this problem, use the LIBNAME statement option XMLPROCESS=PERMIT, which is documented in the section "Importing an XML Document with Non-Escaped Character Data" ("Chapter 3: Importing XML Documents") of the SAS® 9.4 XML LIBNAME Engine: User's Guide.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Marketing Automation Integration Utilities | Microsoft® Windows® for x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
64-bit Enabled AIX | 6.5 | 6.6 | | 9.4 TS1M6 |
64-bit Enabled Solaris | 6.5 | 6.6 | | 9.4 TS1M6 |
HP-UX IPF | 6.5 | 6.6 | | 9.4 TS1M6 |
Linux for x64 | 6.5 | 6.6 | | 9.4 TS1M6 |
Solaris for x64 | 6.5 | 6.6 | | 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: | 2017-12-08 15:40:49 |
Date Created: | 2017-05-08 12:01:51 |