Problem Note 68434: A WHERE clause that contains a like operator with a wildcard might cause CAS actions to fail
 |  |  |  |  |
A WHERE clause containing a like operator with a wildcard might cause SAS® Cloud Analytic Services (CAS) actions to fail. The following syntax provides an example of this type of WHERE clause:
proc cas;
table.loadTable / path='example.sashdat', caslib='incl', casOut={name='outtable', caslib='outcl'}, where='emp_name like ''B%''';"
quit;
table.loadTable / path='example.sashdat', caslib='incl', casOut={name='outtable', caslib='outcl'}, where='emp_name like ''B%''';"
quit;
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.5 | 3.5 | Viya | Viya |
Viya 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: | 2021-09-29 10:07:31 |
| Date Created: | 2021-09-23 16:16:06 |