topic Re: Help with WHERE clause in SAS Procedures

Help with WHERE clause

hjkm — Thu, 21 May 2009 13:55:07 GMT

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

Re: Help with WHERE clause

hjkm — Thu, 21 May 2009 14:52:07 GMT

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.

Re: Help with WHERE clause

Doc_Duke — Thu, 21 May 2009 15:37:34 GMT

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

Re: Help with WHERE clause

LOK — Fri, 22 May 2009 05:41:54 GMT

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;