Thanks. This is really helpful.

On Wed, 30 Jul 2008 09:30:02 -0400, T J <tj_noreply@YAHOO.COM> wrote:

>You definitely need multiple CPUs to take advantage of the multi-threading. >Here is some results from an 8-way unix box and an "old" 1 cpu - one-core >pc. Dual-core PC's should help, but I don't have one to test. > >=================unix box=============================== >33 options threads; >34 proc options option=cpucount; run; > > SAS (r) Proprietary Software Release 9.1 TS1M3 > > CPUCOUNT=8 Number of processors available. >NOTE: PROCEDURE OPTIONS used (Total process time): > real time 0.00 seconds > cpu time 0.00 seconds > > >35 proc options option=threads; run; > > SAS (r) Proprietary Software Release 9.1 TS1M3 > > THREADS Threads are available for use with features of the SAS >System that support threading >NOTE: PROCEDURE OPTIONS used (Total process time): > real time 0.00 seconds > cpu time 0.00 seconds > > >36 >37 data a; >38 do i =1 to 1e7; >39 x=ranuni(0); >40 y=ranuni(0); >41 output; >42 end; >43 run; > >NOTE: The data set WORK.A has 10000000 observations and 3 variables. >NOTE: DATA statement used (Total process time): > real time 8.95 seconds > cpu time 8.81 seconds > >44 >45 proc sort; by x y; run; > >NOTE: There were 10000000 observations read from the data set WORK.A. >NOTE: The data set WORK.A has 10000000 observations and 3 variables. >NOTE: PROCEDURE SORT used (Total process time): > real time 15.28 seconds > cpu time 32.91 seconds > > >46 >47 options nothreads; >48 proc options option=cpucount; run; > > SAS (r) Proprietary Software Release 9.1 TS1M3 > > CPUCOUNT=8 Number of processors available. >NOTE: PROCEDURE OPTIONS used (Total process time): > real time 0.01 seconds > cpu time 0.00 seconds > > >49 proc options option=threads; run; > > SAS (r) Proprietary Software Release 9.1 TS1M3 > > NOTHREADS Threads are not available for use with features of the >SAS System that support threading >NOTE: PROCEDURE OPTIONS used (Total process time): > real time 0.01 seconds > cpu time 0.00 seconds >50 >51 data a; >52 do i =1 to 1e7; >53 x=ranuni(0); >54 y=ranuni(0); >55 output; >56 end; >57 run; > >NOTE: The data set WORK.A has 10000000 observations and 3 variables. >NOTE: DATA statement used (Total process time): > real time 8.85 seconds > cpu time 8.76 seconds > > >58 >59 proc sort; by x y; run; > >NOTE: There were 10000000 observations read from the data set WORK.A. >NOTE: The data set WORK.A has 10000000 observations and 3 variables. >NOTE: PROCEDURE SORT used (Total process time): > real time 38.60 seconds > cpu time 38.34 seconds > >== PC: options Thread/NOTHREADS produces similar results ======== > CPUCOUNT=1 Number of processors available. > THREADS Threads are available for use with features of the SAS >System that support > threading >23 data a ; >24 do i =1 to 10e6; >25 x=ranuni(0); >26 y=ranuni(0); >27 output; >28 end; >29 run; > >NOTE: The data set WORK.A has 10000000 observations and 3 variables. >NOTE: DATA statement used (Total process time): > real time 11.80 seconds > cpu time 4.61 seconds > > >30 proc sort; by x y i; run; > >NOTE: There were 10000000 observations read from the data set WORK.A. >NOTE: The data set WORK.A has 10000000 observations and 3 variables. >NOTE: PROCEDURE SORT used (Total process time): > real time 3:19.84 > cpu time 20.85 seconds >===================================================================== > > >On Tue, 29 Jul 2008 17:06:50 -0700, Huang, Ya <Ya.Huang@AMYLIN.COM> wrote >in part: > >>Hi, >> >>Thanks to whoever responded to my previous post. Now I have a follow up >>question: Which procedures can take the maximum advantage of >>multi-threading, so that when it runs in v9.2 with support of multi- >>threading, its performance improves dramatically? >> >>I've tested proc sort with a large dataset, it doesn't seem to improve >>at all, though I did see in the log "threaded sort is used". >> >>My testing machine is a very old P4, not duo core. Does it make any >>difference? >> >>Thanks >> >>Ya >> >>