Help with WHERE clause

[hjkm]

Hi, I'm having troubles with a WHERE clause in a program I am trying to execute. I have multiple conditions I'd like to incorporate but I am getting an error. If anyone has any tips I would appreciate it.

Code is as follows. It's do with the OR statement in that WHERE query, but I'm not sure what I need to correct it. Any help appreciated.

data table1; set work.table;
where ColA="x" and
((Col_date>='01Jan1990'd and ColB="yellow")
or (Col_date>='01Jan1990'd and ColB="blue")) ;
run;

ERROR: Syntax error while parsing WHERE clause.
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, -, /, <, <=,
<>, =, >, >=, AND, EQ, GE, GT, LE, LT, NE, NOT, OR, ^, ^=, |, ||, ~, ~=.

ERROR 76-322: Syntax error, statement will be ignored

[hjkm]

Never mind I've managed to sort it out. FYI I had to move 'OR' to the end of the line above where it was previously was.

[Doc_Duke]

Although you fixed it by moving the 'OR', that was probably not the underlying problem. There is a good chance that you had an unprintable character buried in the WHERE clause and, in moving the 'OR' you removed the offending character.

BTW, you could simplify the logic of the WHERE to make it more readable (and probably more efficient) as

where ColA="x" and
Col_date>='01Jan1990'd and
(ColB="yellow" or ColB="blue") ;

Doc Muhlbaier
Duke

[LOK]

Hi, HJKM


data table;
cola='x';
col_date='01Jan1990'd;
colb='blue';
run;

data table1;
set work.table;
where ColA="x" and
((Col_date >= '01Jan1990'd and ColB = "yellow") or
(Col_date >= '01Jan1990'd and ColB = "blue")) ;

format col_date ddmmyy10.;
proc print;
run;