SUPPORT / SAMPLES & SAS NOTES
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 |