DATA step views are very versatile because they can harness the power of SAS DATA step processing, including DO loops and IF-THEN-ELSE statements. DATA step views do not have write capability, that is ...

You create PROC SQL tables from SAS data files, from SAS data views, from relational DBMS tables using the LIBNAME statement, or from relational DBMS tables using the SQL Procedure Pass-Through ...