Ah, I understand. I believe that there's only ONE where statement/clause processor and it lives in the PROC SQL routine. SAS did not have WHERE before PROC SQL. Tech Support would know for sure. I know that the WHERE statement in a SAS proc works the same way as a WHERE in SQL -- the type (character and numeric) have to agree. So, for example, in an IF statement, I can say
[pre]
if numvar = '1';
[/pre]
and the IF statement will very nicely do a conversion for me, but a WHERE statement:
[pre]
where numvar = '1';
[/pre]
gets you an error message. Which all indicates to me that ANYTHING you can do in WHERE (because it "belongs" to SQL) will work.
cynthia