When I want to include some SAS data into an Oracle extract, I first build a temporary Oracle table and include that as part of the extract syntax. It's probably gives better performance as well. Code below.
libname dw oracle user=userid
password=pw
path="@tns:xyx, buffsize=5000";
**Upload temptable to Oracle;
data dw.temptable;
set temptable;
run;
proc sql;
connect to oracle
(user=userid orapw=pw path="@tns:xyx, buffsize=5000");
**Analyze Oracle table for optimization purposes;
execute( analyze table temptable estimate statistics sample 1 percent) by oracle;
run;
quit;
Be sure to delete the temp table when done.
proc sql;
connect to oracle
(user=userid orapw=pw path="@tns:xyx, buffsize=5000");
execute (drop table temptable) by oracle;
run;
quit;
... View more
