topic Re: Data Step WHERE Clause in SAS Programming

Data Step WHERE Clause

deleted_user — Thu, 01 Oct 2009 19:14:38 GMT

All of my criteria is not being recognized by SAS in the following WHERE clause syntax. How should I change it so it will work correctly. Thanks.

WHERE ST = "OK" AND prod = "G" AND O_TYPE = "RI" OR O_Type = "OR"; Message was edited by: dallin01

Re: Data Step WHERE Clause

sbb — Thu, 01 Oct 2009 19:27:00 GMT

You must take care when using AND along with OR in the same WHERE / IF expression. Suggest that you need to consider parentheses for the "OR" portion.

Scott Barry
SBBWorks, Inc.

Re: Data Step WHERE Clause

garybald — Thu, 01 Oct 2009 19:27:28 GMT

Try this
WHERE (ST = 'OK' AND prod = 'G') AND (O_TYPE in ('RI', 'OR'));

Also, is the data all caps or could there be lower case?

Re: Data Step WHERE Clause

sbb — Thu, 01 Oct 2009 19:29:43 GMT

For simplification, explore using the "IN" operator to combine OR expressions when based on a common variable.

Scott Barry
SBBWorks, Inc.

Re: Data Step WHERE Clause

deleted_user — Thu, 01 Oct 2009 19:40:29 GMT

I understand now! Thanks -- no data is lowercase--so should work perfectly.

thanks again!