Problem Note 65453: The message "ERROR: Variable not found" occurs when you change the case of a column name using the alterTable CAS action
 |  |  |  |  |
If you change the case of a column name using the alterTable CAS action, the following error might occur:
A workaround is to change the column name in two steps, using an intermediate column name, as shown in the following example:
caslib="mycaslib"
columns={
{name="columnName1",RENAME="c1"},
{name="c1",RENAME="COLUMNNAME1"}
}
table="mytable";
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | 3.4 | |||
Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesWinViya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-02-03 14:36:39 |
| Date Created: | 2020-01-27 16:22:34 |