1                                                          The SAS System                            15:50 Friday, November 21, 2008

NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead.

NOTE: All registry changes will be lost at the end of the session.

WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, you will not see registry customizations during this

         session.

NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.

NOTE: All profile changes will be lost at the end of the session.

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.

NOTE: SAS (r) Proprietary Software 9.2 (TS1M0)

      Licensed to ABT ASSOCIATES INC, Site<PHONE_NUMBER>.

NOTE: This session is executing on the X64_SRV  platform.

NOTE: SAS initialization used:

      real time           0.12 seconds

      cpu time            0.10 seconds

1          *Matthew LaPenta;

2          *Created 02.08.08;

3

4

5          *Modified 11.21.08 revised analysis;

6          *Modified 10.24.08 revised analysis;

7          *Modified 02.26.08 add average to output;

8          *Modified 02.22.08 add distributional information;

9          *Modified 02.21.08 increase number of samples;

10         *Modified 02.20.08 increase program efficiency;

11         *Modified 02.19.08 use revenue bracket-specific numbers of vessels;

12         *Modified 02.16.08 output naics-firm-specific distributions;

13         *Modified 02.15.08 output naics-firm-specific distributions;

14         *Modified 02.12.08 output naics-specific distributions;

15         *Modified 02.11.08 (developing program);

16         *Description

17         	There are 15 low-cost and 19 high-cost practices required of vessels subject to the discharge rule.

18         		For each individual practice there is a probability that an incremental cost is incurred under a

19         		rule scenario.  This program calculates the probability that incremental costs are incurred for each

20         		possible combination of practices (assuming that the probability of incurring incremental costs is

21         		independent across practices).  Data are exported to excel that show, for each vessel type,

22         		the practice combination, the number of vessels for the practice combination, the probability of

23         		a practice combination, the per-vessel cost of a practice combination, and the total costs associated

24         		with a practice combination;

25         *Drive (c or h);

26         	%let d=h;

27         *File Location;

28         	%let mainloc=H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\;

29         	%let inloc=&mainloc.Inputs\;

30         	%let outloc=&mainloc.Outputs\;

31

32         	*Inputs;

33         %let input=&inloc.Distribution Analysis Inputs NEW;

34         *Outputs;

35         %let samp=11;

36         %let output=&outloc.DAO&samp._;

2                                                          The SAS System                            15:50 Friday, November 21, 2008

37         %let output2=&outloc.Dist&samp._;

38         *let output3=&outloc.Dist&samp._;

39

40         libname temp "&mainloc.Temp";

NOTE: Libref TEMP was successfully assigned as follows:

      Engine:        V9

      Physical Name: H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Temp

41         libname temp2 "&mainloc.Temp\temp2";

NOTE: Libref TEMP2 was successfully assigned as follows:

      Engine:        V9

      Physical Name: H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Temp\temp2

42         libname temp3 "&mainloc.Temp\temp3";

NOTE: Libref TEMP3 was successfully assigned as follows:

      Engine:        V9

      Physical Name: H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Temp\temp3

43         libname temp4 "&mainloc.Temp\temp4";

NOTE: Libref TEMP4 was successfully assigned as follows:

      Engine:        V9

      Physical Name: H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Temp\temp4

44

45         PROC DATASETS LIBRARY=temp   MEMTYPE=DATA    KILL nolist;

46         QUIT;

NOTE: PROCEDURE DATASETS used (Total process time):

      real time           0.04 seconds

      cpu time            0.03 seconds

47         PROC DATASETS LIBRARY=temp2   MEMTYPE=DATA    KILL nolist;

NOTE: Deleting TEMP2.N4 (memtype=DATA).

NOTE: Deleting TEMP2.NUM (memtype=DATA).

NOTE: Deleting TEMP2.TH2 (memtype=DATA).

48         QUIT;

NOTE: PROCEDURE DATASETS used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

49         PROC DATASETS LIBRARY=temp3   MEMTYPE=DATA    KILL nolist;

50         QUIT;

NOTE: PROCEDURE DATASETS used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

51         PROC DATASETS LIBRARY=temp4   MEMTYPE=DATA    KILL nolist;

52         QUIT;

NOTE: PROCEDURE DATASETS used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

3                                                          The SAS System                            15:50 Friday, November 21, 2008

53         PROC DATASETS LIBRARY=work   MEMTYPE=DATA    KILL nolist;

54         QUIT;

NOTE: PROCEDURE DATASETS used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

55         *Begin Program;

56

57         *This Macro is used to Import data from excel;

58         %macro import(infile,sheet,out);

59         PROC IMPORT OUT= WORK.&out

60                     DATAFILE= "&infile. &sheet."

61                     DBMS=CSV REPLACE;

62              GETNAMES=YES;

63              DATAROW=2;

64         RUN;

65         %mend;

66         *This Macro is used to Export data to excel;

67         %macro export(datafile,outfile,sheet);

68

69         PROC EXPORT DATA= &datafile.

70                     OUTFILE= "&outfile.&sheet."

71                     DBMS=CSV REPLACE;

72              PUTNAMES=YES;

73         RUN;

74

75         %mend;

76

77         %import(&input, naicsnum.csv,num);

78          /**********************************************************************

79          *   PRODUCT:   SAS

80          *   VERSION:   9.2

81          *   CREATOR:   External File Interface

82          *   DATE:      21NOV08

83          *   DESC:      Generated SAS Datastep Code

84          *   TEMPLATE SOURCE:  (None Specified.)

85          ***********************************************************************/

86             data WORK.NUM                                     ;

87             %let _EFIERR_ = 0; /* set the ERROR detection macro variable */

88             infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW naicsnum.csv'

88       ! delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;

89                informat NAICS $16. ;

90                informat m1 best32. ;

91                informat m2 best32. ;

92                informat m3 best32. ;

93                informat m4 best32. ;

94                informat m5 best32. ;

95                informat m6 best32. ;

96                informat m7 best32. ;

97                informat m8 best32. ;

4                                                          The SAS System                            15:50 Friday, November 21, 2008

98                informat m9 best32. ;

99                informat m10 best32. ;

100               informat m11 best32. ;

101               format NAICS $16. ;

102               format m1 best12. ;

103               format m2 best12. ;

104               format m3 best12. ;

105               format m4 best12. ;

106               format m5 best12. ;

107               format m6 best12. ;

108               format m7 best12. ;

109               format m8 best12. ;

110               format m9 best12. ;

111               format m10 best12. ;

112               format m11 best12. ;

113            input

114                        NAICS $

115                        m1

116                        m2

117                        m3

118                        m4

119                        m5

120                        m6

121                        m7

122                        m8

123                        m9

124                        m10

125                        m11

126            ;

127            if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */

128            run;

NOTE: The infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW naicsnum.csv' is:

      Filename=H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW naicsnum.csv,

      RECFM=V,LRECL=32767,File Size (bytes)=1189,

      Last Modified=21Nov2008:14:34:40,

      Create Time=21Nov2008:14:34:38

NOTE: 11 records were read from the infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs

      NEW naicsnum.csv'.

      The minimum record length was 85.

      The maximum record length was 118.

NOTE: The data set WORK.NUM has 11 observations and 12 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

11 rows created in WORK.NUM                                  from H:\Projects\Tyche_Option_1_Task_1-04\SAS

Analysis\Inputs\Distribution Analysis Inputs NEW naicsnum.csv.

NOTE: WORK.NUM data set was successfully created.

5                                                          The SAS System                            15:50 Friday, November 21, 2008

NOTE: PROCEDURE IMPORT used (Total process time):

      real time           0.12 seconds

      cpu time            0.10 seconds

129        data temp2.num;

130        	set num;

131        run;

NOTE: There were 11 observations read from the data set WORK.NUM.

NOTE: The data set TEMP2.NUM has 11 observations and 12 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

132

133        *	1	get thresholds data;

134        %import(&input, NAICSthresh.csv,th1);

135         /**********************************************************************

136         *   PRODUCT:   SAS

137         *   VERSION:   9.2

138         *   CREATOR:   External File Interface

139         *   DATE:      21NOV08

140         *   DESC:      Generated SAS Datastep Code

141         *   TEMPLATE SOURCE:  (None Specified.)

142         ***********************************************************************/

143            data WORK.TH1                                     ;

144            %let _EFIERR_ = 0; /* set the ERROR detection macro variable */

145            infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW NAICSthresh.csv'

145      ! delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;

146               informat NAICS $16. ;

147               informat A1 best32. ;

148               informat A2 best32. ;

149               informat A3 best32. ;

150               informat A4 best32. ;

151               informat A5 best32. ;

152               informat A6 best32. ;

153               informat A7 best32. ;

154               informat A8 best32. ;

155               informat A9 best32. ;

156               informat A10 best32. ;

157               informat A11 best32. ;

158               informat RR1 best32. ;

159               informat RR2 best32. ;

160               informat RR3 best32. ;

161               informat RR4 best32. ;

162               informat RR5 best32. ;

163               informat RR6 best32. ;

164               informat RR7 best32. ;

165               informat RR8 best32. ;

166               informat RR9 best32. ;

167               informat RR10 best32. ;

6                                                          The SAS System                            15:50 Friday, November 21, 2008

168               informat RR11 best32. ;

169               informat L1 best32. ;

170               informat L2 best32. ;

171               informat L3 best32. ;

172               informat L4 best32. ;

173               informat L5 best32. ;

174               informat L6 best32. ;

175               informat L7 best32. ;

176               informat L8 best32. ;

177               informat L9 best32. ;

178               informat L10 best32. ;

179               informat L11 best32. ;

180               informat H1 best32. ;

181               informat H2 best32. ;

182               informat H3 best32. ;

183               informat H4 best32. ;

184               informat H5 best32. ;

185               informat H6 best32. ;

186               informat H7 best32. ;

187               informat H8 best32. ;

188               informat H9 best32. ;

189               informat H10 best32. ;

190               informat H11 best32. ;

191               format NAICS $16. ;

192               format A1 best12. ;

193               format A2 best12. ;

194               format A3 best12. ;

195               format A4 best12. ;

196               format A5 best12. ;

197               format A6 best12. ;

198               format A7 best12. ;

199               format A8 best12. ;

200               format A9 best12. ;

201               format A10 best12. ;

202               format A11 best12. ;

203               format RR1 best12. ;

204               format RR2 best12. ;

205               format RR3 best12. ;

206               format RR4 best12. ;

207               format RR5 best12. ;

208               format RR6 best12. ;

209               format RR7 best12. ;

210               format RR8 best12. ;

211               format RR9 best12. ;

212               format RR10 best12. ;

213               format RR11 best12. ;

214               format L1 best12. ;

215               format L2 best12. ;

216               format L3 best12. ;

217               format L4 best12. ;

218               format L5 best12. ;

219               format L6 best12. ;

220               format L7 best12. ;

221               format L8 best12. ;

7                                                          The SAS System                            15:50 Friday, November 21, 2008

222               format L9 best12. ;

223               format L10 best12. ;

224               format L11 best12. ;

225               format H1 best12. ;

226               format H2 best12. ;

227               format H3 best12. ;

228               format H4 best12. ;

229               format H5 best12. ;

230               format H6 best12. ;

231               format H7 best12. ;

232               format H8 best12. ;

233               format H9 best12. ;

234               format H10 best12. ;

235               format H11 best12. ;

236            input

237                        NAICS $

238                        A1

239                        A2

240                        A3

241                        A4

242                        A5

243                        A6

244                        A7

245                        A8

246                        A9

247                        A10

248                        A11

249                        RR1

250                        RR2

251                        RR3

252                        RR4

253                        RR5

254                        RR6

255                        RR7

256                        RR8

257                        RR9

258                        RR10

259                        RR11

260                        L1

261                        L2

262                        L3

263                        L4

264                        L5

265                        L6

266                        L7

267                        L8

268                        L9

269                        L10

270                        L11

271                        H1

272                        H2

273                        H3

274                        H4

275                        H5

8                                                          The SAS System                            15:50 Friday, November 21, 2008

276                        H6

277                        H7

278                        H8

279                        H9

280                        H10

281                        H11

282            ;

283            if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */

284            run;

NOTE: The infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW NAICSthresh.csv' is:

      Filename=H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW NAICSthresh.csv,

      RECFM=V,LRECL=32767,File Size (bytes)=3603,

      Last Modified=21Nov2008:15:42:06,

      Create Time=21Nov2008:14:34:27

NOTE: 11 records were read from the infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs

      NEW NAICSthresh.csv'.

      The minimum record length was 242.

      The maximum record length was 338.

NOTE: The data set WORK.TH1 has 11 observations and 45 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

11 rows created in WORK.TH1                                  from H:\Projects\Tyche_Option_1_Task_1-04\SAS

Analysis\Inputs\Distribution Analysis Inputs NEW NAICSthresh.csv.

NOTE: WORK.TH1 data set was successfully created.

NOTE: PROCEDURE IMPORT used (Total process time):

      real time           0.07 seconds

      cpu time            0.07 seconds

285        data TEMP2.th2 (keep= NAICS O1-O11 T1-T11);

286        	set th1 (keep=NAICS A1-A11);

287        		array A(11) A1-A11;

288        		array O(11) O1-O11;

289        		array T(11) T1-T11;

290        			do i=1 to 11;

291        				if A(i)>0 then do;

292        					O(i)=.01*A(i);

293        					T(i)=.03*A(i);

294        				end;

295        			end;

296        run;

NOTE: There were 11 observations read from the data set WORK.TH1.

NOTE: The data set TEMP2.TH2 has 11 observations and 23 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

9                                                          The SAS System                            15:50 Friday, November 21, 2008

      cpu time            0.00 seconds

297

298        *	2a	Get percentages of vessel types for NAICS (Import);

299        %import(&input, NAICSWEIGHTS.csv,n1);

300         /**********************************************************************

301         *   PRODUCT:   SAS

302         *   VERSION:   9.2

303         *   CREATOR:   External File Interface

304         *   DATE:      21NOV08

305         *   DESC:      Generated SAS Datastep Code

306         *   TEMPLATE SOURCE:  (None Specified.)

307         ***********************************************************************/

308            data WORK.N1                                      ;

309            %let _EFIERR_ = 0; /* set the ERROR detection macro variable */

310            infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW NAICSWEIGHTS.csv'

310      ! delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;

311               informat Class $22. ;

312               informat Number best32. ;

313               informat NAICS $16. ;

314               format Class $22. ;

315               format Number best12. ;

316               format NAICS $16. ;

317            input

318                        Class $

319                        Number

320                        NAICS $

321            ;

322            if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */

323            run;

NOTE: The infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW NAICSWEIGHTS.csv' is:

      Filename=H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW NAICSWEIGHTS.csv,

      RECFM=V,LRECL=32767,File Size (bytes)=2710,

      Last Modified=21Nov2008:14:34:00,

      Create Time=21Nov2008:14:33:28

NOTE: 100 records were read from the infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs

      NEW NAICSWEIGHTS.csv'.

      The minimum record length was 18.

      The maximum record length was 36.

NOTE: The data set WORK.N1 has 100 observations and 3 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

100 rows created in WORK.N1                                   from H:\Projects\Tyche_Option_1_Task_1-04\SAS

Analysis\Inputs\Distribution Analysis Inputs NEW NAICSWEIGHTS.csv.

10                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: WORK.N1 data set was successfully created.

NOTE: PROCEDURE IMPORT used (Total process time):

      real time           0.04 seconds

      cpu time            0.04 seconds

324

325        *	2b	Get percentages of vessel types for NAICS (drop unneded vars);

326        data n2;

327        	set n1;

328        		if class="Dummy" then delete;

329        run;

NOTE: There were 100 observations read from the data set WORK.N1.

NOTE: The data set WORK.N2 has 99 observations and 3 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

330

331        *	2c	Get percentages of vessel types for NAICS (Get total number of vessels by NAICS);

332        proc sql;

333        	create table n3 as select

334        		n2.*,

335        		number/sum(number) as percent

336        	from n2 group by NAICS order by NAICS,Class;

NOTE: The query requires remerging summary statistics back with the original data.

NOTE: Table WORK.N3 created, with 99 rows and 4 columns.

337        quit;

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

338

339        *	2d	Get percentages of vessel types for NAICS (Get percentage for each vessel type);

340        %macro boat2(class,short,ini);

341        data x_&ini. (keep=NAICS &ini._percent);

342        	set n3;

343        		if Class="&class";

344        		rename percent=&ini._percent;

345        run;

346        %mend;

347        %boat2(Cruise Ships,Cruise,cs);

NOTE: There were 99 observations read from the data set WORK.N3.

NOTE: The data set WORK.X_CS has 11 observations and 2 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

11                                                         The SAS System                            15:50 Friday, November 21, 2008

348        %boat2(Commercial Fishing,Comm,cf);

NOTE: There were 99 observations read from the data set WORK.N3.

NOTE: The data set WORK.X_CF has 11 observations and 2 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

349        %boat2(Freight Barges,FBarge,fb);

NOTE: There were 99 observations read from the data set WORK.N3.

NOTE: The data set WORK.X_FB has 11 observations and 2 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

350        %boat2(Freight Ships,FShips,fs);

NOTE: There were 99 observations read from the data set WORK.N3.

NOTE: The data set WORK.X_FS has 11 observations and 2 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

351        %boat2(Passenger Vessels,Pass,pv);

NOTE: There were 99 observations read from the data set WORK.N3.

NOTE: The data set WORK.X_PV has 11 observations and 2 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

352        %boat2(Recreational Ships,Rec,rs);

NOTE: There were 99 observations read from the data set WORK.N3.

NOTE: The data set WORK.X_RS has 11 observations and 2 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

353        %boat2(Tank Barges,TBarge,tb);

NOTE: There were 99 observations read from the data set WORK.N3.

NOTE: The data set WORK.X_TB has 11 observations and 2 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

12                                                         The SAS System                            15:50 Friday, November 21, 2008

354        %boat2(Tank Ships,TShips,ts);

NOTE: There were 99 observations read from the data set WORK.N3.

NOTE: The data set WORK.X_TS has 11 observations and 2 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

355        %boat2(Utility Vessels,Utility,ut);

NOTE: There were 99 observations read from the data set WORK.N3.

NOTE: The data set WORK.X_UT has 11 observations and 2 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

356        *	2c	Get percentages of vessel types for NAICS (Combine data);

357        data TEMP2.n4;

358        	merge x_cs x_cf x_fb x_fs x_pv x_rs x_tb x_ts x_ut;

359        	by NAICS;

360        run;

NOTE: There were 11 observations read from the data set WORK.X_CS.

NOTE: There were 11 observations read from the data set WORK.X_CF.

NOTE: There were 11 observations read from the data set WORK.X_FB.

NOTE: There were 11 observations read from the data set WORK.X_FS.

NOTE: There were 11 observations read from the data set WORK.X_PV.

NOTE: There were 11 observations read from the data set WORK.X_RS.

NOTE: There were 11 observations read from the data set WORK.X_TB.

NOTE: There were 11 observations read from the data set WORK.X_TS.

NOTE: There were 11 observations read from the data set WORK.X_UT.

NOTE: The data set TEMP2.N4 has 11 observations and 10 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

361

362

363        *3	Import data from Excel;

364        %import(&input, infile.csv,d1);

Number of names found is less than number of variables found.

Number of names found is less than number of variables found.

365         /**********************************************************************

366         *   PRODUCT:   SAS

367         *   VERSION:   9.2

368         *   CREATOR:   External File Interface

369         *   DATE:      21NOV08

370         *   DESC:      Generated SAS Datastep Code

371         *   TEMPLATE SOURCE:  (None Specified.)

372         ***********************************************************************/

13                                                         The SAS System                            15:50 Friday, November 21, 2008

373            data WORK.D1                                      ;

374            %let _EFIERR_ = 0; /* set the ERROR detection macro variable */

375            infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW infile.csv'

375      ! delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;

376               informat Estimate $1. ;

377               informat Practice best32. ;

378               informat Class $20. ;

379               informat Count best32. ;

380               informat Percent best32. ;

381               informat Cost best32. ;

382               informat VAR7 $1. ;

383               informat VAR8 $1. ;

384               format Estimate $1. ;

385               format Practice best12. ;

386               format Class $20. ;

387               format Count best12. ;

388               format Percent best12. ;

389               format Cost best12. ;

390               format VAR7 $1. ;

391               format VAR8 $1. ;

392            input

393                        Estimate $

394                        Practice

395                        Class $

396                        Count

397                        Percent

398                        Cost

399                        VAR7 $

400                        VAR8 $

401            ;

402            if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */

403            run;

NOTE: The infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW infile.csv' is:

      Filename=H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs NEW infile.csv,

      RECFM=V,LRECL=32767,File Size (bytes)=11571,

      Last Modified=21Nov2008:14:32:11,

      Create Time=21Nov2008:14:32:07

NOTE: 333 records were read from the infile 'H:\Projects\Tyche_Option_1_Task_1-04\SAS Analysis\Inputs\Distribution Analysis Inputs

      NEW infile.csv'.

      The minimum record length was 21.

      The maximum record length was 51.

NOTE: The data set WORK.D1 has 333 observations and 8 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

333 rows created in WORK.D1                                   from H:\Projects\Tyche_Option_1_Task_1-04\SAS

Analysis\Inputs\Distribution Analysis Inputs NEW infile.csv.

14                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: WORK.D1 data set was successfully created.

NOTE: PROCEDURE IMPORT used (Total process time):

      real time           0.04 seconds

      cpu time            0.04 seconds

404

405

406        *This macro generates the exact distribution of costs for the various vessel types;

407        %macro boat(class,short,ini);

408

409        *4	Get data for a vessel type defined by macro variable;

410        data d2;

411        	set d1;

412        		if Class="&class";

413        run;

414

415        *5	Redefine the vessel count and the percentage variable, so the vessell count is the same for all practices

416        		and the percentage is the percentage of all vessels that will incur the costs;

417        proc sql;

418        	create table d3 as select

419        		d2.*,

420        		max(count) as maxcount,

421        		count/max(count)*percent as newpercent

422        	from d2;

423        quit;

424

425        *6 generate a data set for each practice type and format the data set

426        		Practice_X 	=1 when practice X is used and =0 OTW

427        		Count_X    	=Number of Vessels of type &class

428        		percent_X	=Probability of a sceanio

429        		cost_X		=is the cost of practice X under a scenario (zero when Practice_X 	=0)

430        			;

431        %macro divide(est,top);

432        	%do i=1 %to ⊤

433        		data x1;

434        			set d3;

435        				if estimate="&est" and practice=&i;

436        				practice_&i		=1;

437        				count_&i		=maxcount;

438        				percent_&i		=newpercent;

439        				cost_&i			=cost;

440        		run;

441        		data x2;

442        			set d3;

443        				if estimate="&est" and practice=&i;

444        				practice_&i		=0;

445        				count_&i		=maxcount;

446        				percent_&i		=1-newpercent;

447        				cost_&i			=0;

448        		run;

449        		data &est.&i (keep=practice_&i count_&i percent_&i cost_&i);

450        			set x1 x2;

451        				if percent_&i~=0;

15                                                         The SAS System                            15:50 Friday, November 21, 2008

452        		run;

453        	%end;

454        %mend;

455        %divide(H,21); *there are 21 high cost practices;

456        %divide(L,16); *there are 16 low cost practices;

457

458        *7	Initialize first data set for cartesian product joins;

459        data HH1;

460        	set h1;

461        run;

462        data LL1;

463        	set L1;

464        run;

465

466        *8	This macro performs a series of cartesian product joins of the practice-specific data sets.

467        		A cartesian product join generates all possible combinations between two datasets;

468        %macro cartesian(l,h);

469        proc sql;

470        	create table HH&h as select

471        		hh&l..*,h&h..*

472        	from hh&l.,h&h.;

473        quit;

474        proc sql;

475        	create table LL&h as select

476        		LL&l..*,l&h..*

477        	from LL&l.,l&h.;

478        quit;

479        %mend;

480        %cartesian(1,2);

481        %cartesian(2,3);

482        %cartesian(3,4);

483        %cartesian(4,5);

484        %cartesian(5,6);

485        %cartesian(6,7);

486        %cartesian(7,8);

487        %cartesian(8,9);

488        %cartesian(9,10);

489        %cartesian(10,11);

490        %cartesian(11,12);

491        %cartesian(12,13);

492        %cartesian(13,14);

493        %cartesian(14,15);

494        %cartesian(15,16)

495        *9	This macro performs a series of cartesian product joins of the High Cost practice-specific data sets.

496        		A cartesian product join generates all possible combinations between two datasets;

497        %macro cartesian2(l,h);

498        proc sql;

499        	create table HH&h as select

500        		hh&l..*,h&h..*

501        	from hh&l.,h&h.;

502        quit;

503        %mend;

504        %cartesian2(16,17);

505        %cartesian2(17,18);

16                                                         The SAS System                            15:50 Friday, November 21, 2008

506        %cartesian2(18,19);

507        %cartesian2(19,20);

508        %cartesian2(20,21);

509

510        *10	(for high cost estimates) Calculate probability of each practice combination.

511        		Calculate Number of Vessels affected under each practice combination.

512        		Calculate per-vessel and total cost of each practice combination.

513        		Drop combinations that are not observed.;

514        data d4 (compress=yes drop=count_1-count_21);

515        	set hh21;

516        		&ini.probability=percent_1*

517        					percent_2*

518        					percent_3*

519        					percent_4*

520        					percent_5*

521        					percent_6*

522        					percent_7*

523        					percent_8*

524        					percent_9*

525        					percent_10*

526        					percent_11*

527        					percent_12*

528        					percent_13*

529        					percent_14*

530        					percent_15*

531        					percent_16*

532        					percent_17*

533        					percent_18*

534        					percent_19*

535        					percent_20*

536        					percent_21;

537        		if &ini.probability~=0;

538        		&ini.count=count_1*probability;

539        		&ini.cost=sum(of cost_1-cost_21);

540        		&ini.totalcost=cost*count;

541        run;

542

543        *11	Format dataset;

544        data High&short (drop=practice_1-practice_21 i &ini.count &ini.TotalCost Class compress=yes);

545        	retain Class practice_1-practice_21;* probability count cost TotalCost;

546        	set d4 (keep = practice_1-practice_21 &ini.probability &ini.count &ini.cost &ini.TotalCost);

547        	format class $40.;

548        	Class="&Class";

549        		array p(21) practice_1-practice_21;

550        		array ne(21) &ini._1-&ini._21;

551        			do i=1 to 21;

552        				ne(i)=p(i);

553        			end;

554        run;

555

556        *12	(for Low cost estimates) Calculate probability of each practice combination.

557        		Calculate Number of Vessels affected under each practice combination.

558        		Calculate per-vessel and total cost of each practice combination.

559        		Drop combinations that are not observed.;

17                                                         The SAS System                            15:50 Friday, November 21, 2008

560        data d5 (compress=yes drop=count_1-count_16);

561        	set LL16;

562        		&ini.probability=percent_1*

563        					percent_2*

564        					percent_3*

565        					percent_4*

566        					percent_5*

567        					percent_6*

568        					percent_7*

569        					percent_8*

570        					percent_9*

571        					percent_10*

572        					percent_11*

573        					percent_12*

574        					percent_13*

575        					percent_14*

576        					percent_15*

577        					percent_16

578        ;

579        		if &ini.probability~=0;

580        		&ini.count=count_1*&ini.probability;

581        		&ini.cost=sum(of cost_1-cost_16);

582        		&ini.totalcost=&ini.cost*count;

583        run;

584

585        *13	Format dataset;

586        data Low&short (drop=practice_1-practice_16 i &ini.count &ini.TotalCost Class compress=yes);

587        	retain practice_1_practice_16;* probability count cost TotalCost;

588        	set d5 (keep = practice_1-practice_16 &ini.probability &ini.count &ini.cost &ini.TotalCost);

589        		array p(16) practice_1-practice_16;

590        		array ne(16) &ini._1-&ini._16;

591        			do i=1 to 16;

592        				ne(i)=p(i);

593        			end;

594        	format class $40.;

595        	Class="&Class";

596        run;

597

598        *14 Sort by per-vessel cost;

599        proc sort data=Low&short; by &ini.cost; run;

600        proc sort data=High&short; by &ini.cost; run;

601

602        *15 Export Data to Excel;

603        *%export(Low&short,"&output.",Low&short);

604        *%export(High&short,"&output.",High&short);

605

606        *ADD DOCUMENTATION!!;

607        %macro percentiles(ty);

608

609        proc univariate data=&ty.&short. noprint;

610        			weight &ini.probability;

611        			output out=&ty.&short.1 PCTLPRE=&ini.C_

612        				PCTLPTS= 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95

613        				Min=&ini.C_0 Max=&ini.C_100;

18                                                         The SAS System                            15:50 Friday, November 21, 2008

614        			var &ini.Cost;

615        run;

616

617        proc transpose data=&ty.&short.1 out=&ty.&short.2 prefix=&ini.C_ ;

618        	var &ini.C_0 &ini.C_5 &ini.C_10 &ini.C_15 &ini.C_20 &ini.C_25 &ini.C_30 &ini.C_35

619        		&ini.C_40 &ini.C_45 &ini.C_50 &ini.C_55 &ini.C_60 &ini.C_65 &ini.C_70 &ini.C_75 &ini.C_80 &ini.C_85 &ini.C_90 &ini.C_95

619      !  &ini.C_100;

620        run;

621        data temp3.&ty.&short.3 (keep=&ini._Cost compress=Yes);

622        	set &ty.&short.2;

623        		rename &ini.C_1=&ini._Cost;

624        *3;*		if 		_n_=1 | _n_=11 | _n_=21;

625        *6;*		if 		_n_=1 | _n_=5 | _n_=9 | _n_=13 | _n_=17 | _n_=21;

626        *11;		if 		_n_=1 | _n_=5 | _n_=9 | _n_=13 | _n_=17 | _n_=21 | 	_n_=3 | _n_=7 | _n_=11 | _n_=15 | _n_=19;

627        run;

628        /*

629        proc univariate data=&ty.&short. noprint;

630        			weight &ini.probability;

631        			output out=&ty.&short.1 PCTLPRE=&ini.C_

632        				PCTLPTS= 	2 4 6 8 10 12 14 16 18

633        							20 22 24 26 28

634        							30 32 34 36 38

635        							40 42 44 46 48

636        							50 52 54 56 58

637        							60 62 64 66 68

638        							70 72 74 76 78

639        							80 82 84 86 88

640        							90 92 94 96 98

641         				Min=&ini.C_0 Max=&ini.C_100;

642        			var &ini.Cost;

643        run;

644        proc transpose data=&ty.&short.1 out=&ty.&short.2 prefix=&ini.C_ ;

645        	var

646        &ini.C_0  &ini.C_2  &ini.C_4  &ini.C_6  &ini.C_8

647        &ini.C_10 &ini.C_12 &ini.C_14 &ini.C_16 &ini.C_18

648        &ini.C_20 &ini.C_22 &ini.C_24 &ini.C_26 &ini.C_28

649        &ini.C_30 &ini.C_32 &ini.C_34 &ini.C_36 &ini.C_38

650        &ini.C_40 &ini.C_42 &ini.C_44 &ini.C_46 &ini.C_48

651        &ini.C_50 &ini.C_52 &ini.C_54 &ini.C_56 &ini.C_58

652        &ini.C_60 &ini.C_62 &ini.C_64 &ini.C_66 &ini.C_68

653        &ini.C_70 &ini.C_72 &ini.C_74 &ini.C_76 &ini.C_78

654        &ini.C_80 &ini.C_82 &ini.C_84 &ini.C_86 &ini.C_88

655        &ini.C_90 &ini.C_92 &ini.C_94 &ini.C_96 &ini.C_98 &ini.C_100;

656        run;

657        data temp3.&ty.&short.3 (keep=&ini._Cost compress=Yes);

658        	set &ty.&short.2;

659        		rename &ini.C_1=&ini._Cost;

660        		*if 		_n_=1 | _n_=5 | _n_=9 | _n_=13 | _n_=17 | _n_=21

661        			| 	_n_=3 | _n_=7 | _n_=11 | _n_=15 | _n_=19;

662        run;

663        */

664        %mend;

665        %percentiles(Low);

666        %percentiles(High);

19                                                         The SAS System                            15:50 Friday, November 21, 2008

667        %mend;

668        %boat(Cruise Ships,Cruise,cs);

NOTE: There were 333 observations read from the data set WORK.D1.

NOTE: The data set WORK.D2 has 37 observations and 8 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: The query requires remerging summary statistics back with the original data.

NOTE: Table WORK.D3 created, with 37 rows and 10 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H1 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

20                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H2 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H3 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

21                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H4 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H5 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

22                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: The data set WORK.H6 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H7 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H8 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

23                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H9 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H10 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

24                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H11 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H12 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

25                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H13 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H14 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

26                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H15 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H16 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

27                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H17 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H18 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

28                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H19 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H20 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H21 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

29                                                         The SAS System                            15:50 Friday, November 21, 2008

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L1 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L2 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

30                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L3 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L4 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

31                                                         The SAS System                            15:50 Friday, November 21, 2008

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L5 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L6 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

32                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L7 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L8 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

33                                                         The SAS System                            15:50 Friday, November 21, 2008

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L9 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L10 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

34                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L11 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L12 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L13 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

35                                                         The SAS System                            15:50 Friday, November 21, 2008

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L14 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L15 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

36                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L16 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.H1.

NOTE: The data set WORK.HH1 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.L1.

NOTE: The data set WORK.LL1 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH2 created, with 1 rows and 8 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL2 created, with 1 rows and 8 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

37                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH3 created, with 1 rows and 12 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL3 created, with 1 rows and 12 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH4 created, with 1 rows and 16 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL4 created, with 1 rows and 16 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH5 created, with 1 rows and 20 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL5 created, with 1 rows and 20 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH6 created, with 1 rows and 24 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

38                                                         The SAS System                            15:50 Friday, November 21, 2008

      cpu time            0.01 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL6 created, with 1 rows and 24 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH7 created, with 1 rows and 28 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL7 created, with 1 rows and 28 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH8 created, with 1 rows and 32 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL8 created, with 1 rows and 32 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH9 created, with 2 rows and 36 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL9 created, with 2 rows and 36 columns.

39                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH10 created, with 2 rows and 40 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL10 created, with 2 rows and 40 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH11 created, with 2 rows and 44 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL11 created, with 2 rows and 44 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH12 created, with 2 rows and 48 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL12 created, with 2 rows and 48 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

40                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: Table WORK.HH13 created, with 2 rows and 52 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL13 created, with 2 rows and 52 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH14 created, with 4 rows and 56 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL14 created, with 4 rows and 56 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH15 created, with 8 rows and 60 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL15 created, with 8 rows and 60 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH16 created, with 16 rows and 64 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

41                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.LL16 created, with 16 rows and 64 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH17 created, with 16 rows and 68 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH18 created, with 16 rows and 72 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH19 created, with 16 rows and 76 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH20 created, with 16 rows and 80 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table WORK.HH21 created, with 16 rows and 84 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.00 seconds

NOTE: Variable probability is uninitialized.

NOTE: Variable count is uninitialized.

NOTE: Variable cost is uninitialized.

NOTE: Missing values were generated as a result of performing an operation on missing values.

42                                                         The SAS System                            15:50 Friday, November 21, 2008

      Each place is given by: (Number of times) at (Line):(Column).

      16 at 668:167   16 at 668:238

NOTE: There were 16 observations read from the data set WORK.HH21.

NOTE: The data set WORK.D4 has 16 observations and 70 variables.

NOTE: Compressing data set WORK.D4 decreased size by 0.00 percent.

      Compressed is 2 pages; un-compressed would require 2 pages.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 16 observations read from the data set WORK.D4.

NOTE: The data set WORK.HIGHCRUISE has 16 observations and 23 variables.

NOTE: Compressing data set WORK.HIGHCRUISE increased size by 100.00 percent.

      Compressed is 2 pages; un-compressed would require 1 pages.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: Variable count is uninitialized.

NOTE: Missing values were generated as a result of performing an operation on missing values.

      Each place is given by: (Number of times) at (Line):(Column).

      16 at 668:164

NOTE: There were 16 observations read from the data set WORK.LL16.

NOTE: The data set WORK.D5 has 16 observations and 53 variables.

NOTE: Compressing data set WORK.D5 increased size by 100.00 percent.

      Compressed is 2 pages; un-compressed would require 1 pages.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: Variable practice_1_practice_16 is uninitialized.

NOTE: There were 16 observations read from the data set WORK.D5.

NOTE: The data set WORK.LOWCRUISE has 16 observations and 18 variables.

NOTE: Compressing data set WORK.LOWCRUISE increased size by 100.00 percent.

      Compressed is 2 pages; un-compressed would require 1 pages.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 16 observations read from the data set WORK.LOWCRUISE.

NOTE: The data set WORK.LOWCRUISE has 16 observations and 18 variables.

NOTE: Compressing data set WORK.LOWCRUISE increased size by 100.00 percent.

      Compressed is 2 pages; un-compressed would require 1 pages.

NOTE: PROCEDURE SORT used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

43                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 16 observations read from the data set WORK.HIGHCRUISE.

NOTE: The data set WORK.HIGHCRUISE has 16 observations and 23 variables.

NOTE: Compressing data set WORK.HIGHCRUISE increased size by 100.00 percent.

      Compressed is 2 pages; un-compressed would require 1 pages.

NOTE: PROCEDURE SORT used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The data set WORK.LOWCRUISE1 has 1 observations and 21 variables.

NOTE: PROCEDURE UNIVARIATE used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.LOWCRUISE1.

NOTE: The data set WORK.LOWCRUISE2 has 21 observations and 3 variables.

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: Compression was disabled for data set TEMP3.LOWCRUISE3 because compression overhead would increase the size of the data set.

NOTE: There were 21 observations read from the data set WORK.LOWCRUISE2.

NOTE: The data set TEMP3.LOWCRUISE3 has 11 observations and 1 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: The data set WORK.HIGHCRUISE1 has 1 observations and 21 variables.

NOTE: PROCEDURE UNIVARIATE used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.HIGHCRUISE1.

NOTE: The data set WORK.HIGHCRUISE2 has 21 observations and 3 variables.

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: Compression was disabled for data set TEMP3.HIGHCRUISE3 because compression overhead would increase the size of the data set.

NOTE: There were 21 observations read from the data set WORK.HIGHCRUISE2.

44                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: The data set TEMP3.HIGHCRUISE3 has 11 observations and 1 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

669        %boat(Commercial Fishing,Comm,cf);

NOTE: There were 333 observations read from the data set WORK.D1.

NOTE: The data set WORK.D2 has 37 observations and 8 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: The query requires remerging summary statistics back with the original data.

NOTE: Table WORK.D3 created, with 37 rows and 10 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H1 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

45                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H2 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H3 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

46                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H4 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H5 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

47                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H6 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H7 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

48                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H8 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H9 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H10 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

49                                                         The SAS System                            15:50 Friday, November 21, 2008

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H11 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H12 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

50                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H13 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H14 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

51                                                         The SAS System                            15:50 Friday, November 21, 2008

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H15 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H16 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

52                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H17 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H18 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

53                                                         The SAS System                            15:50 Friday, November 21, 2008

      cpu time            0.01 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H19 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H20 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

54                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.H21 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L1 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L2 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

55                                                         The SAS System                            15:50 Friday, November 21, 2008

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L3 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L4 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

56                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L5 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L6 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

57                                                         The SAS System                            15:50 Friday, November 21, 2008

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L7 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L8 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

58                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L9 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L10 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

59                                                         The SAS System                            15:50 Friday, November 21, 2008

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L11 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L12 has 2 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

60                                                         The SAS System                            15:50 Friday, November 21, 2008

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L13 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X2 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 1 observations read from the data set WORK.X1.

NOTE: There were 1 observations read from the data set WORK.X2.

NOTE: The data set WORK.L14 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.

NOTE: The data set WORK.X1 has 1 observations and 14 variables.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

NOTE: There were 37 observations read from the data set WORK.D3.