An SQL stored procedure can be called in SAS using SQL passthrough and the EXECUTE statement. Here is an example using SAS/ACCESS to Oracle:
http://support.sas.com/kb/18/350.html
A stored procedure cannot be queried directly to provide a result set. It needs to create a table or view that can be read in a separate SQL query.
... View more