topic Re: Data Management Studio - Can't send email using SAS Code Node in SAS Data Management

Data Management Studio - Can't send email using SAS Code Node

smicha — Fri, 07 Sep 2018 09:21:44 GMT

Hi,

I am using Data Management Studio 2.7. I have created a process job where i get an email list and i pass it to the SAS Code Node via input and output variables. In the SAS Code Node i have a code to send a static email to every mail in the list.

The code is working fine if i insert in SAS Base, but when i try to run the process job i get the error showing the image below. Is there a specific configuration option in the dataflux that i am missing.

SAS Code Node Log

Thank you in advance.

Re: Data Management Studio - Can't send email using SAS Code Node

audrey — Fri, 07 Sep 2018 09:32:23 GMT

Hi,

Can you show th epart of the code that is actually sending the email and configuring how to send it?

The error seems to indicate the value for your smtp domain is not retrieved.

Thanks,
Audrey

Re: Data Management Studio - Can't send email using SAS Code Node

smicha — Fri, 07 Sep 2018 09:51:25 GMT

Hi Audrey,

Thank you for your response. The code is in the image below (i have omitted the %let statements cause they are automatically created as i run the SAS Code Node).

SAS Code

Using the exact same code in the SAS Base i send the email. You can check it in the image below. And i have confirmed it with the receiver.

Base SAS Log

As for the configuration in the SASHome\SASFoundation\nls\u8\sasv9.cfg are in the image below.

SMTP options in sasv9.cfg

Re: Data Management Studio - Can't send email using SAS Code Node

Kurt_Bremser — Fri, 07 Sep 2018 10:13:06 GMT

DI Studio uses a workspace server or the Data Step Batch server for execution. These need to be configured for email.

The .cfg files in the SASHome are irrelevant for this, you need to set that in the SASApp/sasv9_usermods.cfg file in the configuration tree of the BI server.

Re: Data Management Studio - Can't send email using SAS Code Node

smicha — Fri, 07 Sep 2018 10:37:49 GMT

Thank you for the response. Your solution worked perfectly.