SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS DI - Data Validation: email multiple recipients

Accepted Solution Solved
Reply
Contributor
Posts: 38
Accepted Solution

SAS DI - Data Validation: email multiple recipients

Hello everyone,

 

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

 

sas.jpg

 

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?


Accepted Solutions
Solution
‎05-24-2017 12:24 AM
PROC Star
Posts: 1,231

Re: SAS DI - Data Validation: email multiple recipients

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

 

View solution in original post


All Replies
Super User
Posts: 5,256

Re: SAS DI - Data Validation: email multiple recipients

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.

Data never sleeps
New Contributor
Posts: 3

Re: SAS DI - Data Validation: email multiple recipients

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.

Solution
‎05-24-2017 12:24 AM
PROC Star
Posts: 1,231

Re: SAS DI - Data Validation: email multiple recipients

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

 

New Contributor
Posts: 3

Re: SAS DI - Data Validation: email multiple recipients

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

 

 

Contributor
Posts: 38

Re: SAS DI - Data Validation: email multiple recipients

What is macro quoting
Contributor
Posts: 38

Re: SAS DI - Data Validation: email multiple recipients

As I am using DI Studio, so i have tried this method before but seems fail
PROC Star
Posts: 1,231

Re: SAS DI - Data Validation: email multiple recipients

Do you get an error message in the log? 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 196 views
  • 0 likes
  • 4 in conversation