Help using Base SAS procedures

Oracle Extract w SQL and then sort

Reply
Super Contributor
Posts: 292

Oracle Extract w SQL and then sort

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;
Valued Guide
Posts: 2,177

Re: Oracle Extract w SQL and then sort

> 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;
Ask a Question
Discussion stats
  • 1 reply
  • 92 views
  • 0 likes
  • 2 in conversation