SAS WHERE Clause Conditions Not Acceptable to CA-Datacom/DB

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
  • SOUNDEX
  • HAVING, GROUP BY
  • references to missing values. This includes the period (.) for numeric columns, blanks for character columns, and the IS MISSING and IS NULL operators.