If you evaluate arithmetic or logical expressions you have to use the macro functions %EVAL for integer and %SYSEVALF for floating-point arithmetic.
In this case your example would look like
%let end_date = %sysfunc(today(),5.);
%let beg_date = %eval(&end_date - 60);
If datecolumn is a SAS Date Variable your SQL should work.
regards, Peter
... View more
