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? ... View more

I have multiple extract transformations in my SAS DI Job and all those extract transformations has the following condition under 'where' tab   VALID_FROM_DTTM <= DATETIME () AND VALID_TO_DTTM >=DATETIME () & REPORTING_METHOD = "&REPORTINGMETHOD" & REPORTING_DT = &REPORTINGDATE Now I was asked to add the one more condition based on REPORTING_METHOD. If REPORTING_METHOD is "ACS" then I have to add the condition like     put(INITIAL_RECOGNITION_DT,yymmn6.) <= put(REPORTING_DT,yymmn6.)  If REPORTING_METHOD is "OCS" then I have to add the condition like     put(INITIAL_RECOGNITION_DT,yymmn6.) >= put(REPORTING_DT,yymmn6.) It means I have to write a code to conditionally change the filter condition which I'm not certain how to handle it in Extract transformation.     VALID_FROM_DTTM <= DATETIME () AND VALID_TO_DTTM >=DATETIME () & REPORTING_METHOD = "&REPORTINGMETHOD" & REPORTING_DT = &REPORTINGDATE & put(INITIAL_RECOGNITION_DT,yymmn6.) <= put(REPORTING_DT,yymmn6.) /*if REPORTING_METHOD is "ACS" */   Appericiate if someone of you guide me here.         ... View more