What is the use of a SAS stored process? What can a stored process do that a normal sas program / macro cannot? It seems like a stored process is an unnecessary wrapper around a simple SAS program.
In my company, the stored process is the first layer on the server side that intercepts web requests and sends back response in the form of JSON.
Can a web request not directly interact with a SAS server side macro? IS that what the stored process is for? Some kind of a Mid Tier controller that acts as the gateway between web client and the SAS server side code?