Typically, when you create an external file, the file is created in UTF-8 format with a BOM signature. However, in SAS Customer Intelligence, the BOM signature is missing when you export data to an external file in the UTF-8 encoding.

This problem occurs because the following FILE statement that is used in SAS Customer Intelligence does not have the ENCODING='UTF-8' option:

As a workaround, add the highlighted lines below to the MAEXPFIL.SAS macro. Typically, this macro is located in the SASHOME-directory\SASFoundation\9.3\ma\sasmacro directory.

   /*S0897280 - Removed checks for outputtype= 0 & 1. */
%if &outputType=7 %then
   %let export_filestmt=&export_filestmt dlm=&dlmchar; /* Delimited or (old) CSV or TAB delimited*/

   %let export_filestmt=&export_filestmt recfm=v lrecl=32767;

%if %nrbquote(&SysEncoding) = %str(utf-8) %then             
    %let export_filestmt=&export_filestmt ENCODING='UTF-8';

filename logfile temp lrecl=32767;

data _null_;
   set &vards end=done;

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 6.1_M1 is available at: