topic Re: Attached files in automail with specific dates in New SAS User

Attached files in automail with specific dates

mmea — Thu, 06 May 2021 12:21:21 GMT

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

Re: Attached files in automail with specific dates

Kurt_Bremser — Thu, 06 May 2021 12:49:22 GMT

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

Re: Attached files in automail with specific dates

Sajid01 — Thu, 06 May 2021 19:36:09 GMT

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;

Re: Attached files in automail with specific dates

mmea — Fri, 07 May 2021 08:44:25 GMT

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

Re: Attached files in automail with specific dates

Sajid01 — Fri, 07 May 2021 12:17:07 GMT

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.

Re: Attached files in automail with specific dates

Kurt_Bremser — Thu, 13 May 2021 10:44:42 GMT

@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.