topic Examples for THREADED_APPS in SAS Programming

Examples for THREADED_APPS

klroesner — Sun, 04 May 2025 17:20:01 GMT

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

Re: Examples for THREADED_APPS

SASKiwi — Sun, 04 May 2025 22:23:42 GMT

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

Re: Examples for THREADED_APPS

klroesner — Mon, 05 May 2025 13:19:19 GMT

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

Re: Examples for THREADED_APPS

Tom — Mon, 05 May 2025 13:56:46 GMT

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.