SUPPORT / SAMPLES & SAS NOTES
Usage Note 18680: SAS® Money Laundering Detection Transaction_View posted date and secondary account name logic are both incorrect
 |  |  |  |  |
Within SAS Money Laundering Detection, when in the transaction_view the posted_date_key format is defined as DTMMDDYY10. This causes the wrong date to appear. The correct format should be MMDDYY10.
The transaction_view needs to reset the related_account_name field within the loop. Without resetting it, all subsequent related_account_name values are being set to a prior non -1 value if the secondary_account_key is -1.
Code segment:
/* Secondary_Account_Key */
if secondary_account_key ne -1 then do;
set db_core.fsc_account_dim(%mnydpw keep=ACCOUNT_KEY
ACCOUNT_NUMBER ACCOUNT_NAME
rename=(ACCOUNT_KEY=SECONDARY_ACCOUNT_KEY
ACCOUNT_NUMBER=SECONDARY_ACCOUNT_NUMBER
ACCOUNT_NAME=SECONDARY_ACCOUNT_NAME))
key=SECONDARY_ACCOUNT_KEY / unique;
if (_IORC_) ne 0 then do;
secondary_account_number="";
_error_=0;
_iorc_=0;
end;
end;
else
secondary_account_number="";
output;
needs to change to
/* Secondary_Account_Key */
if secondary_account_key ne -1 then do;
set db_core.fsc_account_dim(%mnydpw keep=ACCOUNT_KEY
ACCOUNT_NUMBER ACCOUNT_NAME
rename=(ACCOUNT_KEY=SECONDARY_ACCOUNT_KEY
ACCOUNT_NUMBER=SECONDARY_ACCOUNT_NUMBER
ACCOUNT_NAME=SECONDARY_ACCOUNT_NAME))
key=SECONDARY_ACCOUNT_KEY / unique;
if (_IORC_) ne 0 then do;
secondary_account_number="";
_error_=0;
_iorc_=0;
end;
end;
else do;
secondary_account_number="";
secondary_account_name = "";
end;
output;
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 XP 64-bit Edition | 1.4 | 9.1 TS1M3 SP3 | ||
| Microsoft Windows NT Workstation | 1.4 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows XP Professional | 1.4 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 1.4 | 9.1 TS1M3 SP3 | ||||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 1.4 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 1.4 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 1.4 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows 2000 Professional | 1.4 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows 2000 Server | 1.4 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows 2000 Advanced Server | 1.4 | 9.1 TS1M3 SP3 | ||||
| Microsoft Windows 2000 Datacenter Server | 1.4 | 9.1 TS1M3 SP3 | ||||