sql语句在sas中的应用

This intermediate course focuses on using SQL as a data query and manipulation tool. You learn to use the SQL procedure as a data retrieval tool within SAS programs. Specifically, you learn how to perform queries on data; retrieve data from multiple tables; create views, indexes, and tables; and update or delete values in existing tables and views. Using features of the SQL procedure to debug, test, and optimize the performance of SQL queries is also discussed.