SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 60431: The sasmaextract utility in SAS® Customer Intelligence does not mask the ampersand (&) character correctly

DetailsHotfixAboutRate It

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:

  1. 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
  2. Create a campaign using the definition and select the two values.
  3. Use the sasmaextract utility to extract the campaign.

The ampersand should be masked, as shown below.

<String obj="p5" value="Call &amp;amp; Surf "/>
<String obj="p4" value="Speedy Print &amp;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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Marketing Automation Integration UtilitiesMicrosoft® Windows® for x646.56.69.4 TS1M6
64-bit Enabled AIX6.56.69.4 TS1M6
64-bit Enabled Solaris6.56.69.4 TS1M6
HP-UX IPF6.56.69.4 TS1M6
Linux for x646.56.69.4 TS1M6
Solaris for x646.56.69.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.