Incorrect counts might be returned when you execute a SAS^® Customer Intelligence campaign. This problem occurs if the diagram contains a Map node that is refining its output on data in tables that are connected with an outer join.

For example, you have an information map that has at least two subjects, such as Customer and Accounts.

1. Each customer may have 1 or many contracts.
2. Each contract may have 0-many events. The join to the event table must be an outer join to enable selection of customers or contracts with no events.
3. Create an information map with the following relationship between the underlying tables:
1. join between Contract and Product_Purchase(Event) a left outer join
2. join between Product_Purchase and Product a left outer join

1. Select all customers with no products.
2. Connect the Select/Multi-select node to a Map node. Map to Accounts and select Refine.
3. Specify the refine limit as 1 contract. Specify the refine selection as Product is missing.
4. Run the Map node. Note that 0 contacts are selected.

When you review the audit log for the Selection node, you see outer joins between Contract and Product_Purchase(Event) and between Product_Purchase(Event) and Product.

The audit log for the Map node reports those same joins as inner joins, which is incorrect and explains the zero count.

There is no workaround.

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

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