When you publish a campaign in SAS Marketing Automation, the following error message is shown in the SASMarketingAutomationCore and corresponding stored process server log:

MPRINT(MAPUBUTL):  data work.CI_CELL_PACKAGE_base;
MPRINT(MAPUBUTL):   set work.CI_CELL_PACKAGE_base;
MPRINT(MAPUBUTL):   where communication_sk=111111;
MPRINT(MAPUBUTL):   by cell_package_sk package_sk;
MPRINT(MAPUBUTL):   run;

ERROR: BY variables are not properly sorted on data set WORK.CI_CELL_PACKAGE_BASE.
CELL_PACKAGE_SK=11111111 PACKAGE_CD=TEST CAMPAIGN_SK=6666 CAMPAIGN_CD=CAMP6666 
CAMPAIGN_NM=TEST COMMUNICATION_SK=19999999 COMMUNICATION_CD=COMM199999999

This problem occurs because the underlying temporary SAS^® data set should be in a sorted order for subsequent steps. There is no workaround for this issue.

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 5.4_M1 is available at:

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