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

And what exactly does it do?

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.

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.

Calcite | Level 5
Hey cynthia!

thank you so much.

You are awesome! 🙂
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).




Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg



Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2 in conversation