1007 %let iter = 500000;
1009 proc delete data=work._all_; run;
NOTE: Deleting "A.DATA" (memtype="DATA")
NOTE: Deleting "ALL.DATA" (memtype="DATA")
NOTE: Deleting "B.DATA" (memtype="DATA")
NOTE: Deleting "C.DATA" (memtype="DATA")
NOTE: Procedure delete step took :
real time : 00:00:00.000
cpu time : 00:00:00.000
1011 %MPExec;
NOTE: MPExec threading modules
initialised.
NOTE: Multi-threaded processing
commencing at: 10:07:59.45
=============================================================================
NOTE: Log file for Thread Number: 1
Thread Name: Job A
=============================================================================
1 The WPS System 10:07 Tuesday, June 02,
2009
NOTE: Copyright © 2002-2009 World
Programming Limited All rights reserved
NOTE: World Programming System 2.03
(02.03.05.12044)
Licensed to MineQuest
NOTE: AUTOEXEC processing beginning;
file is c:\Program Files (x86)\World
Programming WPS 2\autoexec.sas
NOTE: Library assigned as follows:
NOTE: Libref = WPS2R
Engine = WPD
Physical Name = c:\wps2r\macrolib
NOTE: Library assigned as follows:
NOTE: Libref = MPEXEC
Engine = WPD
Physical Name = c:\temp\macrolib
NOTE: AUTOEXEC processing completed
2 data a;
3 do ii=1 to 500000;
4 a=ranuni(0);
5 b=ranuni(0);
6 c=ranuni(0);
7 d=ranuni(0);
8 e=ranuni(0);
9 f=ranuni(0);
10 g=ranuni(0);
11 h=ranuni(0);
12 i=ranuni(0);
13 aa=round(c*10,1);
14 output;
15 end;
16 run;
NOTE: Data set "WORK.a" has 500000
observation(s) and 11 variable(s)
NOTE: The data step took :
real time : 00:00:06.006
cpu time : 00:00:00.936
19 proc means data=a;
20 run;
NOTE: 500000 observations were read from
"WORK.a"
NOTE: Procedure means step took :
real time : 00:00:02.558
cpu time : 00:00:00.764
22 Proc sort data=a; by ii; run;
NOTE: Data set "WORK.a" has 500000
observation(s) and 11 variable(s)
NOTE: Procedure sort step took :
real time : 00:00:00.998
2 The WPS System 10:07 Tuesday, June 02,
2009
cpu time : 00:00:00.358
25 Proc freq data=b;
26 tables ab;
27 Title 'Proc Freq Run for A';
28 run;
NOTE: 500000 observations were read from
"WORK.b"
NOTE: Procedure freq step took :
real time : 00:00:00.499
cpu time : 00:00:00.405
NOTE: Submitted statements took :
real time : 00:00:10.077
cpu time : 00:00:02.480
=============================================================================
NOTE: Log file for Thread Number: 2
Thread Name: Job B
=============================================================================
1 The WPS System 10:07 Tuesday, June 02,
2009
NOTE: Copyright © 2002-2009 World
Programming Limited All rights reserved
NOTE: World Programming System 2.03
(02.03.05.12044)
Licensed to MineQuest
NOTE: AUTOEXEC processing beginning;
file is c:\Program Files (x86)\World
Programming WPS 2\autoexec.sas
NOTE: Library assigned as follows:
NOTE: Libref = WPS2R
Engine = WPD
Physical Name = c:\wps2r\macrolib
NOTE: Library assigned as follows:
NOTE: Libref = MPEXEC
Engine = WPD
Physical Name = c:\temp\macrolib
NOTE: AUTOEXEC processing completed
2 data b;
3 do ii=1 to 500000;
4 j=ranuni(0);
5 k=ranuni(0);
6 l=ranuni(0);
7 m=ranuni(0);
8 n=ranuni(0);
9 o=ranuni(0);
10 p=ranuni(0);
11 q=ranuni(0);
12 r=ranuni(0);
13 ab=round(j*10,1);
14 output;
15 end;
16 run;
NOTE: Data set "WORK.b" has 500000
observation(s) and 11 variable(s)
NOTE: The data step took :
real time : 00:00:08.236
cpu time : 00:00:00.889
18 * this is a comment ;
19 title "This is a Means Title";
21 proc means data=b;
22 run;
NOTE: 500000 observations were read from
"WORK.b"
NOTE: Procedure means step took :
real time : 00:00:01.794
cpu time : 00:00:00.826
25 Proc freq data=b;
26 tables ab;
2 The WPS System 10:07 Tuesday, June 02,
2009
27 Title 'Proc Freq Run for B';
28 run;
NOTE: 500000 observations were read from
"WORK.b"
NOTE: Procedure freq step took :
real time : 00:00:00.405
cpu time : 00:00:00.405
30 Proc sort data=b; by ii; run;
NOTE: Data set "WORK.b" has 500000
observation(s) and 11 variable(s)
NOTE: Procedure sort step took :
real time : 00:00:00.405
cpu time : 00:00:00.374
NOTE: Submitted statements took :
real time : 00:00:10.873
cpu time : 00:00:02.511
=============================================================================
NOTE: Log file for Thread Number: 3
Thread Name: Job C
=============================================================================
1 The WPS System 10:07 Tuesday, June 02,
2009
NOTE: Copyright © 2002-2009 World
Programming Limited All rights reserved
NOTE: World Programming System 2.03
(02.03.05.12044)
Licensed to MineQuest
NOTE: AUTOEXEC processing beginning;
file is c:\Program Files (x86)\World
Programming WPS 2\autoexec.sas
NOTE: Library assigned as follows:
NOTE: Libref = WPS2R
Engine = WPD
Physical Name = c:\wps2r\macrolib
NOTE: Library assigned as follows:
NOTE: Libref = MPEXEC
Engine = WPD
Physical Name = c:\temp\macrolib
NOTE: AUTOEXEC processing completed
2 data c;
3 do ii=1 to 500000;
4 j=ranuni(0);
5 k=ranuni(0);
6 l=ranuni(0);
7 m=ranuni(0);
8 n=ranuni(0);
9 o=ranuni(0);
10 p=ranuni(0);
11 q=ranuni(0);
12 r=ranuni(0);
13 ab=round(j*10,1);
14 output;
15 end;
16 run;
NOTE: Data set "WORK.c" has 500000
observation(s) and 11 variable(s)
NOTE: The data step took :
real time : 00:00:04.758
cpu time : 00:00:00.858
18 * this is a comment ;
19 title "This is a Means Title";
21 proc means data=c;
22 run;
NOTE: 500000 observations were read from
"WORK.c"
NOTE: Procedure means step took :
real time : 00:00:03.556
cpu time : 00:00:00.592
25 Proc freq data=c;
26 tables ab;
2 The WPS System 10:07 Tuesday, June 02,
2009
27 Title 'Proc Freq Run for C';
28 run;
NOTE: 500000 observations were read from
"WORK.c"
NOTE: Procedure freq step took :
real time : 00:00:00.624
cpu time : 00:00:00.452
30 Proc sort data=b; by ii; run;
NOTE: Data set "WORK.b" has 500000
observation(s) and 11 variable(s)
ERROR: Failed to delete member "WORK.b"
(WORK.b may be open)
NOTE: Procedure sort step took :
real time : 00:00:00.842
cpu time : 00:00:00.436
NOTE: Submitted statements took :
real time : 00:00:09.781
cpu time : 00:00:02.340
=============================================================================
NOTE: Log file for Thread Number: 4
Thread Name: Corr Run 1
=============================================================================
1 The WPS System 10:07 Tuesday, June 02,
2009
NOTE: Copyright © 2002-2009 World
Programming Limited All rights reserved
NOTE: World Programming System 2.03
(02.03.05.12044)
Licensed to MineQuest
NOTE: AUTOEXEC processing beginning;
file is c:\Program Files (x86)\World
Programming WPS 2\autoexec.sas
NOTE: Library assigned as follows:
NOTE: Libref = WPS2R
Engine = WPD
Physical Name = c:\wps2r\macrolib
NOTE: Library assigned as follows:
NOTE: Libref = MPEXEC
Engine = WPD
Physical Name = c:\temp\macrolib
NOTE: AUTOEXEC processing completed
2 libname tstdata 'c:\wpstestdata\';
NOTE: Library assigned as follows:
NOTE: Libref = TSTDATA
Engine = WPD
Physical Name = c:\wpstestdata\
3 Proc univariate data=tstdata.d;
4 var j k l;
5 run;
NOTE: 200000 observations were read from
"TSTDATA.d"
NOTE: Procedure univariate step took :
real time : 00:00:03.291
cpu time : 00:00:02.355
7 Proc corr data=tstdata.d;
8 title "this is the second Proc Corr";
9 run;
NOTE: 200000 observations were read from
"TSTDATA.d"
NOTE: Procedure corr step took :
real time : 00:00:05.912
cpu time : 00:00:03.946
NOTE: Submitted statements took :
real time : 00:00:09.219
cpu time : 00:00:06.318
=============================================================================
NOTE: Log file for Thread Number: 5
Thread Name: Corr Run 2
=============================================================================
1 The WPS System 10:07 Tuesday, June 02,
2009
NOTE: Copyright © 2002-2009 World
Programming Limited All rights reserved
NOTE: World Programming System 2.03
(02.03.05.12044)
Licensed to MineQuest
NOTE: AUTOEXEC processing beginning;
file is c:\Program Files (x86)\World
Programming WPS 2\autoexec.sas
NOTE: Library assigned as follows:
NOTE: Libref = WPS2R
Engine = WPD
Physical Name = c:\wps2r\macrolib
NOTE: Library assigned as follows:
NOTE: Libref = MPEXEC
Engine = WPD
Physical Name = c:\temp\macrolib
NOTE: AUTOEXEC processing completed
2 libname tstdata 'c:\wpstestdata\';
NOTE: Library assigned as follows:
NOTE: Libref = TSTDATA
Engine = WPD
Physical Name = c:\wpstestdata\
3 Proc univariate data=tstdata.d;
5 var j k l;
6 run;
NOTE: 200000 observations were read from
"TSTDATA.d"
NOTE: Procedure univariate step took :
real time : 00:00:02.979
cpu time : 00:00:02.418
8 Proc corr data=tstdata.d;
10 title "this is the second Proc Corr";
11 run;
NOTE: 200000 observations were read from
"TSTDATA.d"
NOTE: Procedure corr step took :
real time : 00:00:04.680
cpu time : 00:00:04.056
NOTE: Submitted statements took :
real time : 00:00:07.675
cpu time : 00:00:06.489
=============================================================================
NOTE: Log file for Thread Number: 6
Thread Name: Corr Run 3
=============================================================================
1 The WPS System 10:07 Tuesday, June 02,
2009
NOTE: Copyright © 2002-2009 World
Programming Limited All rights reserved
NOTE: World Programming System 2.03
(02.03.05.12044)
Licensed to MineQuest
NOTE: AUTOEXEC processing beginning;
file is c:\Program Files (x86)\World
Programming WPS 2\autoexec.sas
NOTE: Library assigned as follows:
NOTE: Libref = WPS2R
Engine = WPD
Physical Name = c:\wps2r\macrolib
NOTE: Library assigned as follows:
NOTE: Libref = MPEXEC
Engine = WPD
Physical Name = c:\temp\macrolib
NOTE: AUTOEXEC processing completed
2 libname tstdata 'c:\wpstestdata\';
NOTE: Library assigned as follows:
NOTE: Libref = TSTDATA
Engine = WPD
Physical Name = c:\wpstestdata\
3 Proc univariate data=tstdata.d;
5 var j k l;
6 run;
NOTE: 200000 observations were read from
"TSTDATA.d"
NOTE: Procedure univariate step took :
real time : 00:00:03.010
cpu time : 00:00:02.215
8 Proc corr data=tstdata.d;
10 title "this is the second Proc Corr";
11 run;
NOTE: 200000 observations were read from
"TSTDATA.d"
NOTE: Procedure corr step took :
real time : 00:00:06.474
cpu time : 00:00:04.212
NOTE: Submitted statements took :
real time : 00:00:09.500
cpu time : 00:00:06.458
=============================================================================
NOTE: Log file for Thread Number: 7
Thread Name: Corr Run 4
=============================================================================
1 The WPS System 10:07 Tuesday, June 02,
2009
NOTE: Copyright © 2002-2009 World
Programming Limited All rights reserved
NOTE: World Programming System 2.03
(02.03.05.12044)
Licensed to MineQuest
NOTE: AUTOEXEC processing beginning;
file is c:\Program Files (x86)\World
Programming WPS 2\autoexec.sas
NOTE: Library assigned as follows:
NOTE: Libref = WPS2R
Engine = WPD
Physical Name = c:\wps2r\macrolib
NOTE: Library assigned as follows:
NOTE: Libref = MPEXEC
Engine = WPD
Physical Name = c:\temp\macrolib
NOTE: AUTOEXEC processing completed
2 libname tstdata 'c:\wpstestdata\';
NOTE: Library assigned as follows:
NOTE: Libref = TSTDATA
Engine = WPD
Physical Name = c:\wpstestdata\
3 Proc univariate data=tstdata.d;
5 var j k l;
6 run;
NOTE: 200000 observations were read from
"TSTDATA.d"
NOTE: Procedure univariate step took :
real time : 00:00:02.776
cpu time : 00:00:02.152
8 Proc corr data=tstdata.d;
10 title "this is the second Proc Corr";
11 run;
NOTE: 200000 observations were read from
"TSTDATA.d"
NOTE: Procedure corr step took :
real time : 00:00:04.617
cpu time : 00:00:04.087
NOTE: Submitted statements took :
real time : 00:00:07.425
cpu time : 00:00:06.240
=============================================================================
NOTE: Log file for Thread Number: 8
Thread Name: Corr Run 5
=============================================================================
1 The WPS System 10:07 Tuesday, June 02,
2009
NOTE: Copyright © 2002-2009 World
Programming Limited All rights reserved
NOTE: World Programming System 2.03
(02.03.05.12044)
Licensed to MineQuest
NOTE: AUTOEXEC processing beginning;
file is c:\Program Files (x86)\World
Programming WPS 2\autoexec.sas
NOTE: Library assigned as follows:
NOTE: Libref = WPS2R
Engine = WPD
Physical Name = c:\wps2r\macrolib
NOTE: Library assigned as follows:
NOTE: Libref = MPEXEC
Engine = WPD
Physical Name = c:\temp\macrolib
NOTE: AUTOEXEC processing completed
2 libname tstdata 'c:\wpstestdata\';
NOTE: Library assigned as follows:
NOTE: Libref = TSTDATA
Engine = WPD
Physical Name = c:\wpstestdata\
3 Proc univariate data=tstdata.d;
5 var j k l;
6 run;
NOTE: 200000 observations were read from
"TSTDATA.d"
NOTE: Procedure univariate step took :
real time : 00:00:04.414
cpu time : 00:00:02.012
8 Proc corr data=tstdata.d;
10 title "this is the second Proc Corr";
11 run;
NOTE: 200000 observations were read from
"TSTDATA.d"
NOTE: Procedure corr step took :
real time : 00:00:04.914
cpu time : 00:00:04.024
NOTE: Submitted statements took :
real time : 00:00:09.360
cpu time : 00:00:06.037
NOTE: Parallel Threading Completed. 8
Parallel Threads Were Executed.
NOTE: Thread Summary:
Start Time: 10:07:59.45 End Time:
10:08:10.61 Elapsed Time: 0:00:11.154 (hh:mm:ss:hs)
NOTE: Parallel Task Execution Detail (in
order of submission)
Thread 1 cpu time : 00:00:02.480 real
time : 00:00:10.077 Task ID: Job A
Thread 2 cpu time : 00:00:02.511 real
time : 00:00:10.873 Task ID: Job B
Thread 3 cpu time : 00:00:02.340 real
time : 00:00:09.781 Task ID: Job C
Thread 4 cpu time : 00:00:06.318 real
time : 00:00:09.219 Task ID: Corr Run 1
Thread 5 cpu time : 00:00:06.489 real
time : 00:00:07.675 Task ID: Corr Run 2
Thread 6 cpu time : 00:00:06.458 real
time : 00:00:09.500 Task ID: Corr Run 3
Thread 7 cpu time : 00:00:06.240 real
time : 00:00:07.425 Task ID: Corr Run 4
Thread 8 cpu time : 00:00:06.037 real
time : 00:00:09.360 Task ID: Corr Run 5
All thread totals : 0:00:38.873
0:01:13.910
NOTE: Calculated minumum threading
efficiency: 6.6x (0:01:13.910 /
0:00:11.154)
NOTE: MPEXEC copyright © 2009 by
MineQuest, LLC. and is licensed
software.
NOTE: MPEXEC v1.0 All rights reserved.
1212 *--> merge data sets created from
thread A and thread B together;
1213 Data all;
1214 merge a(in=in1)
1215 b(in=in2);
1216 by ii;
1217 run;
NOTE: 500000 observations were read from
"WORK.a"
NOTE: 500000 observations were read from
"WORK.b"
NOTE: Data set "WORK.all" has 500000
observation(s) and 21 variable(s)
NOTE: The data step took :
real time : 00:00:01.653
cpu time : 00:00:01.216