https://communities.sas.com/t5/SAS-Procedures/Where-Clause-Date-Error/m-p/76336#M22123 WHERE (ST = 'WY') AND (sale BETWEEN '31/JUL/08'D AND '30/JUN/09'D) ;<BR /> <BR /> You need to convert the dates to SAS dates. Wed, 21 Oct 2009 15:10:20 GMT Flip 2009-10-21T15:10:20Z https://communities.sas.com/t5/SAS-Procedures/Where-Clause-Date-Error/m-p/76335#M22122 How do I correct the error noted below. Thanks<BR /> <BR /> The sale date variable is formated as below:<BR /> informat sale mmddyy10.<BR /> <BR /> 101 WHERE (ST = 'WY') AND (sale BETWEEN '07/31/08' AND '06/30/09') ;<BR /> ERROR: Where clause operator requires compatible variables.<BR /> 102 run; Wed, 21 Oct 2009 14:32:54 GMT https://communities.sas.com/t5/SAS-Procedures/Where-Clause-Date-Error/m-p/76335#M22122 deleted_user 2009-10-21T14:32:54Z https://communities.sas.com/t5/SAS-Procedures/Where-Clause-Date-Error/m-p/76336#M22123 WHERE (ST = 'WY') AND (sale BETWEEN '31/JUL/08'D AND '30/JUN/09'D) ;<BR /> <BR /> You need to convert the dates to SAS dates. Wed, 21 Oct 2009 15:10:20 GMT https://communities.sas.com/t5/SAS-Procedures/Where-Clause-Date-Error/m-p/76336#M22123 Flip 2009-10-21T15:10:20Z