any errors/notes/warnings from the sas log? did you check this sample note out - http://support.sas.com/kb/42/983.html ?  there is a sugi paper too http://support.sas.com/resources/papers/proceedings11/012-2011.pdf ... View more

I don't think this is possible. Stored processes are stored in SAS metadata which requires a metadata server, and then must be run on a Stored Process server which would be running on your SAS App server. Your local server cannot provide these capabilities.   You could test out the code that you are intending to use in the stored procedure though. ... View more