Here is a list of some (but not
all) SAS WHERE clause conditions that are not acceptable to
CA-Datacom/DB; they are handled
automatically by SAS post-processing.
-
arithmetic expressions:
where c1=c4*3
where c4<-c5
-
expressions in which a
column or combination of columns assumes a value of 1 or 0 to signify true or false, for
example,
where c1
where (c1=c2)*20
-
concatenation of character columns
-
truncated comparison:
c1=:abc
-
DATETIME and TIME formats:
'12:00't
'01jan60:12:00'dt
-
-
-
references to missing values.
This includes the period (.) for numeric columns, blanks for character
columns, and the IS MISSING and IS NULL operators.