However, there are differences between the various database servers in how they handle stored procedure calls ... can be called from standard SQL. This allows you to encapsulate complex application ...

You can use full, inline SQL statements in the prepared statement function or send the database a stored procedure function. A stored procedure is a program that is stored on the database server.

Stored compiled DATA step programs and DATA step views are similar in function. They both store DATA step programs ... the view is referenced as an input data set by another DATA or procedure (PROC) ...