Help using Base SAS procedures

How do you return the messages you would see in SQL Server Management Studio into SAS?

Reply
New Contributor
Posts: 4

How do you return the messages you would see in SQL Server Management Studio into SAS?

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!

Ask a Question
Discussion stats
  • 0 replies
  • 166 views
  • 0 likes
  • 1 in conversation