It is more efficient to omit the ORDER BY clause when you are creating the view and specify it as needed when you reference the view in queries. Note: If you specify the NUMBER option in the PROC SQL ...

To make matters worse, it is easy to make mistakes in SQL that can have real and potentially catastrophic consequences. For example, missing a WHERE clause in your instructions can cause you to ...