I think the below code may help you %let st_dt = '11FEB2014'd; %put &st_dt; data _NULL_; /*to use the same date with diffrent date format*/ call symput("wst_end","'"||put(&st_dt,date9.)||"'d"); %put &wst_end; /* goes 90 days back to the date present in the macro which you are passing */ call symput("wst1_end","'"||put(intnx('DAY',&st_dt,-90,'SAMEDAY'),date9.)||"'d"); %put &wst1_end; /*to use the same date in oracle quries (ie, connect to oracle ....) */ call symput("st_end","'"||put(&st_dt,date9.)||"'"); %put &st_end; run;
... View more