Hi, I have this piece of code: proc sql;
&oraconnect;
execute (create table bc as
select
a.key_num,
from warehouse_gbr.vtb_acct a
where a.dat_chrg_off >= to_date('01MAY2020','DDMMYYYY')
and a.dat_chrg_off < to_date('01JUN2020','DDMMYYYY')
order by a.key_num)
by ora ;
disconnect from ora;
quit; and I am trying to pass those variables date1 instead of May date and date2 instead of June date (see below). Data _NULL_;
call symput('date1',put(intnx('month',today(),0),date9.));
call symput('date2',put(intnx('month',today(),1),date9.));
Run;
%put &date1;
%put &date2; Is there a way to do this? I tried multiple things and they do not work.
... View more