Problem Note 67390: SAS® Visual Data Builder queries that use joined tables fail with "Column xxxx could not be found in the table/view"
If your SAS Visual Data Builder query includes three or more joined tables, the query might fail with one or more errors that are similar to the following:
ERROR: Column DIVISION could not be found in the table/view identified with the correlation name TABLE2.
This error occurs because SAS Visual Data Builder incorrectly generates the code to join the tables.
For example, you could encounter an issue in which TABLE1 is joined to TABLE2, and the results are joined to TABLE3. The column DIVISION is in TABLE1. The query fails because the code is incorrectly looking for DIVISION in TABLE2.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.5 | | 9.4 TS1M6 | |
Linux for x64 | 7.5 | | 9.4 TS1M6 | |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2021-04-05 14:46:04 |
Date Created: | 2021-02-09 14:40:06 |