Problem Note 34342: An incorrect count is returned when updating counts on a Select node referencing an interval item
 |  |  |  |  |
When updating counts within a Select node, the incorrect count is returned if the node is fed directly from an upstream Cell node (implicit AND) and the underlying field type is Interval.
For example, if your diagram contains the following nodes:
(Select Age <= 27) -> Cell -> (Select Age <= 28)
and you open the Age <= 28 Dialog Box and select Update Counts, the Count returned will be too high. It should be the same as the count on the upstream Cell.
To work around this problem, use an explicit, rather than implicit, AND:
Select Age <= 27) -> Cell -> AND <- (Select Age <= 28)
The AND node will have the correct count.
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 Campaign Studio | Microsoft® Windows® for x64 | 4.4 | 5.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Advanced Server | 4.4 | 5.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 4.4 | 5.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 4.4 | 5.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 4.4 | 5.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 4.4 | 5.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 5.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 5.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.4 | 5.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 4.4 | 5.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 4.4 | 5.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
A fix for this issue for SAS Marketing Automation 5.1 is available at:
http://www.sas.com/techsup/download/hotfix/ma51.html#034342| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-03-02 12:46:10 |
| Date Created: | 2009-01-02 16:16:05 |