Multi-Threaded Reads in SAS/Access for Relational Databases

A Mutithreading case study with SAS that reads large amounts of data from Oracle databases. DBSLICEPARM option in SAS Access greatly improves the speed of reading data from Oracle...

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