The check box in the SAS® Campaign Studio multi-select node has an option to "Exclude Customers that meet these criteria". Under certain circumstances, checking that box might cause incorrect counts to be returned.

The Help in SAS^® Campaign Studio describes this feature's functionality as follows:

However, this does not occur if the criteria is against any table that is ManyToOne with the subject. The SQL that is generated when the Exclude option is checked is not of the entire Multi-Select WHERE clause.

In a manyToOne selection, that does not exclude Subjects that meet the criteria. Instead it selects subject that meet the opposite of the criteria.

As a simple example of the problem. Consider customer 123 that has two Orders. Order 1 is for Product A and Order 2 is for Product B.

If you have a multi-select that specifies Order.Product = A, then customer 123 is selected. If you then check the option to exclude, one would expect that customer 123 would not be selected.

However, the sql generates:

This sql also selects customer 123 because Order 2 meets the criteria.

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

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