Multiple conditions in WHERE clause

[David_Billa]

I'm trying to understand the WHERE clause below and I want to tweak the where clause to include the condition

put(INITIAL_DT,yymmn6.) <= put(REPORTING_DT,yymmn6.) only when REPORTING_METHOD ^="ACS"

If REPORTING_METHOD ="OCS" then I want to include this condition put(INITIAL_DT,yymmn6.) >= put(REPORTING_DT,yymmn6.)

data test;
set IFR.ADS_OUTPUT;
where (REPORTING_METHOD ^="ACS" or put(INITIAL_DT,yymmn6.) <= put(REPORTING_DT,yymmn6.))
 & 
(REPORTING_METHOD ^="OCS" or put(INITIAL_DT,yymmn6.) >= put(REPORTING_DT,yymmn6.));
run;

I want to tackle this logic only using WHERE clause. Any help?

[Kurt_Bremser]

You've got your "and" and "or" wrong. According to your description, the condition should be

where
  REPORTING_METHOD ^= "ACS" and put(INITIAL_DT,yymmn6.) <= put(REPORTING_DT,yymmn6.)
  or 
  REPORTING_METHOD ^= "OCS" and put(INITIAL_DT,yymmn6.) >= put(REPORTING_DT,yymmn6.)
;