I'm using PROC SQL to run a stored procedure that runs more stored procedures. Unfortunately, it would appear as though the stored procedure is not executing fully, but I'm unsure where it is breaking in SAS. It runs just fine in SSMS. Is there a way to have the messages you see in SSMS returned in SAS? For example, I see several "(3 row(s) affected)" type messages in SSMS and would like them returned to SAS.
Note: SAS is not throwing an error message, it simply claims that the SQL executes successfully.
Any insight you have on this would be great. Thanks!