Oracle Extract w SQL and then sort

[Bill]

In the code below, ordering is done in the Oracle world prior to bring the data into the SAS table. Is there a way to do the ordering (sorting) within this same section of code but outside of the Oracle passthru section?

proc sql;
&connect;

create table Sales as
select *,
4 as value
from connection to oracle
(
select *

from sales_ord
where rownum < 9
order by cat_no
);
quit;

[Peter_C]

> In the code below, ordering is done in the Oracle
> world prior to bring the data into the SAS table. Is
> there a way to do the ordering (sorting) within this
> same section of code but outside of the Oracle

> where rownum < 9
>
> ) order by cat_no ;
> quit;