Problem Note 18904: Counts might be incorrect if a diagram contains a map node with an underlying left join that is defined between the tables in the information map
 |  |  |  |  |
A Map node in a SAS® Campaign Studio diagram can return incorrect counts when there is an underlying left join in the information map.
For example, if you have a customer table (with a subject ID of customer) and an account table with a one-to-many relationship, the account table has two subject IDs: customer and account.
In order to allow a multi-select node to return customers who do not have accounts, when selecting customers and accounts, you need to make the relationship between the two tables a left join in the information map.
However, if at some stage you map from account to customer, the left join causes customers without accounts to be returned in addition to those with accounts, making the counts incorrect as the following SQL sample illustrates:
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Marketing Automation-Server | Microsoft Windows XP Professional | 4.4 | 5.3 | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 5.3 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 4.4 | 5.3 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 5.3 | 9.2 TS2M0 | |||
| Microsoft Windows 2000 Server | 4.4 | |||||
| Microsoft Windows 2000 Professional | 4.4 | |||||
| Microsoft Windows 2000 Datacenter Server | 4.4 | |||||
| Microsoft Windows 2000 Advanced Server | 4.4 | |||||
| 64-bit Enabled Solaris | 4.4 | 5.3 | 9.2 TS2M0 | |||
| Solaris | 4.4 | 5.3 | 9.2 TS2M0 | |||
| AIX | 4.4 | 5.3 | 9.2 TS2M0 | |||
| 64-bit Enabled AIX | 4.4 | 5.3 | 9.2 TS2M0 | |||
| HP-UX IPF | 4.4 | 5.3 | 9.2 TS2M0 | |||