SAS/ACCESS Interface to CA-DATACOM/DB: Reference

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

arithmetic expressions, for example,
```
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, for example,
```
c1=:abc
```
DATETIME and TIME formats, for example,
```
'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.