SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 34986: The LOAD_ADDRESS_BOOK.SAS macro generates error messages in the log when executed if the SASMAIL.CSV file is missing

DetailsHotfixAboutRate It

If the SASMAIL.CSV file is missing or quotes appear in the _amlmsg_ message, the LOAD_ADDRESS_BOOK.SAS macro generates the following error messages in the log when executed:

%let _amlmsg_="&AMLLAND\sasmail.csv does not exist. DB_KC.FSK_ADDRESS_BOOK
could not be updated."; /*cause error  below*/

%let _amlmsg_=&AMLLAND\sasmail.csv does not exist. DB_KC.FSK_ADDRESS_BOOK
could not be updated.;  /* this works */

MLOGIC(DETECTION.LOAD_ADDRESS_BOOK):  Beginning execution.
MLOGIC(DETECTION.LOAD_ADDRESS_BOOK):  %LET (variable name is _AMLMODULE_)
MLOGIC(DETECTION.LOAD_ADDRESS_BOOK):  %LET (variable name is TRANS_RC)
MLOGIC(DETECTION.LOAD_ADDRESS_BOOK):  %LET (variable name is _AMLMSG_)
MLOGIC(DETECTION.LOAD_ADDRESS_BOOK):  %LET (variable name is MAILSERVER)
SYMBOLGEN:  Macro variable AMLLAND resolves to d:\detection\data\landing
MLOGIC(DETECTION.LOAD_ADDRESS_BOOK):  %IF condition %sysfunc(FILEEXIST
("&AMLLAND\sasmail.csv")) is FALSE
MLOGIC(DETECTION.LOAD_ADDRESS_BOOK):  %LET (variable name is _AMLMSG_)
SYMBOLGEN:  Macro variable AMLLAND resolves to d:\detection\data\landing
NOTE: Line generated by the macro variable "SUBJECT".
1         subject=""d:\detection\data\landing\sasmail.csv does not exist.
DB_KC.FSK_ADDRESS_BOOK could not be updated.""
                     -
                     23
ERROR 23-2: Invalid option name :.

1    !    subject=""d:\detection\data\landing\sasmail.csv does not exist.
DB_KC.FSK_ADDRESS_BOOK could not be updated.""
                        ---------
                        23
ERROR 23-2: Invalid option name detection.

1    !    subject=""d:\detection\data\landing\sasmail.csv does not exist.
DB_KC.FSK_ADDRESS_BOOK could not be updated.""
                                  ----
                                  23
ERROR 23-2: Invalid option name data.

1    !    subject=""d:\detection\data\landing\sasmail.csv does not exist.
DB_KC.FSK_ADDRESS_BOOK could not be updated.""
                                       -------
                                       23
ERROR 23-2: Invalid option name landing.

1    !    subject=""d:\detection\data\landing\sasmail.csv does not exist.
DB_KC.FSK_ADDRESS_BOOK could not be updated.""
                                                           ----
                                                           23
ERROR 23-2: Invalid option name does.

1    !    subject=""d:\detection\data\landing\sasmail.csv does not exist.
DB_KC.FSK_ADDRESS_BOOK could not be updated.""
                                                                ---
                                     ---

23                                      23
ERROR 23-2: Invalid option name not.

1    !    subject=""d:\detection\data\landing\sasmail.csv does not exist.
DB_KC.FSK_ADDRESS_BOOK could not be updated.""

                   -----

                   23
ERROR 23-2: Invalid option name could.

To correct the errors, make certain that the sasmail.csv file exists and that there are no quotes in the amlmsg message.

Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Money Laundering DetectionMicrosoft Windows 2000 Professional1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Server1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Advanced Server1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft® Windows® for x641.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows NT Workstation1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows XP Professional1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Windows Vista1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
* 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.