Knowledge Article View - Customer Support

Running a Base SAS procedure that has been enabled for in-database processing might result in the following error:

NOTE: SQL generation will be used to perform the initial summarization.
ERROR 22-322: Syntax error, expecting one of the following: a name,
a quoted string, a numeric constant, a datetime constant,
a missing value, (, *, +, -, ALL, ANY, BTRIM, CALCULATED,
CASE, INPUT, PUT, SELECT, SOME, SUBSTRING, TRANSLATE, USER.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR: Error during in-database processing.
NOTE: The SAS System stopped processing this step because of errors.

This issue might occur when a WHERE statement or data set option is included in the procedure call and the WHERE condition includes a truncated operator. Some of the truncated operators that cause the error include NE:, =:, LT:, GT:, and so on.

Some procedures stop processing completely. For others, the procedure issues the error but continues to generate results. Here are some examples:

PROC FREQ generates results.
PROC MEANS stops processing due to error.
PROC RANK generates results, although an additional error might appear in the log because SAS does pass the truncated operator and this results in a database error.
PROC REPORT stops processing due to error.
PROC SORT generates results with sorting done in the database and the subsetting processed by SAS.
PROC SUMMARY stops processing due to error.
PROC TABULATE stops processing due to error.

There is currently no workaround for this issue.

An error occurs when you use a truncated comparison to run a Base SAS® procedure that is enabled for in-database processing