Reeza, I changed the format as you suggested to pull the distinct list, but still having issues matching the literal format in the follow up query. I changed the follow up query to : proc sql; create table work._temp as select datetime, date FORMAT=date9., valueX from myDataset where date = %scan(%bquote(&date_list), &i, %str(,)) order by datetime; quit; and I get the error: NOTE: Line generated by the macro function "SCAN". 1 24APR2013 ------- 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET, GROUP, GT, GTT, HAVING, LE, LET, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. Can you not put dates in macro variable list?
... View more