BookmarkSubscribeRSS Feed
2 REPLIES 2
Reeza
Super User

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 🙂

Provide more details.

 

 

SASKiwi
PROC Star

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.  

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1054 views
  • 0 likes
  • 3 in conversation