Your SAS programs, embedded in web apps and elsewhere

Calling a SQL Stored Procedure

Reply
Occasional Contributor
Posts: 18

Calling a SQL Stored Procedure

I am having trouble with the code below. Similar code has worked before and I don't get errors but it doesn't seem to run the stored procedure.

Because I don't have rights to run a stored procedure under the schema dbo. I have created one under my own schema nscu\pauspar which I believe is where the problem is.

It connects, changes to temptables database.


PROC SQL;
CONNECT TO ODBC(dsn=nscu070t
);
EXECUTE (use temptables
exec sp_load_contact_history_bird
)
BY ODBC ;
DISCONNECT FROM ODBC ;
QUIT;
RUN;
SAS Employee
Posts: 285

Re: Calling a SQL Stored Procedure

The focus of this forum is SAS Stored Processes

http://support.sas.com/documentation/cdl/en/stpug/61271/HTML/default/a003152554.htm

Someone here may be able to provide you with an answer, but if not, you can try opening a track with our Technical Support department:

http://support.sas.com/ctx/supportform/createForm

Vince DelGobbo
SAS R&D
Super User
Posts: 5,257

Re: Calling a SQL Stored Procedure

Don't really follow you about what you think is the problem.
Can you run this stored procedure with same schema from some other interface to your database (which is...?).
If it has something to do with user rights, I suggest that you start by talking to some DBA that manages this DB.
/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 264 views
  • 0 likes
  • 3 in conversation