Oracle Extract w SQL and then sort

Bill — Thu, 11 Nov 2010 14:37:54 GMT

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;

Re: Oracle Extract w SQL and then sort

Peter_C — Thu, 11 Nov 2010 17:23:16 GMT

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

topic Re: Oracle Extract w SQL and then sort in SAS Procedures

Oracle Extract w SQL and then sort

Re: Oracle Extract w SQL and then sort