I'm executing a MS SQL Stored Procedure from SAS DI Studio like this:
PROC SQL ; CONNECT TO odbc (&_OUTPUT1_connect.) ; EXECUTE (TheStoredProcedure) BY odbc ; DISCONNECT FROM odbc ; QUIT ;
However the Stored Procedure contains print messages like:
PRINT 'Rows inserted: ' + CAST(@rowsInsertedHD AS VARCHAR(100))
And those messages are come back as warnings in SAS.
Is there any way to suppress those warnings, without altering the Stored Procedure?
What scheduler do you use? You might be able to tweak the batch script file to ignore warnings in this case. You could also open a track with SAS Tech Support to see if they have any other ideas.
I'm assuming here there is no possibility of getting the stored procedure changed as that would be the best option.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.