When using PROC SQL, notice that the data are displayed in the SAS OUTPUT window in display manager mode and written to the SASLIST DDname in batch mode, interactive line mode, and noninteractive mode ...

Notice also that the SELECT statement executes without your using a RUN statement, because the SQL procedure displays output data automatically, without your using the PRINT procedure, and executes ...

Key Features --Database Structure: Tables for Customers, Restaurants, DeliveryAgents, and Orders. --Dynamic Order Assignment: PL/SQL procedure to assign available delivery agents dynamically.

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