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

Therefore, it is not necessary for the SAS System to call the DBMS when it creates a view descriptor. When you use the DBLOAD procedure to create a table, the procedure issues dynamic SQL statements ...