Data Step WHERE Clause

[deleted_user]

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

[sbb]

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.

[sbb]

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

Scott Barry
SBBWorks, Inc.

[garybald]

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?

[deleted_user]

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

thanks again!