When you use the SAS Data Integration Studio transformation Create or Add to a Cluster, invalid syntax is generated. This problem occurs if the SAS SPD (Scalable Performance Data) Server target-table option Enable special characters within DBMS object names is checked. When generating code to query for details about the target table, SAS Data Integration Studio fails to remove the quotation marks from the table name before quoting the string. The inner quotation marks and "n" should not be present in the memname= comparison string below:

27         proc sql;
28            create table work.SPDSTMP as
29               select memname length = 32
30                  from dictionary.tables
31                     where upcase(libname) = %upcase("&etls_libref") and
32                           upcase(memname) ^= %upcase("&etls_outdsn");
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: Line generated by the macro variable "ETLS_OUTDSN".
32         ""GEOGRAPHY_DIM"n
           49
NOTE: Line generated by the macro function "UPCASE".
32          ""GEOGRAPHY_DIM"N"
            49
              _____________
              22
              76

The only workaround is to edit the generated code and register it as user written.

Operating System and Release Information