Proc SQL pass through is very fast compare to libname access, the execution of codes not happen in SAS the codes will process in oracle. I tried running your both code but not getting output, Please see ther log below 1 data have; 2 informat salesdate mmddyy10.; 3 format salesdate mmddyy10.; 4 input salesdate; 5 cards; NOTE: The data set WORK.HAVE has 6 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.10 seconds 12 ; 13 proc print;run; NOTE: There were 6 observations read from the data set WORK.HAVE. NOTE: PROCEDURE PRINT used (Total process time): real time 0.04 seconds cpu time 0.04 seconds 14 proc sql; 15 create table want as select * from have 16 where 17 intnx('month',today(),-3,'b') <= salesdate < intnx('month',today(),0,'b'); NOTE: Table WORK.WANT created, with 0 rows and 1 columns. 18 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.08 seconds cpu time 0.09 seconds
... View more