Hi I want to import a file that will be automate the file has the day the file ran for example pop 05-14-17 How do I auto import where I need the most current file that is dated ? Thanks ... View more

I have a function that's is giving me a date range when I pull it I get and error DATA _null; start_date=today()-2; End_date=today ()-2; If weekday (start_date)=1 then start_day=start_day-1; Call symput ('dt', "'"||put (start_date, date.)||"'d'"); Call symput ('dt1', "'"||put (End_date, date.)||"'d'"); The orderdate is a datetime20 format (ts '2017-04-18 00:00:00:000) My where statement Where al1.order_date between &dt. And &dt1. Log Macro variable dt resolves to '22apr17'd Syntax error: expected something between a string or Unicode character literal and word 'd' ... View more