Hi, Currently in my SQL code written in SAS this is being used:- Where date_column ='01AUG20'd (20 is for last year) I am trying to change it to make it dynamic and i have prepared below to replace this hard code I. Below to make the variable %LET Last_Year= %substr(%sysfunc(intnx(day,%sysfunc(today()),-365),date7.),3); /*,3,2); */ %LET Last_YY = 01&Last_Year. ; %PUT &Last_YY.; II. This is how i used it but its giving error WHERE datecolumn= '&Last_YY.'d But this is giving error. how can i use this variable LAST_YY as a date for this WHERE clause Error:- Invalid date/time/datetime constant '&Last_YY.'d. Kindly provide the help. Thanks, Raman
... View more