Split nodes in SAS^® Customer Intelligence Studio return incorrect counts when you sort on a field in a folder that has a many-to-one relationship with the subject and that folder contains more than one row for each individual subject. For example, if you have a Customer folder that includes three customers and each customer has five accounts, when you count the customers you would expect a value of 3 to be returned. However, if in your Split node you sort on a field in the Account table, then the number of accounts is incorrectly returned (3 customers x 5 accounts per customer = 15) instead of the number of customers.

There are two possible workarounds for this problem: do not sort the data, or sort on fields in the subject folder. In the scenario described here, sorting on a field in the Customer folder returns the correct count.

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