SUPPORT / SAMPLES & SAS NOTES
Problem Note 30809: The FIND_ALERT_NEAR_NEIGHBOR macro fails when BLTEMP=NO and an attempt is made to delete observations from the table, FSK_NN_PARTY
 |  |  |  |  |
The FIND_ALERT_NEAR_NEIGHBOR macro fails when BLTEMP=NO and a process attempts to delete observations from the table, FSK_NN_PARTY.
The following error message is returned:
ERROR: File DB_CORE.FSK_NN_PARTY.DATA does not exist.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.05 seconds
cpu time 0.00 seconds
This error occurs because the libref is incorrect in the FIND_ALERT_NEAR_NEIGHBOR macro and needs to be changed to point to the DB_KC (Knowledge Center) libref.
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 Alert Generation Server | Microsoft Windows Server 2003 Datacenter Edition | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows NT Workstation | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Advanced Server | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft® Windows® for x64 | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled HP-UX | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled Solaris | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Linux | 2.1.1 | 2.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||