It is also useful if you are running SQL statements from an SQL application in another SQL-based database. The second form uses a LIKE clause to create a table that has the same column names and ...

For more information about embedded libnames in PROC SQL views, see the SQL Procedure chapter in the SAS Procedures Guide. You can then drop your sample DBMS table and PROC SQL view by using a PROC ...