In SAS Customer Intelligence Studio, incorrect counts appear in a Select node when you select Any value meets this criteria from the Rule drop-down list. This problem happens when you use a Select node as a first node in a diagram that compares two data items (for example, text data items) that use the rule Any value meets this criteria, as shown below:

It is expected that each subject ID should be reflected only once in the count of a Select node, but that is not the case. The target campaign should create an audience of all contacts with an email address that matches the one in the Short Message Service (SMS) email.

This problem occurs because there are two inner joins between the underlying CONTACTS and SMS tables. The first inner join between CONTACTS and ACCOUNTS has a cardinality value of many-to-one. The second inner join between ACCOUNTS and SMS has a cardinality value of one-to-many.

The CICore log shows that the SELECT node does not contain the DISTINCT argument in line 7:

Without the DISTINCT argument in the SELECT statement, the software returns incorrect counts.

To work around this problem, place a Cell node before the Select node, as shown in this example:

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

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