topic Re: SAS DI - Data Validation: email multiple recipients in SAS Data Management

SAS DI - Data Validation: email multiple recipients

R_Chung — Tue, 23 May 2017 10:01:03 GMT

Hello everyone,

I am encountering a problem of sending email to multiple recipients when I was using SAS DI - Data Validation.

If I want to do the multiple recipients, what should I need to type?

I have tried:

1. abc@xxxmail.com efg@xxxmail.com

2. abc@xxxmail.com, efg@xxxmail.com

3. abc@xxxmail.com; efg@xxxmail.com

4. 'abc@xxxmail.com' 'efg@xxxmail.com'

5. 'abc@xxxmail.com', 'efg@xxxmail.com'

6. 'abc@xxxmail.com'; 'efg@xxxmail.com'

7. "abc@xxxmail.com" "efg@xxxmail.com"

8. "abc@xxxmail.com", "efg@xxxmail.com"

9. "abc@xxxmail.com"; "efg@xxxmail.com"

They don't work. Is there any suggestions?

Re: SAS DI - Data Validation: email multiple recipients

LinusH — Tue, 23 May 2017 11:06:31 GMT

I don't have DI Studio at my fingertips to check.

But as always with DIS, look at the generated code to get a clue on how to enter things.

As I recall it, I think that we referred to a mail group instead. I think that is also better, so you don't build in hard coded "data" into the ETL jobs.

Re: SAS DI - Data Validation: email multiple recipients

SaiPotluri — Tue, 23 May 2017 17:03:49 GMT

You may create a variable in the SAS Job Pre-code as follows and use that in the Data Validation Transformation Email Adress.

%let email_address = %str(%(%"abc@xxxmail.com efg@xxxmail.com%" %"abc@xxxmail.com efg@xxxmail.com%"%));

use &email_address. in the Data Validation Transformation Email Address

I would suggest to create a SAS Macro which assigns different email adresses based on the environment and call that in the SAS ETL Job pre-code and use the &email_address. where ever it is needed.

Thanks,

Sai.

Re: SAS DI - Data Validation: email multiple recipients

Quentin — Tue, 23 May 2017 17:50:34 GMT

@SaiPotluri do you really need the macro quoting? I would think:

%let email_address = ("abc@xxxmail.com" "efg@xxxmail.com" "abc@xxxmail.com" "efg@xxxmail.com");

Would do the same thing. Since you don't have unmatched quote marks or unmatached parentheses, I don't think you need the macro quoting.

Re: SAS DI - Data Validation: email multiple recipients

SaiPotluri — Tue, 23 May 2017 18:13:03 GMT

@Quentin Yes, that's right. We don't really need the macro quoting.

Re: SAS DI - Data Validation: email multiple recipients

R_Chung — Wed, 24 May 2017 03:16:13 GMT

What is macro quoting

Re: SAS DI - Data Validation: email multiple recipients

R_Chung — Wed, 24 May 2017 03:16:52 GMT

As I am using DI Studio, so i have tried this method before but seems fail

Re: SAS DI - Data Validation: email multiple recipients

Quentin — Wed, 24 May 2017 12:56:09 GMT

Do you get an error message in the log?