Advanced Topics

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, 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.

Top of Page

Previous Page
|
Next Page
|
Top of Page