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 ...

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored procedure.<BR ...

Modifies a column's values in existing rows of a table or view. Restriction: You cannot use UPDATE on a table accessed via an engine that does not support UPDATE processing. You can update one or more ...