I created below macro
options symbolgen; %let T1 = %sysfunc(intnx(Day,"&sysdate"d,-9),mmddyy10); %let T2 = %sysfunc(intnx(Day,"&sysdate"d,-3),mmddyy10);
to bring records for previous week from oracle database ( has millions of records)
Proc sql ;
where datepart(a.trans_dt) >= &T1 AND datepart(a.trans_dt) <= &T2 order by a.trans_dt;
brings zero rows.
trans_dt is datetime variable.
How do I resolve? Please help
Thanks
we are using EG5.1 / SAS 9.1
if I use
where (datepart(a.trans_dt) >= intnx('week',today(),-1,'b') AND datepart(a.trans_dt) <=intnx('week',today(),-1,'e')); I get 64 rows but takes 2 hrs -- Hope it helps to understand
... View more