Problem Note 34565: The party_watchlist_header code in SAS® Anti-Money Laundering and SAS® Money Laundering Detection might generate a character length-exceeded error
 |  |  |  |  |
A macro variable &hash_length is being created dynamically. The value of this variable is determined by the structure of input data, in this case, World-Check data files.
The value of &hash_length is calculated by multiplying the maximum number of BY group values observed and then multiplying this value by 21 for organizations or 16 for individuals.
The customer table supplied 'fsc_entitity_watch_list_dim' contains a value of 2502, which represents the maximum number of BY values where BY value is based on 'last_name'.
The last name 'DA SILVA' appears 2502 times within this input data. Multiplying this value by 16 results in a value of 40032.
This value is then used to initialize the value of the macro variable &hash_length.
The macro variable &hash_length is then used in a further DATA step to dynamically set the length of the SAS® character variable field in_match_list. The length 40032 violates the maximum-allowable length for a SAS character variable, which must be in the range of 1-32767. If the calculated length exceeds 32767, then the marco will re-set the value to 32767 and provide a warning message in the SAS log.
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 Anti-Money Laundering | Microsoft® Windows® for x64 | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Advanced Server | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled HP-UX | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled Solaris | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Linux | 2.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 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 | ||