Problem Note 68060: SAS® Visual Data Builder generates incorrect SQL procedure code for scheduled queries
 |  |  |  |  |
SAS Visual Data Builder might generate incorrect PROC SQL code for scheduled queries. When this issue occurs, table references, column names, or both might be referenced incorrectly in the PROC SQL code. It is important to verify the generated code because the incorrect references might not generate warnings or errors, and they can introduce a data integrity concern.
This issue can occur when you schedule a new query or modify a migrated or promoted query. The problem is more likely to occur if the query joins two or more tables or it includes conditional column definitions that result in CASE statements in the generated PROC SQL code.
When this issue occurs, contact SAS Technical Support for assistance.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.51 | 7.52 | 9.4 TS1M7 | 9.4 TS1M8 |
| Linux for x64 | 7.51 | 7.52 | 9.4 TS1M7 | 9.4 TS1M8 | ||
A fix for this issue for SAS Visual Analytics 7.51 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I9T.html#68060| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-11-01 13:42:41 |
| Date Created: | 2021-06-18 12:03:19 |