Generating metadata for character variables using the SAS^® Customer Intelligence Information Map Metadata Generation Plug-in for SAS^® Management Console with PROC SQL might fail if the underlying data is held in a SAS Scalable Performance Data Server database instance. An error similar to the following occurs in the SAS^® Stored Process Server log:

NOTE: Implicit SQL:  select table0.RANDBIN as RANDBIN_1, COUNT
(distinct table1.subject1) as COUNT1 from xxxx table1 inner 
join yyyy table2 on table1.subject2 = table2.subject2 inner 
join zzzz table0 on table2.subject2 = table0.subject2 group by
table0.RANDBIN_1
SPDS_ERROR: Column RANDBIN_1 could not be found in the table
identified with the correlation name table0.

SPDS_ERROR: SQL passthru expression contained errors.

To work around this problem, choose the SUMMARY procedure to generate metadata rather than PROC SQL.

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

Operating System and Release Information

A fix for this issue for Base SAS 9.21_M1 is available at: