Examples for THREADED_APPS

[klroesner]

Hello World,

The following page explains what Threaded Applications are: "SAS threaded applications are SAS procedures that thread input, output, and numeric operations".  Is there a list somewhere that shows what these proc steps are? I tested proc means and proc summary, but the option DBSLICEPARM=(THREADED_APPS, 2) has no effect.

Options That Affect Threaded Reads

[SASKiwi]

Are you running PROC MEANS directly against a DBMS table as the option only applies to external database tables?

[klroesner]

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

[Tom]

Not sure what PROC MEANS would need multiple remote database threads for in your example code.  It should be able to generate a single query to find all of the values.