Problem Note 64335: The fcf_wl_wchk_transform.sas macro incorrectly processes date_of_birth information that is provided by World-Check
A syntax issue exists within the fcf_wl_wchk_transform.sas macro, which is used to process World-Check database information in both SAS® Anti-Money Laundering 6.3 and SAS® Anti-Money Laundering 6.3 Maintenance 1. The macro code contains incorrect syntax in the assignment statements that help convert the date_of_birth information for watch-list entities.
The macro is found in this location:
- UNIX: SASHOME/SASFoundation/9.4/ucmacros/antimnycmn
- Windows: SASHOME\SASFoundation\9.4\antimnycmn\ucmacros
The suggested code correction is listed below. (See the lines in bold.)
Original Code
/* Only year_of_birth available */
if index(dob,'00') then do;
date_of_birth=.;
year_of_birth=input(kscan(dob,1,'/'),best32.);
end;
/* date_of_birth and year_of_birth available */
else if not index(dob,'00') then do;
date_of_birth=input(dob,??yymmdd10.);
if not missing(date_of_birth) then do;
date_of_birth=dhms(date_of_birth,00,00,00);
year_of_birth=year_of_birth=year(datepart(date_of_birth));
end;
Suggested Code Revision
/* Only year_of_birth available */
if index(dob,'/00') then do;
date_of_birth=.;
year_of_birth=input(kscan(dob,1,'/'),best32.);
end;
/* date_of_birth and year_of_birth available */
else if not index(dob,'/00') then do;
date_of_birth=input(dob,??yymmdd10.);
if not missing(date_of_birth) then do;
date_of_birth=dhms(date_of_birth,00,00,00);
year_of_birth=year(datepart(date_of_birth));
end;
end;
Operating System and Release Information
SAS System | SAS Anti-Money Laundering | Microsoft® Windows® for x64 | 6.3 | 7.1 | 9.4 TS1M2 | 9.4 TS1M3 |
64-bit Enabled AIX | 6.3 | 7.1 | 9.4 TS1M2 | 9.4 TS1M3 |
64-bit Enabled Solaris | 6.3 | 7.1 | 9.4 TS1M2 | 9.4 TS1M3 |
Linux for x64 | 6.3 | 7.1 | 9.4 TS1M2 | 9.4 TS1M3 |
*
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 |
Date Modified: | 2019-06-18 15:40:10 |
Date Created: | 2019-06-13 16:46:55 |