Multiple conditions in WHERE clause

David_Billa — Tue, 17 Dec 2019 12:06:09 GMT

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?

Re: Multiple conditions in WHERE clause

Kurt_Bremser — Tue, 17 Dec 2019 12:27:55 GMT

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.)
;

topic Multiple conditions in WHERE clause in SAS Programming

Multiple conditions in WHERE clause

Re: Multiple conditions in WHERE clause