BookmarkSubscribeRSS Feed
hkotian
Calcite | Level 5
Can Stored Process bound to a Stored Process Server be used with SAS Information Maps or SAS Web Report Studio
3 REPLIES 3
Cynthia_sas
SAS Super FREQ
Hi:
Hi...there's not one yes/no answer to your question. The answer is No...and...Yes.

Here's why: A stored process can be executed on either the workspace server (WS) or the stored process (SP) server. However, some limitations come into play when you add Information Maps into the mix -- because Information Maps act as DATA sources, not as REPORT output.

WRS can -execute- a stored process that is defined to execute on the Stored Process (SP) Server or the Workspace (WS) server. To use the SP in this context of WRS, you would NOT choose a data source, for this section of the report or for this report. You would just insert the SP into the report area. We show this in our SP class -- the SP that you use could be executed on either server. Although, honestly, most people use the SP server for this scenario.

A stored process (SP) can also be used to provide data for an Information Map. Since Information Maps are "served up" by the Workspace server, then an SP that's bound to an Information Map or providing data to an Information Map, can ONLY execute on a Workspace server, as it says here: http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/program.html (look under the description of the Workspace server)
Information map stored processes are supported only on the workspace server.

So your question was:
"Can Stored Process bound to a Stored Process Server be used with SAS Information Maps or SAS Web Report Studio "

NO, your SP cannot be bound to an SP server if you're going to use is to populate an Information Map with the SP data results. Under this scenario, your SP must execute on the WS server. (The SP is providing DATA results to the Information Map & the Info Map is a DATA source in WRS.)
and
YES, your SP CAN execute on the SP server, if your SP results are just being inserted into a WRS report as REPORT output. (The SP is providing REPORT results to the WRS report.)

cynthia
hkotian
Calcite | Level 5
Thank you for the detailed response. It really helped
hkotian
Calcite | Level 5
Thank you for the detailed response. It really helped

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1144 views
  • 0 likes
  • 2 in conversation