1                                                    The SAS System                      15:23 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          
4          *********************************************************;
5          * additions to nelson's code                            *;
6          * WP2 Translog cost regressions, corrected              *;
7          * for multi-collinearity                                *;
8          *********************************************************;
9          
10          libname out 'f:\proj\jkn2389\datasets';
NOTE: Libref OUT was successfully assigned as follows: 
      Engine:        V612 
      Physical Name: f:\proj\jkn2389\datasets
11         
12          *****************;
13          * var cf vans   *;
14          *****************;
15         
16          data newreg;
17          set out.vanvar;
18          LCOST=LOG(COST);
19          LTRCUBE=LOG(TRCUBE);
20          LNUMRUN=LOG(NUMRUNS);
21          LTRCU_2=LTRCUBE**2;
22          LRL_2=LRL**2;
23          LNUM_2=LNUMRUN**2;
24          LTRCURL=LTRCUBE*LRL;
25          LTRCUNU=LTRCUBE*LNUMRUN;
26          LRLNUM=LRL*LNUMRUN;
27         

NOTE: The data set WORK.NEWREG has 5115 observations and 51 variables.
NOTE: The DATA statement used 2.31 seconds.


28          PROC REG DATA=newreg;
29          MODEL LCOST= A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12
30                       LTRCUBE LRL LNUMRUN LTRCU_2 LRL_2 LNUM_2 LTRCURL LTRCUNU LRLNUM;
31          title "VAR CF Van WP2 Cost Translog";
32         
33         
34          *******************************************************;
35          * adding residuals from regression of LNUMRUN on LRL  *;
36          * and LTRCUBE to correct for potential                *;
37          * multi-collinearity                                  *;
38          *******************************************************;
39         

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 1.
NOTE: The PROCEDURE REG used 2.52 seconds.

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


40           PROC REG data=newreg noprint;
41           MODEL LNUMRUN = LRL LTRCUBE;
42           output out=res1 r=res1;
43         

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.RES1 has 5115 observations and 52 variables.
NOTE: The PROCEDURE REG used 3.18 seconds.


44           data res1;
45           set res1;
46           keep hcrid res1;
47         

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


48           proc sort data=res1;
49           by hcrid;
50         

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


51           proc sort data=newreg;
52           by hcrid;
53         

NOTE: The data set WORK.NEWREG has 5115 observations and 51 variables.
NOTE: The PROCEDURE SORT used 1.64 seconds.


54           data  newreg miss;
55           merge res1 (in=a) newreg (in=b);
56           by hcrid;
57           if a=1 and b=1 then output newreg;
58           else output miss;
59         

NOTE: MERGE statement has more than one data set with repeats of BY values.
NOTE: The data set WORK.NEWREG has 5115 observations and 52 variables.
NOTE: The data set WORK.MISS has 0 observations and 52 variables.
NOTE: The DATA statement used 2.18 seconds.


60           data newreg;
61           set newreg;
62           res_2=res1**2;
63           LTRCURE=LTRCUBE*RES1;
64           LRLRES=LRL*RES1;
65         

NOTE: The data set WORK.NEWREG has 5115 observations and 55 variables.
NOTE: The DATA statement used 1.37 seconds.


66           PROC REG data=newreg;
67           MODEL LCOST = A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12
68                         LTRCUBE LRL res1 LTRCU_2 LRL_2 res_2 LTRCURL LTRCURE LRLRES;
69           title "VAR CF Van WP2 Cost Translog With Collinearity Correction";
3                                                    The SAS System                      15:23 Thursday, August 10, 2000

70         
71           *******************;
72           * var cf trailers *;
73           *******************;
74         

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 1.04 seconds.


75           data newreg;
76           set out.tracvar;
77           LCOST=LOG(COST);
78           LTRCUBE=LOG(TRCUBE);
79           LNUMRUN=LOG(NUMRUNS);
80           LTRCU_2=LTRCUBE**2;
81           LRL_2=LRL**2;
82           LNUM_2=LNUMRUN**2;
83           LTRCURL=LTRCUBE*LRL;
84           LTRCUNU=LTRCUBE*LNUMRUN;
85           LRLNUM=LRL*LNUMRUN;
86         

NOTE: The data set WORK.NEWREG has 709 observations and 51 variables.
NOTE: The DATA statement used 0.81 seconds.


87           PROC REG DATA=newreg;
88           MODEL LCOST= A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12
89                       LTRCUBE LRL LNUMRUN LTRCU_2 LRL_2 LNUM_2 LTRCURL LTRCUNU LRLNUM;
90           title "VAR CF Trailer WP2 Cost Translog";
91         
92         
93          *******************************************************;
94          * adding residuals from regression of LNUMRUN on LRL  *;
95          * and LTRCUBE to correct for potential                *;
96          * multi-collinearity                                  *;
97          *******************************************************;
98         

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.71 seconds.


99           PROC REG data=newreg noprint;
100          MODEL LNUMRUN = LRL LTRCUBE;
101          output out=res2 r=res2;
102        

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.RES2 has 709 observations and 52 variables.
NOTE: The PROCEDURE REG used 0.98 seconds.


103          data res2;
104          set res2;
105          keep hcrid res2;
106        
4                                                    The SAS System                      15:23 Thursday, August 10, 2000


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


107          proc sort data=res2;
108          by hcrid;
109        

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


110          proc sort data=newreg;
111          by hcrid;
112        

NOTE: The data set WORK.NEWREG has 709 observations and 51 variables.
NOTE: The PROCEDURE SORT used 0.27 seconds.


113          data  newreg miss;
114          merge res2 (in=a) newreg (in=b);
115          by hcrid;
116          if a=1 and b=1 then output newreg;
117          else output miss;
118        

NOTE: MERGE statement has more than one data set with repeats of BY values.
NOTE: The data set WORK.NEWREG has 709 observations and 52 variables.
NOTE: The data set WORK.MISS has 0 observations and 52 variables.
NOTE: The DATA statement used 0.77 seconds.


119          data newreg;
120          set newreg;
121          res_2=res2**2;
122          LTRCURE=LTRCUBE*RES2;
123          LRLRES=LRL*RES2;
124        

NOTE: The data set WORK.NEWREG has 709 observations and 55 variables.
NOTE: The DATA statement used 0.48 seconds.


125          PROC REG data=newreg;
126          MODEL LCOST = A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12
127                        LTRCUBE LRL res2 LTRCU_2 LRL_2 res_2 LTRCURL LTRCURE LRLRES;
128          title "VAR CF Trailer WP2 Cost Translog With Collinearity Correction";
129        
130        
131        
132          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.
133        
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