In each of these cases, the amount of work delegated to the DBMS is different. For the last case, the procedure delegates more work to the DBMS; for example, further processing is performed on the temporary table to create yet another temporary table or the final result set. The DBMS then either returns the final result set to the SAS session that is running the procedure or stores it in the database as a permanent table. The other general-use case that affects the amount of work that is delegated to the DBMS is when the data manipulation that a SAS.
