Attached files in automail with specific dates

[mmea]

Hi I am making an automatic mail everyday where the file i attached included following in the name: 2021_05_06_thursday

The date changes every day so tomorrow it will be 2021_05_07_friday

How can I make a macro that can generate this 

[Kurt_Bremser]

Please post your code that sends one mail, we can then show you how to make it dynamic.

[Sajid01 · Accepted solution]

Hello
The following macro generates the date as you have desired

%sysfunc(translate(%sysfunc(date(),yymmdd10.)_%sysfunc(trim(%sysfunc(date(),downame10.))),'_','-'));

For today's date it will give this output :2021_05_06_Thursday as can be seen in the log below

 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         %put %sysfunc(translate(%sysfunc(date(),yymmdd10.)_%sysfunc(trim(%sysfunc(date(),downame10.))),'_','-'));
 2021_05_06_Thursday
 74         
 75         
 76         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

[mmea]

Can I make the name of the days in the week (etc. Thursday) to another language?

[Sajid01]

1.Can I make the name of the days in the week (etc. Thursday) to another language?

 I suggest you contact SAS Tech Support.

2.I think your original question is resolved, please mark it solved.

[Kurt_Bremser]

---

@mmea wrote:

Can I make the name of the days in the week (etc. Thursday) to another language?

---

Use the NLDATEWNw. format:

%put %sysfunc(date(),NLDATEWN20.);

It will display the weekday according to your locale.