topic SAS Delivery Portal E-Mail report in SAS Web Report Studio

SAS Delivery Portal E-Mail report

metalray — Wed, 10 Aug 2011 14:24:29 GMT

Hello friends of SAS Software,

We deploy the delivery portal and wonder how we can schedule weekly reports to be delivered to subscribers via email.

So far I have seen a .pdf paper that suggests examples, one of them via code, but none using the delivery portal.

Is what we are looking for possible?

Thanks,

Bob

SAS Delivery Portal E-Mail report

RSB — Thu, 11 Aug 2011 09:47:33 GMT

Hi Bob,

You may check more about SAS Publication channels . A Google search on "SAS Publication Channels" has resulted in these links.

http://support.sas.com/kb/36/401.html

http://support.sas.com/documentation/cdl/en/biwaag/63149/HTML/default/viewer.htm#ag_saschannels.htm

SAS Delivery Portal E-Mail report

metalray — Thu, 11 Aug 2011 10:06:00 GMT

Hello,

Thanks for that.

http://support.sas.com/kb/36/401.html
We want to share Reports that are generated via an STP and it seems the publication channel does not give
the option to publish via email (I read Archive or WebDAV).

http://support.sas.com/documentation/cdl/en/biwaag/63149/HTML/default/viewer.htm#ag_saschannels.htm
The second link says "Information can be published using various delivery methods, including SAS publication channels, message queues, e-mail, and files."
Here we read "e-mail" that seems to be a good key word concerned with our problem.

But then it stops with E-Mail Transport Restriction and a nice reference to the SAS Publishing Framework: Developer's Guide..
Which I also read by the way.

We gave up on the idea to send out reports via email since it seems we would have to first store
them somewhere in the SAS file system. Which is not pretty having 130 reports every week.
We are down to just sending out notifications that the report has been run, maybe even cached, or maybe
even that it is just available. Is there a way to do that?

SAS Delivery Portal E-Mail report

metalray — Fri, 12 Aug 2011 12:43:01 GMT

We think that the publishing framework might not really cover all our requirements. It would be great to have a report weely (sunday) executed and hence cached with a notification to users

that that happened but the word scheduling does not even come up in any doc. Is it right that an email will only be sent if a new report has been added to the channel?

I am sure in SAS DI there is such a "send email" task but we are not using SAS DI.

SAS Delivery Portal E-Mail report

AngelaHall — Wed, 21 Sep 2011 23:24:55 GMT

You could add an optional prompt for email addresses to the stored process. Then if this is entered, then an additional couple lines of code are added to the program to output to EMAIL.

Essentially:

filename outbox email 'ron@acme.com';

goptions device=PNG;

ods pdf file=pdfout;

ods pdf close;

The results still appear on the users browser screen and the stored process report is immediately sent to ron@acme.com.

Hope this provides you another option.

~ Angela Hall

http://blogs.sas.com/content/bi