I was wondering if there was a way to reference date macro variable in proc SQL like operator.   For example, I want to reference macro variable PREVDATE in like operator. Please refer code example below:   %LET PREVDATE = %sysfunc(intnx(day,%sysfunc(inputn(&sysdate9,date11.)),-2,end),); %LET PREVDATE = %sysfunc(putn(&PREVDATE,date11.)); %PUT &PREVDATE;   Proc sql; Create table XYZ as Select distinct A, B  From C Where B like '%&PREVDATE.%'; quit; ... View more