Because the SQL procedure is based on the Structured Query Language, it works somewhat differently than some SAS procedures. For example, the SQL procedure executes without a RUN statement when a ...

CREATE PROCEDURE GetCustomer AS Next, you must add the SQL code specifically for a stored procedure, and it must look similar to the first example above.