Hello @dwaa,
as @SASKiwi indicated, please read the documentation if you have the chance, your questions are quite basic and general.
Let me give you some quick heads up, since I understand that a quick introduction might help. Very simple explained, a stored process is just a metadat object that can be called from almost everywhere in your SAS platform: EG, web applications, any sas code, and even can be created as web services if you have the SAS web server. This object will have many things in the definition, but the basics are just SAS code and some input/output parameters, if they are needed, but not necessary, because maybe you only need the code as with any SAS Base program.
Besides this quick introduction, the rest of the answers you will find them in the documentation.
... View more