topic Write SAS Code to Send Output through Email in Viya3.4 in SAS Programming

Write SAS Code to Send Output through Email in Viya3.4

Yiping — Fri, 22 May 2020 10:33:07 GMT

Hi SAS Experts!

I am wondering if it's possible to have some codes at the end of a scheduled job created in Job Execution to send the output to myself through email. Something similar to press the email button in the "Results" page:

Any input would be much appreciated. Thank you in advance!

Re: Write SAS Code to Send Output through Email in Viya3.4

Kurt_Bremser — Fri, 22 May 2020 11:03:56 GMT

You can send mails from code by using the FILENAME Statement (EMAIL Method)

Re: Write SAS Code to Send Output through Email in Viya3.4

s_lassen — Mon, 25 May 2020 19:29:46 GMT

You will probably want to write the output to a physical file (use ODS output statement), and then use a data step to send a mail with the file as an attachment, as @Kurt_Bremser wrote, look up the Email method in the filename statement.

Re: Write SAS Code to Send Output through Email in Viya3.4

Yiping — Wed, 27 May 2020 09:45:47 GMT

Thank you for your help!

I've tried to write the codes as you suggested. There wasn't any error from the codes, but I encountered authorization issue. I guess the admin team needs to enable this feature for me.

I'll reach out to the admin team then 🙂

Re: Write SAS Code to Send Output through Email in Viya3.4

Yiping — Wed, 27 May 2020 09:46:58 GMT

Thank you, sir, for your valuable input! 🙂

Re: Write SAS Code to Send Output through Email in Viya3.4

Yiping — Wed, 27 May 2020 10:29:44 GMT

Latest update, it turns out that it's a syntax error. I managed to send the email with attachment successfully after correcting the syntax.
Thank you!