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 ...

Note: If you specify the NUMBER option in the PROC SQL statement when you create your view, the ROW column appears in the output. However, you cannot order by the ROW column in subsequent queries. See ...