Hello, I'm trying to write a macro to get yesterday's date and use it as part of a file name in my PROC EXPORT code. Desired file name would include the date in DATE9. format. My code: PROC EXPORT DATA=Work.Output OUTFILE="/sas/Applicable Claims &TEST..CSV" DBMS=CSV REPLACE; Run; Some of my TEST macros that I've tried (not on the same run): %let TEST= %sysfunc(%eval(Today()-1),DATE9.); %let TEST= %eval(TODAY()-1); %let TEST= %put %sysfunc(putn(%eval(%sysfunc(today())-1),date9.)); %let TEST= %put %sysfunc(intnx(day,%sysfunc(today()),-1),date9.); %let TEST= %put %eval(%sysfunc(today())-1); %let TEST = %eval(%sysfunc(today(),)-1); I'm writing free-lance code in EG 9.4 Thanks!
... View more