modify automatically my date in my ods excel path

unifly — Wed, 13 Jan 2021 18:03:42 GMT

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

Re: modify automatically my date in my ods excel path

mklangley — Wed, 13 Jan 2021 18:22:34 GMT

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"

topic modify automatically my date in my ods excel path in SAS Programming

modify automatically my date in my ods excel path

Re: modify automatically my date in my ods excel path