I am still learning both SQL and re-aquainting myself with SAS via SAS EG/LE. I haven't had time to actually run this code but here is what my research seems to indicate.
I just got done looking at the "PROC SQL essentials code samples" available here on the website. It appears you mostly use the exact same code you would in an SQL editor window to execute the stored procedure.
Below is a sample of executing some SQL against an Oracle database that is located on the same pc as Enterprise Guide. Below that is guess at an example of code for a stored procedure and executing it in Ms SQL.