1                                                    The SAS System                      15:17 Thursday, August 10, 2000

NOTE: Copyright (c) 1989-1996 by SAS Institute Inc., Cary, NC, USA. 
NOTE: SAS (r) Proprietary Software Release 6.12  TS020
      Licensed to CHARLES RIVER ASSOCIATES, Site 0021336004.




NOTE: AUTOEXEC processing beginning; file is S:\APPS\SAS612\AUTOEXEC.SAS.


NOTE: AUTOEXEC processing completed.

1          
2          *********************************************************;
3          * additions to nelson's code                            *;
4          *********************************************************;
5          
6           libname out 'f:\proj\jkn2389\datasets';
NOTE: Libref OUT was successfully assigned as follows: 
      Engine:        V612 
      Physical Name: f:\proj\jkn2389\datasets
7          
8          
9          *******************************************************;
10         * THIS SECTION OF THE PROGRAM CREATES THE             *;
11         * SUBSET THAT CONTAINS ONLY VANS.                     *;
12         *******************************************************;
13           DATA LOWERS; SET out.TRAPDC2;
14           IF TRCUBE LT 1350 ;
15         

NOTE: The data set WORK.LOWERS has 5115 observations and 25 variables.
NOTE: The DATA statement used 2.47 seconds.


16           DATA TRAPDC3;
17           SET LOWERS;
18           A1 = 0; IF AREA=1 THEN A1 =1;
19           A2 = 0; IF AREA=2 THEN A2 =1;
20           A3 = 0; IF AREA=3 THEN A3 =1;
21           A4 = 0; IF AREA=4 THEN A4 =1;
22           A5 = 0; IF AREA=5 THEN A5 =1;
23           A6 = 0; IF AREA=6 THEN A6 =1;
24           A7 = 0; IF AREA=7 THEN A7 =1;
25           A8 = 0; IF AREA=8 THEN A8 =1;
26           A9 = 0; IF AREA=9 THEN A9 =1;
27           A10 = 0; IF AREA=10 THEN A10 =1;
28           A11 = 0; IF AREA=11 THEN A11 =1;
29           A12 = 0; IF AREA=12 THEN A12 =1;
30           A13 = 0; IF AREA=13 THEN A13 =1;
31         

NOTE: The data set WORK.TRAPDC3 has 5115 observations and 38 variables.
NOTE: The DATA statement used 1.1 seconds.


32           DATA NODAT PDCREG; SET TRAPDC3;
33           IF C_PER_N=0 THEN OUTPUT NODAT;
34           ELSE OUTPUT PDCREG;
35         

NOTE: The data set WORK.NODAT has 0 observations and 38 variables.
NOTE: The data set WORK.PDCREG has 5115 observations and 38 variables.
NOTE: The DATA statement used 1.2 seconds.


2                                                    The SAS System                      15:17 Thursday, August 10, 2000

36           DATA out.vanvar;
37           SET PDCREG;
38           LCPER_N  = LOG(C_PER_N);
39           LTRC_RL  = LOG(TRCUBE*RL);
40           LRL      = LOG(RL);
41         
42          ******************************************************;
43          * ESTIMATING THE ESTABLISHED SPECFICATION            *;
44          * ADDING DUMMY VARIABLES FOR EACH AREA               *;
45          ******************************************************;

NOTE: The data set OUT.VANVAR has 5115 observations and 41 variables.
NOTE: The DATA statement used 3.89 seconds.


46           PROC REG data=out.vanvar;
47           MODEL LCPER_N =
48                     A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12
49                        LTRC_RL LRL;
50           WEIGHT NUMRUNS;
51           title "Original VAR CF Van";
52         
53           RUN;

WARNING: The variable _NAME_ or _TYPE_ exists in a data set that is not TYPE=CORR, COV, SSCP, etc.
NOTE: 5115 observations read.
NOTE: 5115 observations used in computations.
54         
55          *******************************************************;
56          * adding residuals from regression of LRL on LTRC_RL  *;
57          * to correct for potential multi-collinearity         *;
58          *******************************************************;
59         

NOTE: The PROCEDURE REG printed page 1.
NOTE: The PROCEDURE REG used 4.4 seconds.


60           PROC REG data=out.vanvar noprint;
61           MODEL LRL = LTRC_RL;
62           output out=res r=res;
63         

WARNING: The variable _NAME_ or _TYPE_ exists in a data set that is not TYPE=CORR, COV, SSCP, etc.
NOTE: 5115 observations read.
NOTE: 5115 observations used in computations.
NOTE: The data set WORK.RES has 5115 observations and 42 variables.
NOTE: The PROCEDURE REG used 2.97 seconds.


64           data res;
65           set res;
66           keep hcrid res;
67         

NOTE: The data set WORK.RES has 5115 observations and 2 variables.
NOTE: The DATA statement used 0.66 seconds.


68           proc sort data=res;
69           by hcrid;
70         

NOTE: The data set WORK.RES has 5115 observations and 2 variables.
NOTE: The PROCEDURE SORT used 0.7 seconds.

3                                                    The SAS System                      15:17 Thursday, August 10, 2000


71           proc sort data=out.vanvar;
72           by hcrid;
73         

NOTE: The data set OUT.VANVAR has 5115 observations and 41 variables.
NOTE: The PROCEDURE SORT used 3.89 seconds.


74           data  out.vanvar miss;
75           merge res (in=a) out.vanvar (in=b);
76           by hcrid;
77           if a=1 and b=1 then output out.vanvar;
78           else output miss;
79         

NOTE: MERGE statement has more than one data set with repeats of BY values.
NOTE: The data set OUT.VANVAR has 5115 observations and 42 variables.
NOTE: The data set WORK.MISS has 0 observations and 42 variables.
NOTE: The DATA statement used 6.09 seconds.


80           PROC REG data=out.vanvar;
81           MODEL LCPER_N =
82                     A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12
83                        LTRC_RL res;
84           WEIGHT NUMRUNS;
85           title "Original VAR CF Van With Collinearity Correction";
86         
87         
88          *******************************************************;
89          * THIS SECTION OF THE PROGRAM CREATES THE             *;
90          * SUBSET THAT CONTAINS ONLY TRACTOR TRAILERS.         *;
91          *******************************************************;
92         

WARNING: The variable _NAME_ or _TYPE_ exists in a data set that is not TYPE=CORR, COV, SSCP, etc.
NOTE: 5115 observations read.
NOTE: 5115 observations used in computations.
NOTE: The PROCEDURE REG printed page 2.
NOTE: The PROCEDURE REG used 2.2 seconds.


93           DATA UPPERS; SET out.TRAPDC2;
94           IF (TRCUBE GE 1650 AND TRCUBE LE 3000);
95         
96         

NOTE: The data set WORK.UPPERS has 709 observations and 25 variables.
NOTE: The DATA statement used 0.59 seconds.


97           DATA TRAPDC3;
98           SET UPPERS;
99           A1 = 0; IF AREA=1 THEN A1 =1;
100          A2 = 0; IF AREA=2 THEN A2 =1;
101          A3 = 0; IF AREA=3 THEN A3 =1;
102          A4 = 0; IF AREA=4 THEN A4 =1;
103          A5 = 0; IF AREA=5 THEN A5 =1;
104          A6 = 0; IF AREA=6 THEN A6 =1;
105          A7 = 0; IF AREA=7 THEN A7 =1;
106          A8 = 0; IF AREA=8 THEN A8 =1;
107          A9 = 0; IF AREA=9 THEN A9 =1;
108          A10 = 0; IF AREA=10 THEN A10 =1;
109          A11 = 0; IF AREA=11 THEN A11 =1;
110          A12 = 0; IF AREA=12 THEN A12 =1;
4                                                    The SAS System                      15:17 Thursday, August 10, 2000

111          A13 = 0; IF AREA=13 THEN A13 =1;
112        

NOTE: The data set WORK.TRAPDC3 has 709 observations and 38 variables.
NOTE: The DATA statement used 0.54 seconds.


113          DATA NODAT PDCREG; SET TRAPDC3;
114          IF C_PER_N=0 THEN OUTPUT NODAT;
115          ELSE OUTPUT PDCREG;
116        

NOTE: The data set WORK.NODAT has 0 observations and 38 variables.
NOTE: The data set WORK.PDCREG has 709 observations and 38 variables.
NOTE: The DATA statement used 0.59 seconds.


117          DATA out.tracvar;
118          SET PDCREG;
119          LCPER_N  = LOG(C_PER_N);
120          LTRC_RL  = LOG(TRCUBE*RL);
121          LRL      = LOG(RL);
122        
123         ******************************************************;
124         * ESTIMATING THE ESTABLISHED SPECFICATION            *;
125         * ADDING DUMMY VARIABLES FOR EACH AREA               *;
126         ******************************************************;
127        

NOTE: The data set OUT.TRACVAR has 709 observations and 41 variables.
NOTE: The DATA statement used 1.87 seconds.


128          PROC REG data=out.tracvar;
129          MODEL LCPER_N =
130                    A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12
131                       LTRC_RL LRL;
132          WEIGHT NUMRUNS;
133          title "Original VAR CF Trailer";
134        
135         *******************************************************;
136         * adding residuals from regression of LRL on LTRC_RL  *;
137         * to correct for potential multi-collinearity         *;
138         *******************************************************;
139        

WARNING: The variable _NAME_ or _TYPE_ exists in a data set that is not TYPE=CORR, COV, SSCP, etc.
NOTE: 709 observations read.
NOTE: 709 observations used in computations.
NOTE: The PROCEDURE REG printed page 3.
NOTE: The PROCEDURE REG used 0.88 seconds.


140          PROC REG data=out.tracvar noprint;
141          MODEL LRL = LTRC_RL;
142          output out=res r=res;
143        

WARNING: The variable _NAME_ or _TYPE_ exists in a data set that is not TYPE=CORR, COV, SSCP, etc.
NOTE: 709 observations read.
NOTE: 709 observations used in computations.
NOTE: The data set WORK.RES has 709 observations and 42 variables.
NOTE: The PROCEDURE REG used 0.98 seconds.


144          data res;
5                                                    The SAS System                      15:17 Thursday, August 10, 2000

145          set res;
146          keep hcrid res;
147        

NOTE: The data set WORK.RES has 709 observations and 2 variables.
NOTE: The DATA statement used 0.27 seconds.


148          proc sort data=res;
149          by hcrid;
150        

NOTE: The data set WORK.RES has 709 observations and 2 variables.
NOTE: The PROCEDURE SORT used 0.22 seconds.


151          proc sort data=out.tracvar;
152          by hcrid;
153        

NOTE: The data set OUT.TRACVAR has 709 observations and 41 variables.
NOTE: The PROCEDURE SORT used 1.81 seconds.


154          data  out.tracvar miss;
155          merge res (in=a) out.tracvar (in=b);
156          by hcrid;
157          if a=1 and b=1 then output out.tracvar;
158          else output miss;
159        

NOTE: MERGE statement has more than one data set with repeats of BY values.
NOTE: The data set OUT.TRACVAR has 709 observations and 42 variables.
NOTE: The data set WORK.MISS has 0 observations and 42 variables.
NOTE: The DATA statement used 2.64 seconds.


160          PROC REG data=out.tracvar;
161          MODEL LCPER_N =
162                    A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12
163                       LTRC_RL res;
164          WEIGHT NUMRUNS;
165          title "Original VAR CF Trailer With Collinearity Correction";
166        
167        run;

WARNING: The variable _NAME_ or _TYPE_ exists in a data set that is not TYPE=CORR, COV, SSCP, etc.
NOTE: 709 observations read.
NOTE: 709 observations used in computations.
168        
NOTE: The PROCEDURE REG printed page 4.
NOTE: The PROCEDURE REG used 0.7 seconds.


NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414