Yes, we use a database table directly...
Code
* Wie ist das aktuelle Setting der Option: DBSLICEPARM?;
proc options option=DBSLICEPARM;
run;
* Trace aktivieren;
options sastrace=",,t,d" sastraceloc=saslog nostsuffix;
* Threaded Proc Step;
proc means data=tutorial.threaded_reads;
output out=test;
run;
Log
SAS (r) Proprietary Software Release 9.4 TS1M8
DBSLICEPARM=(THREADED_APPS, 2)
Specifies whether SAS procedures, applications, and the DATA step can read DBMS tables in parallel, and the
number of threads to use to read the DBMS tables.
NOTE: PROCEDURE OPTIONS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
32
33 * Trace aktivieren;
34 options sastrace=",,t,d" sastraceloc=saslog nostsuffix;
35
36 * Threaded Proc Step;
SAPHANA_3: Prepared: on connection 0
SELECT * FROM UPM_TUTORIAL.THREADED_READS
37 proc means data=tutorial.threaded_reads;
38 output out=test;
39 run;
SAPHANA_4: Executed: on connection 0
2 The SAS System Montag, 5. Mai 2025 15:08:00
Prepared statement SAPHANA_3
NOTE: There were 20000000 observations read from the data set TUTORIAL.THREADED_READS.
NOTE: The data set WORK.TEST has 5 observations and 9 variables.
NOTE: Compressing data set WORK.TEST increased size by 100.00 percent.
Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: PROCEDURE MEANS used (Total process time):
real time 24.86 seconds
cpu time 22.28 seconds
... View more
