Hi,
How to call a sql stored procedure into SAS Viya 3.5?
I am running below code but it is throwing error.
PROC SQL; Connect to odbc (datasrc="****" user ="*****" password = "*******" ); create table t as select * from connection to odbc Execute(dbo.stp) by odbc; Disconnect from odbc; QUIT;
Error:
(Execute(dbo.stp)) by odbc;
------- -
79 22
76
ERROR 79-322: Expecting a SELECT.
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,
CONTAINS, EQ, EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
... View more