DATA Step, Macro, Functions and more

Data Step WHERE Clause

Reply
N/A
Posts: 0

Data Step WHERE Clause

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
Super Contributor
Super Contributor
Posts: 3,174

Re: Data Step WHERE Clause

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.
Super Contributor
Super Contributor
Posts: 3,174

Re: Data Step WHERE Clause

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

Scott Barry
SBBWorks, Inc.
Contributor
Posts: 29

Re: Data Step WHERE Clause

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?
N/A
Posts: 0

Re: Data Step WHERE Clause

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

thanks again!
Ask a Question
Discussion stats
  • 4 replies
  • 780 views
  • 0 likes
  • 3 in conversation