Hi:
*ProcessBody; is a comment that is used for a specific purpose regarding the initialization of macro variables and when macro variables are made available to the stored process. It has to do with the difference between the Workspace Server and the Stored Process Server, as described here:
http://support.sas.com/kb/14/861.html
http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/input.html
http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/stpmacro.html
As a best practice, in class, we recommend that you ALWAYS use the *ProcessBody; comment because then you have the most flexible stored process that could run on either server without any editing of the SP code, as described here from the doc:
"Parameters are not initialized in the same way for the stored process server and the workspace server. The stored process server sets parameter values before the stored process begins to execute. This means the first line of code in the stored process can access any input parameter macro variable. The workspace server does not set input parameters into macro variables until it reaches a *ProcessBody; comment line in the stored process:
*ProcessBody;
A stored process that does not contain this line will never receive input parameters when executed on a workspace server.
It is recommended that you begin all stored processes (regardless of the server types) with %GLOBAL declarations for all of your input parameters followed by the *ProcessBody; comment:"
I also included the link for %stpbegin; and %stpend; (note that those are actually very LONG macro programs and to use them correctly, they MUST have ending semi-colons to correctly terminate the invocation string. Any overrides to the reserved macro paramters MUST appear BEFORE the %stpbegin; invocation.
Some examples of stored processes and how to convert existing programs and macros to stored processes are contained in these papers (however, none of these papers discuss using ASP or .NET -- they just focus on changing the SAS code & reasons & techniques):
http://www2.sas.com/proceedings/forum2007/021-2007.pdf
http://www2.sas.com/proceedings/forum2008/024-2008.pdf
http://support.sas.com/rnd/papers/regional07/paradigm_edu07.zip
http://support.sas.com/rnd/papers/regional08/SP_Template.pdf
You could have been getting an error because of the absence of the *ProcessBody. Without seeing the log message or your entire SP code, I don't know why you're getting errors. You might want to work with Tech Support, if the errors persist after you use *ProcessBody.
cynthia