Usage Note 37683: Defining a library for use with SAS® Marketing Automation Exports
 |  |  |  |
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 Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence Plug-ins for SAS Management Console | Microsoft Windows Server 2003 Standard Edition | 5.3 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 5.3 | 9.2 TS2M2 | ||||
| Microsoft® Windows® for x64 | 5.3 | 9.2 TS2M2 | ||||
| Microsoft Windows Server 2008 | 5.3 | 9.2 TS2M2 | ||||
| Microsoft Windows XP Professional | 5.3 | 9.2 TS2M2 | ||||
| Windows Vista | 5.3 | 9.2 TS2M2 | ||||
| 64-bit Enabled AIX | 5.3 | 9.2 TS2M2 | ||||
| 64-bit Enabled Solaris | 5.3 | 9.2 TS2M2 | ||||
| HP-UX IPF | 5.3 | 9.2 TS2M2 | ||||
| Linux for x64 | 5.3 | 9.2 TS2M2 | ||||
| Solaris for x64 | 5.3 | 9.2 TS2M2 | ||||
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2012-01-10 14:23:08 |
| Date Created: | 2009-11-02 10:56:44 |