For Example
all data steps reading data from the “dat” library would use four threads:
libname dat oracle schema=dat_owner user=testuser pw=XXXXXXXX path=datdbp dbsliceparm=(ALL,4);
You can also use the DBSLICEPARM option on only selected data steps, rather than on the LIBNAME statement, as this example shows:
libname dat oracle schema=dat_owner user=testuser pw=XXXXXXXX path=datdbp;
data lll;
set dat.disc_lll_v
(dbsliceparm=ALL
keep=day
hour
price
most_recent
where=(most_recent='Yes' and
day between '01JAN2006:00:00:00'dt and '30MAY2006:00:00:00'dt ));
run;
Read the case-study below...
