SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 37683: Defining a library for use with SAS® Marketing Automation Exports

DetailsAboutRate It

Beginning in SAS Marketing Automation 5.3, it is recommended that you use the mausrexp.sas macro to define your export libraries.

Note: This recommendation is also valid for all SAS® Customer Intelligence 6.x releases.

You do not need to restart the object spawner in order to make these libraries available after you make changes to the macro. In addition, the changes are not overwritten when you apply hot fixes.

The mausrexp.sas macro resides in the following directories:

<SASHOME>\SASFoundation\9.x\ma\sasmacro (Microsoft Windows operating environments) <SASHOME>/SASFoundation/9.x/sasautos (UNIX operating environments)

Use the following section within mausrexp.sas to list your export libraries:

/* BEGIN INTENDED USER MODIFICATION SECTION */ /* Create macros that are defined export libraries here. */ /* Example: %let expsas=%str(libname expsas 'some-path'); */ /* END OF INTENDED USER-MODIFICATION SECTION */

Here is an example entry for an Oracle export library:

/* BEGIN INTENDED USER MODIFICATION SECTION */ /* Create macros that are defined export libraries here/ */ /* Example: %let expsas=%str(libname expsas 'some-path';); */ %let expora=%str(libname expora oracle path=oracle.world schema=maschema user=user-ID password="{SAS002}xxxxxxxxxxxxxx"); /* END OF INTENDED USER-MODIFICATION SECTION */

Here is an example entry for a Teradata export library:

/* BEGIN INTENDED USER MODIFICATION SECTION */ /* Create macros that are defined export libraries here. */ /* Example: %let expsas=%str(libname expsas 'some-path';); */ %let exptera=%str(libname exptera teradata sql_functions=all server=teradata schema=ci_schema authdomain=TeradataAuth); /* END OF INTENDED USER-MODIFICATION SECTION */


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Customer Intelligence Plug-ins for SAS Management ConsoleMicrosoft Windows Server 2003 Standard Edition5.39.2 TS2M2
Microsoft Windows Server 2003 Enterprise Edition5.39.2 TS2M2
Microsoft Windows Server 2003 Datacenter Edition5.39.2 TS2M2
Microsoft® Windows® for x645.39.2 TS2M2
Microsoft Windows Server 20085.39.2 TS2M2
Microsoft Windows XP Professional5.39.2 TS2M2
Windows Vista5.39.2 TS2M2
64-bit Enabled AIX5.39.2 TS2M2
64-bit Enabled Solaris5.39.2 TS2M2
HP-UX IPF5.39.2 TS2M2
Linux for x645.39.2 TS2M2
Solaris for x645.39.2 TS2M2
* 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.