In SAS^® Anti-Money Laundering, a set of macros reads the Office of Foreign Assets Control (OFAC) watch list (provided by the US Treasury). Under certain conditions, this process might drop the PLACE_OF_BIRTH column information.

The information is dropped when duplicate records are handled. The FCF_WL_OFAC_TRANSFORM macro routine contains a DATA step that generates STG_WTCH.wl_ofac_transform_0n data sets. The intermediate data set that is named STG_WTCH.wl_ofac_transform_06 contains information about date of birth, year of birth, and place of birth. All that information is extracted from the Remark field in STG_WTCH.wl_ofac_transform_01.

When the macro program executes, after the program creates STG_WTCH.wl_ofac_transform_06, duplicate record information is removed, based on the values of three columns: ENT_NUM, DATE_OF_BIRTH, and YEAR_OF_BIRTH. However, the succeeding NODUPKEY option in the SORT procedure does not include the PLACE_OF_BIRTH column in the BY statement. 

The place of birth information is dropped under these conditions:

• Duplicate records exist for an entity.
• The place of birth is missing in the first duplicate record.

Workaround

1. Open the fcf_wl_ofac_transform.sas program. It is located in these directories:

• Windows: SASHOME\SASFoundation\9.4\antimnycmn\ucmacros
• UNIX/Linux: $SASROOT/ucmacros/antimnycmn

2. Open the program. Look for the PROC SORT for STG_WTCH.wl_ofac_transform_06. Be sure to include the PLACE_OF_BIRTH column in the BY statement:

3. Save the program.
4. Re-run the watch-list ETL code in order to re-import the OFAC watch-list data.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Compliance Solutions 7.1 is available at: