I want to derive suffix from my_date for later use. I tried this code but it did not work %let my_date = 20180112; /* YYYYMMDD */
data suff;
format ref_date date9.;
ref_date = mdy(substr(put(&my_date,$8.),5,2), substr(put(&scoring_date,$8.),7,2), substr(put(&scoring_date,$8.),1,4));
suffix=catx('_','put(intnx('month',ref_date,-16),yymm.));',put(intnx('month',ref_date,-1),yymm.));
run;
proc sql;
select suffix into :suffix
from suff;
quit.
it doest work. Thanks, Jeff quit;
... View more