Traditional web-based reporting with SAS BI tools

SAS Delivery Portal E-Mail report

Reply
Regular Contributor
Posts: 207

SAS Delivery Portal E-Mail report

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

Contributor RSB
Contributor
Posts: 72

SAS Delivery Portal E-Mail report

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

Regular Contributor
Posts: 207

SAS Delivery Portal E-Mail report

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?


Regular Contributor
Posts: 207

SAS Delivery Portal E-Mail report

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 Employee
Posts: 238

SAS Delivery Portal E-Mail report

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;

<your sas procs here>

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

Ask a Question
Discussion stats
  • 4 replies
  • 358 views
  • 0 likes
  • 3 in conversation