SAS^® Marketing Automation enables you to use the mausrexp.sas program to define an output library for table exports. However, mausrexp.sas fails when the output library is an OLEDB library that includes the PROPERTIES= option, as in this definition:

LIBNAME SDM OLEDB BULKLOAD=YES PROPERTIES=( 'initial catalog'=sdm 'Persist Security Info'=False) 
DATASOURCE="test-sql\INST003" PROVIDER=sqloledb PROMPT=NO USER=sdm PASSWORD="XXXXX"

When this problem occurs, the SAS^® Stored Process Server writes an error to its log file that is similar to the following error:

2011-10-18T12:20:10,539 INFO  [00000229] 4:C002318@NT0001 - SDM=LIBNAME SDM OLEDB BULKLOAD=YES 
PROPERTIES=('initial catalog'=sdm 'Persist Security Info'=False) DATASOURCE="test-sql\INST003"
PROVIDER=sqloledb PROMPT=NO USER=sdm 
2011-10-18T12:20:10,539 INFO  [00000229] 4:C002318@NT0001 - PASSWORD="{sas002}EB62BD0325AA9D785A8AB7B72A595F14"
schema=sdm 
2011-10-18T12:20:10,539 INFO  [00000229] 4:C002318@NT0001 - ERROR: Required operator not found in expression: 
&&&Library ne 
2011-10-18T12:20:10,539 INFO  [00000229] 4:C002318@NT0001 - ERROR: The macro MAUSREXP will stop executing.

To work around the problem, modify the mausrexp.sas program, as follows:

1. Locate the following lines in the program:
   /* Now figure out if we have the configuration for this library */ %if &&&Library ne
2. Replace the %IF line with the following line:
   /* Now figure out if we have the configuration for this library */ %if %length(&&&Library) > 0

Operating System and Release Information