Help using Base SAS procedures

Can you query a SQL stored procedure? If so, what is a useful code?

Reply
Learner
Posts: 1

Can you query a SQL stored procedure? If so, what is a useful code?

 
Super User
Posts: 19,770

Re: Can you query a SQL stored procedure? If so, what is a useful code?

A stored procedure is a program, so I don't think so. You can execute a stored procedure that would generate output and query the output if required. It depends on what you're looking for and so far my answer is longer than your question Smiley Happy

Provide more details.

 

 

Super User
Posts: 3,250

Re: Can you query a SQL stored procedure? If so, what is a useful code?

[ Edited ]

An SQL stored procedure can be called in SAS using SQL passthrough and the EXECUTE statement. Here is an example using SAS/ACCESS to Oracle:

 

http://support.sas.com/kb/18/350.html

 

A stored procedure cannot be queried directly to provide a result set. It needs to create a table or view that can be read in a separate SQL query.  

 

Ask a Question
Discussion stats
  • 2 replies
  • 142 views
  • 0 likes
  • 3 in conversation