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:
CREATE TABLE MATables.TBBFLBKIJLXYFWAABSASDemoUser AS
SELECT DISTINCT table1.CLIENTNUM AS CLIENTNUM LABEL='new Subject IDDIR0'
FORMAT=F12.0
FROM SCHEMA.CLIENTS table1
Left join SCHEMA.ACCOUNTS table2
on table1.CLIENTNUM = table2.CLIENTNUM
Inner join MATables.TBOD1KTDIBHWA4AAJSASDemoUser table0
on table0.ACCOUNTNUM = table2.ACCOUNTNUM ;
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| 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 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Topic: | System Administration ==> Servers
|
| Date Modified: | 2009-03-02 16:43:19 |
| Date Created: | 2006-11-02 11:31:30 |
