topic Re: Email Automation in SAS Programming

Email Automation

Jyuen204 — Wed, 03 Mar 2021 13:49:00 GMT

I have a piece of code that exports and emails the file to a distribution list.

%let subject = Report for the week of &REPORT_DT.;
filename mymail email to=('EMAIL@EMAIL.CA')
subject=%bquote(&subject.)
attach=("/data/bi/data/inbox/MTS/&ENAME..csv" content_type="application/xlsx");

REPORT_DT is just an address created for the reporting data to stamp within the subject line

However this generates an error when I run this.

If I ran it like below it works but I cannot use the REPORT_DT to timestamp the subject line

filename mymail email to=('EMAIL@EMAIL.CA')
subject='TEST Promo Report'
attach=("/data/bi/data/inbox/MTS/&ENAME..csv" content_type="application/xlsx");

Re: Email Automation

AMSAS — Wed, 03 Mar 2021 14:33:25 GMT

Hi,
It would be helpful if you provided the log with the following macro options turned on

options mprint symbolgen ;

At a guess you have some kind of macro variable resolution issue, and I would start with trying this:

options mprint symbolgen ;
%put Report Date : &Report_DT
%let subject =  Report for the week of &REPORT_DT.;
%put Subject: &subject ;
filename mymail email to=('EMAIL@EMAIL.CA')
subject="Report for the week of &REPORT_DT." ;
attach=("/data/bi/data/inbox/MTS/&ENAME..csv" content_type="application/xlsx");

Re: Email Automation

Jyuen204 — Wed, 03 Mar 2021 14:40:01 GMT

29 options mprint symbolgen ;
SYMBOLGEN: Macro variable REPORT_DT resolves to Sunday, February 21, 2021
30 %let subject = BI9161 GCPromo Report for the week of &REPORT_DT.;
31 filename mymail email to=('jason.yuen@bellmts.ca')
32 subject=%bquote(&subject.)
SYMBOLGEN: Macro variable SUBJECT resolves to BI9161 GCPromo Report for the week of Sunday, February 21, 2021
NOTE: Line generated by the macro function "BQUOTE".
32 BI9161 GCPromo Report for the week of Sunday, February 21, 2021
_______
23
ERROR 23-2: Invalid option name GCPromo.

32 ! BI9161 GCPromo Report for the week of Sunday, February 21, 2021
______
23
ERROR 23-2: Invalid option name Report.

32 ! BI9161 GCPromo Report for the week of Sunday, February 21, 2021
___
23
ERROR 23-2: Invalid option name for.

32 ! BI9161 GCPromo Report for the week of Sunday, February 21, 2021
___
23
ERROR 23-2: Invalid option name the.

2 The SAS System 08:37 Wednesday, March 3, 2021

32 ! BI9161 GCPromo Report for the week of Sunday, February 21, 2021
____
23
ERROR 23-2: Invalid option name week.

32 ! BI9161 GCPromo Report for the week of Sunday, February 21, 2021
__
23
ERROR 23-2: Invalid option name of.

32 ! BI9161 GCPromo Report for the week of Sunday, February 21, 2021
______
23
ERROR 23-2: Invalid option name Sunday.

32 ! BI9161 GCPromo Report for the week of Sunday, February 21, 2021
________
23
ERROR 23-2: Invalid option name February.

33 /*subject='BI9161 GCPromo Report'*/
SYMBOLGEN: Macro variable ENAME resolves to GCPROMO_Report_03MAR2021
34 attach=("/data/bi/data/inbox/MTS/&ENAME..csv" content_type="application/xlsx");
ERROR: Error in the FILENAME statement.

Re: Email Automation

Jyuen204 — Wed, 03 Mar 2021 15:26:43 GMT

After some more tinkering I figured out the issue.

For me to include the REPORT_DT variable I need to use double quotes in the Subject Line

filename mymail email to=('email@email.ca')
subject= "Report for the week of &REPORT_DT."
attach=("/data/bi/data/inbox/MTS/&ENAME..csv" content_type="application/xlsx");