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