A SAS stored process is a SAS program that is hosted on a server and described by metadata. One of the major values of stored processes is that they can be consumed by most SAS reporting tools, including SAS Portal, Web Report Studio, Enterprise Guide and the Addin for Microsoft Access.
I have always been a big fan of using them as I believe they are great for creating predefined business rules which users can consume in their reports without having to define any code.
There is an interesting paper at SUGI 31 Making your own Balanced Scorecard using the SAS Information Delivery Portal that describes how a combination of Stored Processes and the SAS Portal can be used to present users with a Balanced Scorecard.
Now if it was me I would have used SAS Strategic Performance Management , but then I hate reinventing the wheel.
But I think the paper shows how with a combination of SAS Portal and Stored Processes, ”there ain’t much you can’t do.
Recent Comments