A new update is available for Base SAS , version 9.4_M5 :
Issues addressed in B6Q096
| SAS Note 65537 | An SQL procedure might generate incorrect results when a variable is renamed in a query |
| SAS Note 65539 | A query might return incorrect results if it contains an SQL JOIN to a variable that was created in an SQL view |
| SAS Note 65553 | A query passed to a database might not include the ORDER BY clause when a variable is renamed |
| SAS Note 65563 | You encounter performance problems when a query passed to a database does not include a WHERE clause |
| SAS Note 65581 | An SQL procedure query that creates a SAS® table returns a \"Write Access Violation\" error |
| SAS Note 65597 | An SQL procedure query with a WHERE clause that contains multiple subselects might return incorrect results |
| SAS Note 65766 | Ambiguous column or duplicate column errors might occur when running a query against a database |
| SAS Note 66193 | Joining multiple DBMS tables might result in performance issues because some of the processing is done in SAS® rather than in the database |
| This list of notes might be incomplete. For a complete list of issues addressed by this hot fix, visit the hot fix page for B6Q096 |
Note: A comprehensive list of all SAS hot fixes is available from support.sas.com. You can use the SAS Hot Fix Analysis, Download, and Deployment (SASHFADD) tool to manage your SAS hot fixes.
