Because a stored process is basically a SAS program, it can access any SAS data source or external file as input
and can create multiple types of output, such as new data sets, files, and report output in a variety of formats.

code is not embedded in client applications it is stored on a server

SAS stored processes can be hosted by either the SAS Stored Process Server or the SAS Workspace Server