SUPPORT / SAMPLES & SAS NOTES
Problem Note 34452: SAS® Money Laundering Detection code uses ROLE_DESC, which degrades performance
 |  |  |  |  |
Throughout the SAS Money Laudering Detection code there are references to ROLE_DESC="PRIMARY OWNER" in various locations and queries. This might degrade the performance of the software. It would be more efficient to use ROLE_KEY, which is an indexed field.
Note that existing sites will need to add the following INDEX:
proc sql;
CREATE INDEX ROLE_KEY ON MST_BDG.FSC_PARTY_ACCOUNT_BRIDGE
(
role_key
);
quit;
run;
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 Money Laundering Detection | Microsoft® Windows® for x64 | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Advanced Server | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||