You are meant to able in SQL as part of the SELECT ... WHERE statement to write temporary variables for display based on any one of a number of operators.
But, if you try to do this in the version embedded in SAS, it sure don't like it!
eg SELECT (LAST || ',' || FIRST) FULLNAME, AGE
This should extract the first and last names (presented as <Lastname,Firstname>) and the age from whatever dataset you're looking at.
However, on attempting to do this, I get a few of these errors:
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <,<=, <>, =, >, >=, ?, AND, AS, CONTAINS, EQ, FROM, GE, GT, LE, LIKE, LT, NE, OR,^=, |, ||, ~=.
Can anyone help explain why this is happening please?