BookmarkSubscribeRSS Feed
Yennie
Calcite | Level 5
Just wondering if there is any article that explains the steps to create Stored Process?

And what exactly does it do?

cheers.
3 REPLIES 3
Cynthia_sas
SAS Super FREQ
Hi:
A SAS Stored Process is a SAS program that lives in a special location, defined to the Metadata Repository of the SAS Enterprise Intelligence Platform. The fact that the stored process definition and parameters are stored in the Metadata means that many different client applications (such as Web Report Studio and Enterprise Guide and the SAS Add-in for Microsoft Office) can all run the stored process program without the end-users needing to know anything about starting SAS or submitting programs -- they just use an interface that is comfortable for their level of expertise and usage -- and request the stored process to run (probably coded by someone else -for- them -- and then they get the results returned to their client application.

WHAT a stored process can do is a harder question to answer. What can a SAS program -do-??? A SAS stored process is just a SAS program. Usually, the full spectrum of SAS procedures and processes is available to you -- with the exception of programs that pop open the KEYS window or the CAT window or the VAR window -- because your stored process programs are running in "batch" mode -- so there's no way to pop a Display Manager window from within a stored process.

The documentation on Stored Processes in the Integration Technologies portion of the Enterprise Intelligence documentation talks about how to define and register stored processes. If you do NOT have the Enterprise Intelligence platform, it is unlikely that you can use stored processes, although some SAS solution products, like Marketing Automation do have a stored process like capability. Or, the SAS/IntrNet Application Dispatcher programs were in some sense the pre-cursor to SAS Stored Processes.

These 2 papers talk about stored processes from a programming/code standpoint.
http://www2.sas.com/proceedings/forum2008/024-2008.pdf
http://www.nesug.org/Proceedings/nesug07/ap/ap22.pdf

I'm sure if you Google on the topic, you can find other papers that talk about stored processes from the Enterprise Guide or Add-in for Microsoft Office standpoint or from a general overview standpoint.

cynthia
Yennie
Calcite | Level 5
Hey cynthia!

thank you so much.

You are awesome! 🙂
Cynthia_sas
SAS Super FREQ
Thanks! And here's an update, sent to me by a stored process guru -- who reminded me that:
Stored processes functionality is delivered with IT (SAS Integration Technologies), and can be used with a Base + IT license, providing they set up a Java application server and the WIK (Web Infrastructure Kit) (WIP in 9.2).


cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 741 views
  • 0 likes
  • 2 in conversation