Column data is not sorted correctly in the export preview in SAS Marketing Automation. This problem occurs when the table exceeds 100 rows.  

The sorting process works for every subset of 100 rows in your table. Then, the sorting starts over, as shown in this example:

                     A

                B

. . .more sorted entries. . .

                V

                W

                 A

                 B

. . .more sorted entries. . .

                 V

                 W

An actual example is shown in the image below. When you sort the CITY column alphabetically, the sort order is correct for the first 100 rows. But the process starts over with the next 100 rows.

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.6 is available at: