PROC SQL is a powerful Base SAS7 Procedure that combines the functionality of DATA and PROC steps into a single step. ... PROC SQL can be used to retrieve, update, and report on information from SAS data sets or other database products.

What is PROC SQL used for?

PROC SQL uses SQL to create, modify, and retrieve data from tables and views (and SAS data sets). PROC SQL can be used in batch programs or during an interactive SAS session. PROC SQL can perform many of the operations provided by the DATA step, and the PRINT, SORT, MEANS and SUMMARY procedures.

What does Proc mean in SQL?

A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDBMS). Such procedures are stored in the database data dictionary.