Correct. But it is also possible for the stored proc to also contain developer-added return codes, in which case both are often collected and returned in an output parameter on the stored proc. Apart from the restriction that no result set is allowed from the SAS EXECUTE statement, I've found copying SQL between SAS EXECUTEs and SQL Server Management Studio works fine. The above example took a lot of mucking around to get right - I did find the basic method in a SAS Note which I could find for you if you are interested.
... View more