Send E-mail notification to SAS users whenever a new SAS Report object is made available to them.

[Alok_Pal]

Hi Folks,

Happy New Year to all. I hope everyone had a great break.

So, here's my first post for this new year.

Our leadership and developers want us to be able to send an email notification to all the SAS users whenever there is a new report object made available to them. I have been researching around this requirement but didn't find any relevant documentation or post. Any help with this requirement would be greatly appreciated.

Thank you.

[Kurt_Bremser]

Define "all users". How do you keep your list of users?

[Alok_Pal]

Hi @Kurt_Bremser,

Thanks for your response. Well, we have a all the SAS report consumer users grouped in a user group. We want to send notification to all the users within that group.
Please let me know if any further information is required.

Thank you.

[Kurt_Bremser]

---

@Alok_Pal wrote:


Well, we have a all the SAS report consumer users grouped in a user group.

---

In SAS metadata, in LDAP, in the system, in a SAS dataset ....?

[Alok_Pal]

KurtBremser,

These are all external user accounts in LDAP, and their group is defined in SAS metadata. I hope that answers your question, let me know otherwise.

[Kurt_Bremser · Accepted solution]

See this note: http://support.sas.com/kb/30/682.html how to extract user data and their group relationships from the metadata repository.

A google search for "sas extract users from metadata" will reveal lots of other resources dealing with user metadata.

Unless you have stored your email adresses in SAS metadata, you will have to query your LDAP base to retrieve them there.

[Alok_Pal]

@Kurt_Bremser,

Thanks and I appreciate that. I can extract the email addresses of the users but how will I automate the process of sending them notification about new report object being made available to them? Any thoughts?

Thank you.

[SASKiwi]

You can send email from a SAS DATA step based on a SAS data set containing email addresses. This link should help explain:

http://support.sas.com/documentation/cdl/en/hostunx/63053/HTML/default/viewer.htm#p1hl3t66coao7bn18v...

[Alok_Pal]

@SASKiwi, it seems the link you've shared is not available anymore. I totally agree with the concept of sending the emails via SAS DATA step but my question is how would I trigger that emailing event. Is there's a way to trigger the event either via SAS program or SAS MC or maybe something else?

[SASKiwi]

That link works fine for me. If not just google: SAS filename email statement 9.4. You could use the scheduler in SAS Management Console to run a job on a regular basis or just run it manually when the developer has published a new report.  

[Kurt_Bremser]

---

@Alok_Pal wrote:
@SASKiwi, it seems the link you've shared is not available anymore. I totally agree with the concept of sending the emails via SAS DATA step but my question is how would I trigger that emailing event. Is there's a way to trigger the event either via SAS program or SAS MC or maybe something else?

---

I've found that the new SAS documentation website seems to have issues with specific configurations of Firefox or PaleMoon. Try Chrome or another browser.

[Kurt_Bremser]

Try this link instead:

http://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.2&docsetId=lestmtsglobal&docsetTarget...