Generating MAMetadata fails in SAS^® Marketing Automation 5.41 with the following error message:

NOTE: Line generated by the invoked macro "MAC_INC".
75

CREATE TABLE WORK.VIEW1 AS PROC
                          ----
                          22
                          76
75  ! SQL ;  connect to SASSPDS( HOST='spdsxxx.xx.xxx.xxx' SERV='5400'
ERROR 22-322: Syntax error, expecting one of the following: (, SELECT.

ERROR 76-322: Syntax error, statement will be ignored.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of
statements.
NOTE: Statement not executed due to NOEXEC option.
WARNING: Apparent invocation of macro RESULT_TABLE_NAME not resolved.
NOTE: Statement not executed due to NOEXEC option.

This problem occurs when the underlying data is stored in SAS Scalable Performance Data Server.

Click the Hot Fix tab in this note to access the hot fix for this issue.

After you apply the hot fix, you need to unzip the Metadata-STPs.zip file and download its contents. Next, import the Metadata-STPs.spk file to the /System/Applications/SAS Customer Intelligence/SAS Customer Intelligence 5.4/Stored Processes folder in the Folders view in SAS^® Management Console.

Perform the following tasks in the Import Package Wizard:

1. Enter the location and name of the package file and select All Objects. Click Next.
2. Ensure that all objects are selected and then click Next.
3. An information page is displayed, which informs you that some metadata properties might need to be changed. Click Next.
4. Choose the application server that will be used to run the stored processes.
5. Enter the path to the actual stored processes. For a standard installation, this path is as follows:
   • Windows: C:\Program Files\SASHome\SASFoundation\9.3\ma\sasstp
   • UNIX: SASHOME/SASFoundation/9.3/sasstp/ma
6. Click Next.
7. Inspect the package import summary. Click Next.
8. Click Finish.

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 5.41 is available at: