modify automatically my date in my ods excel path

[unifly]

Hi everyone,
I have an issue,

I would like to modify automatically my date in my ods excel path, but it doesn't work.

here my code :

%let date=20210101;

ods excel file='C:\Users\JOLYFI\Desktop\4M - Defaut DOU\DOUWEB_FACTO_&Date..xlsx'
    options(sheet_name='facto');

proc report data=DOUWEB_FACTO_&Date.;
run;

ods excel close;

when i run it, I have this title on my excel : DOUWEB_FACTO_&Date..xlsx instead of DOUWEB_FACTO_20210101.xlsx 

Someone know how to do ?

thank you

[mklangley · Accepted solution]

Try changing the single quotes around the path to double quotes. That way the macro variable &Date can resolve--it won't resolve inside single quotes.

ods excel file="C:\Users\JOLYFI\Desktop\4M - Defaut DOU\DOUWEB_FACTO_&Date..xlsx"