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

Whoa, I totally read this as "how do I create an <B>average</B> function".<BR><BR>Ignore my post, Dandy Andy's got the SQL.