data_combine_03.21.11_log.txt

Author: Abt Associates Inc. Created: 8/13/2010 Updated: 3/21/2011 Purpose: This is a log file for the SAS program which reorganizes the I&E data to combine separate outputs for manufacturers and generators.

1 The SAS System 12:06 Tuesday, March 22, 2011

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.2 (TS2M0) Licensed to ABT ASSOCIATES INC, Site 70068845. NOTE: This session is executing on the XP_PRO platform.

NOTE: SAS initialization used: real time 0.37 seconds cpu time 0.24 seconds

1 *Author: Ryan Stapler, Abt Associates Inc. 2 *Created: 8/13/2010 3 *Updated: 3/21/2011; 4 *Purpose: This is a log file for the SAS program which reorganizes the I&E data to combine 4 ! separate outputs for manufacturers and generators;
5 6 7 *The location of the input and output files is here; 8 %let d=h; *(C or H drive); 9 %let mainloc=&d.:\ERD\TYCHE Contract\Assignments\WA 2-15 (316b Benefits & SP Study)\Task 5 9 ! - Benefits Analytic Support\IE_032111\data_edits\; 10 %let inloc=&mainloc.Inputs\; 11 %let outloc=&mainloc.Outputs\; 12 13 libname outloc "&outloc"; NOTE: Libref OUTLOC was successfully assigned as follows: Engine: V9 Physical Name: h:\ERD\TYCHE Contract\Assignments\WA 2-15 (316b Benefits & SP Study)\Task 5 - Benefits Analytic Support\IE_032111\data_edits\Outputs
14 15 *assumptions; 16 *The name of the input file is; 17 %let input=baselines.and.benefits.Mon.Mar.21.2011_opt4_edit.xls; 18 *The name of the output files are; 19 %let output=IE_outputs_&sysdate..xls; 20 21 *This is a macro that can be used to import data from excel; 22 %macro import(infile,insheet,out); 23 PROC IMPORT OUT= WORK.&out 24 DATAFILE= "&infile" 25 DBMS=EXCEL REPLACE; 26 SHEET="&insheet.$"; 27 GETNAMES=YES; 28 MIXED=NO; 29 SCANTEXT=YES; 30 USEDATE=YES; 31 SCANTIME=YES; 32 RUN; Page 1data_combine_03.21.11_log.txt

33 %mend; 34 *This is a macro that can be used to export data to excel; 35 %macro export(datafile,outfile,sheet); 36 PROC EXPORT DATA= &datafile 37 OUTFILE= &outfile 2 The SAS System 12:06 Tuesday, March 22, 2011

38 DBMS=EXCEL replace; 39 SHEET=&sheet; 40 RUN; 41 %mend; 42 43 *import data sets from excel input file;
44 45 *import entrainment data; 46 %import(&inloc.&input,bnb_ent,bnb_ent);

NOTE: WORK.BNB_ENT data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 26.23 seconds cpu time 2.65 seconds

47 *import impingement data; 48 %import(&inloc.&input,bnb_imp,bnb_imp);

NOTE: WORK.BNB_IMP data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 12.81 seconds cpu time 3.31 seconds

49 *import combined entrainment and impingement data; 50 %import(&inloc.&input,bnb_ie,bnb_ie);

NOTE: WORK.BNB_IE data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 13.29 seconds cpu time 3.61 seconds

51 52

************************************************************************** 53

************************************************************************** 54 *generate a combined entrainment dataset for manufacturers and generators; 55 data bnb_ent_1; 56 length option_name $20; 57 format option_name $20.; 58 set bnb_ent; 59 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 59 ! option_name="option.mn4" then benefit_value_regional_mn=benefit_value_regional; 60 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 60 ! option_name="option.t4" then benefit_value_regional_mn=0; 61 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 61 ! option_name="option.t4" thenPage 2data_combine_03.21.11_log.txt

benefit_value_regional_t=benefit_value_regional; 62 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 62 ! option_name="option.mn4" then benefit_value_regional_t=0; 63 drop baseline_value benefit_value regional_reduction ccr_fraction; 64 RUN;

NOTE: There were 38448 observations read from the data set WORK.BNB_ENT. 3 The SAS System 12:06 Tuesday, March 22, 2011

NOTE: The data set WORK.BNB_ENT_1 has 38448 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.04 seconds

65 data bnb_ent_mn; 66 set bnb_ent_1; 67 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 67 ! option_name="option.t4" then delete; 68 drop benefit_value_regional_t benefit_value_regional; 69 if option_name="option.mn1" then option_name="option.tmn1"; 70 if option_name="option.mn2" then option_name="option.tmn2"; 71 if option_name="option.mn3" then option_name="option.tmn3"; 72 if option_name="option.mn4" then option_name="option.tmn4"; 73 RUN;

NOTE: There were 38448 observations read from the data set WORK.BNB_ENT_1. NOTE: The data set WORK.BNB_ENT_MN has 19224 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds

74 data bnb_ent_t; 75 set bnb_ent_1; 76 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 76 ! option_name="option.mn4" then delete; 77 drop benefit_value_regional_mn benefit_value_regional; 78 if option_name="option.t1" then option_name="option.tmn1"; 79 if option_name="option.t2" then option_name="option.tmn2"; 80 if option_name="option.t3" then option_name="option.tmn3"; 81 if option_name="option.t4" then option_name="option.tmn4"; 82 RUN;

NOTE: There were 38448 observations read from the data set WORK.BNB_ENT_1. NOTE: The data set WORK.BNB_ENT_T has 19224 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds

83 Proc sort data=bnb_ent_mn out=bnb_ent_mn; 84 by option_name region species_econ metric comrec_type; 85 RUN;

NOTE: There were 19224 observations read from the data set WORK.BNB_ENT_MN. NOTE: The data set WORK.BNB_ENT_MN has 19224 observations and 9 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds Page 3data_combine_03.21.11_log.txt

cpu time 0.01 seconds

86 Proc sort data=bnb_ent_t out=bnb_ent_t; 4 The SAS System 12:06 Tuesday, March 22, 2011

87 by option_name region species_econ metric comrec_type; 88 RUN;

NOTE: There were 19224 observations read from the data set WORK.BNB_ENT_T. NOTE: The data set WORK.BNB_ENT_T has 19224 observations and 9 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.04 seconds cpu time 0.01 seconds

89 data bnb_ent_tot; 90 merge bnb_ent_mn bnb_ent_t; 91 by option_name region species_econ metric comrec_type; 92 RUN;

NOTE: There were 19224 observations read from the data set WORK.BNB_ENT_MN. NOTE: There were 19224 observations read from the data set WORK.BNB_ENT_T. NOTE: The data set WORK.BNB_ENT_TOT has 19224 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds

93 data bnb_ent_2; 94 set bnb_ent_tot; 95 benefit_value_regional= benefit_value_regional_mn + benefit_value_regional_t; 96 drop benefit_value_regional_mn benefit_value_regional_t; 97 RUN;

NOTE: There were 19224 observations read from the data set WORK.BNB_ENT_TOT. NOTE: The data set WORK.BNB_ENT_2 has 19224 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

98 99

************************************************************************************

******* 99 ! ******* 100

************************************************************************************

******* 100 ! ******* 101 *generate a combined impingement dataset for manufacturers and generators; 102 data bnb_imp_1; 103 length option_name $20; 104 format option_name $20.; 105 set bnb_imp; 106 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 106 ! option_name="option.mn4" then benefit_value_regional_mn=benefit_value_regional; Page 4data_combine_03.21.11_log.txt

107 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 107 ! option_name="option.t4" then benefit_value_regional_mn=0; 108 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 108 ! option_name="option.t4" then benefit_value_regional_t=benefit_value_regional; 109 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 109 ! option_name="option.mn4" then benefit_value_regional_t=0; 5 The SAS System 12:06 Tuesday, March 22, 2011

110 drop baseline_value benefit_value regional_reduction ccr_fraction f14; 111 RUN;

WARNING: The variable f14 in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 47424 observations read from the data set WORK.BNB_IMP. NOTE: The data set WORK.BNB_IMP_1 has 47424 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.31 seconds cpu time 0.07 seconds

112 data bnb_imp_mn; 113 set bnb_imp_1; 114 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 114 ! option_name="option.t4" then delete; 115 drop benefit_value_regional_t benefit_value_regional; 116 if option_name="option.mn1" then option_name="option.tmn1"; 117 if option_name="option.mn2" then option_name="option.tmn2"; 118 if option_name="option.mn3" then option_name="option.tmn3"; 119 if option_name="option.mn4" then option_name="option.tmn4"; 120 RUN;

NOTE: There were 47424 observations read from the data set WORK.BNB_IMP_1. NOTE: The data set WORK.BNB_IMP_MN has 23712 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.21 seconds cpu time 0.01 seconds

121 data bnb_imp_t; 122 set bnb_imp_1; 123 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 123 ! option_name="option.mn4" then delete; 124 drop benefit_value_regional_mn benefit_value_regional; 125 if option_name="option.t1" then option_name="option.tmn1"; 126 if option_name="option.t2" then option_name="option.tmn2"; 127 if option_name="option.t3" then option_name="option.tmn3"; 128 if option_name="option.t4" then option_name="option.tmn4"; 129 RUN;

NOTE: There were 47424 observations read from the data set WORK.BNB_IMP_1. NOTE: The data set WORK.BNB_IMP_T has 23712 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.21 seconds cpu time 0.04 seconds

Page 5data_combine_03.21.11_log.txt

130 Proc sort data=bnb_imp_mn out=bnb_imp_mn; 131 by option_name region species_econ metric comrec_type; 132 RUN;

NOTE: There were 23712 observations read from the data set WORK.BNB_IMP_MN. NOTE: The data set WORK.BNB_IMP_MN has 23712 observations and 9 variables. NOTE: PROCEDURE SORT used (Total process time): 6 The SAS System 12:06 Tuesday, March 22, 2011

real time 0.38 seconds cpu time 0.04 seconds

133 Proc sort data=bnb_imp_t out=bnb_imp_t; 134 by option_name region species_econ metric comrec_type; 135 RUN;

NOTE: There were 23712 observations read from the data set WORK.BNB_IMP_T. NOTE: The data set WORK.BNB_IMP_T has 23712 observations and 9 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds

136 data bnb_imp_tot; 137 merge bnb_imp_mn bnb_imp_t; 138 by option_name region species_econ metric comrec_type; 139 RUN;

NOTE: There were 23712 observations read from the data set WORK.BNB_IMP_MN. NOTE: There were 23712 observations read from the data set WORK.BNB_IMP_T. NOTE: The data set WORK.BNB_IMP_TOT has 23712 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.03 seconds

140 data bnb_imp_2; 141 set bnb_imp_tot; 142 benefit_value_regional= benefit_value_regional_mn + benefit_value_regional_t; 143 drop benefit_value_regional_mn benefit_value_regional_t; 144 RUN;

NOTE: There were 23712 observations read from the data set WORK.BNB_IMP_TOT. NOTE: The data set WORK.BNB_IMP_2 has 23712 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.32 seconds cpu time 0.00 seconds

145 146

************************************************************************************

******* 146 ! ********** 147 *generate a combined IM&E dataset for manufacturers and generators; 148 data bnb_ie_1; 149 length option_name $20; 150 format option_name $20.; 151 set bnb_ie; Page 6data_combine_03.21.11_log.txt

152 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 152 ! option_name="option.mn4" then benefit_value_regional_mn=benefit_value_regional; 153 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 153 ! option_name="option.t4" then benefit_value_regional_mn=0; 154 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 7 The SAS System 12:06 Tuesday, March 22, 2011

154 ! option_name="option.t4" then benefit_value_regional_t=benefit_value_regional; 155 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 155 ! option_name="option.mn4" then benefit_value_regional_t=0; 156 drop baseline_value benefit_value regional_reduction ccr_fraction; 157 RUN;

NOTE: There were 49280 observations read from the data set WORK.BNB_IE. NOTE: The data set WORK.BNB_IE_1 has 49280 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.64 seconds cpu time 0.06 seconds

158 data bnb_ie_mn; 159 set bnb_ie_1; 160 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 160 ! option_name="option.t4" then delete; 161 drop benefit_value_regional_t benefit_value_regional; 162 if option_name="option.mn1" then option_name="option.tmn1"; 163 if option_name="option.mn2" then option_name="option.tmn2"; 164 if option_name="option.mn3" then option_name="option.tmn3"; 165 if option_name="option.mn4" then option_name="option.tmn4"; 166 RUN;

NOTE: There were 49280 observations read from the data set WORK.BNB_IE_1. NOTE: The data set WORK.BNB_IE_MN has 24640 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.20 seconds cpu time 0.01 seconds

167 data bnb_ie_t; 168 set bnb_ie_1; 169 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 169 ! option_name="option.mn4" then delete; 170 drop benefit_value_regional_mn benefit_value_regional; 171 if option_name="option.t1" then option_name="option.tmn1"; 172 if option_name="option.t2" then option_name="option.tmn2"; 173 if option_name="option.t3" then option_name="option.tmn3"; 174 if option_name="option.t4" then option_name="option.tmn4"; 175 RUN;

NOTE: There were 49280 observations read from the data set WORK.BNB_IE_1. NOTE: The data set WORK.BNB_IE_T has 24640 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.21 seconds cpu time 0.06 seconds Page 7data_combine_03.21.11_log.txt

176 Proc sort data=bnb_ie_mn out=bnb_ie_mn; 177 by option_name region species_econ metric comrec_type; 178 RUN;

NOTE: There were 24640 observations read from the data set WORK.BNB_IE_MN. 8 The SAS System 12:06 Tuesday, March 22, 2011

NOTE: The data set WORK.BNB_IE_MN has 24640 observations and 9 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.23 seconds cpu time 0.03 seconds

179 Proc sort data=bnb_ie_t out=bnb_ie_t; 180 by option_name region species_econ metric comrec_type; 181 RUN;

NOTE: There were 24640 observations read from the data set WORK.BNB_IE_T. NOTE: The data set WORK.BNB_IE_T has 24640 observations and 9 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds

182 data bnb_ie_tot; 183 merge bnb_ie_mn bnb_ie_t; 184 by option_name region species_econ metric comrec_type; 185 RUN;

NOTE: There were 24640 observations read from the data set WORK.BNB_IE_MN. NOTE: There were 24640 observations read from the data set WORK.BNB_IE_T. NOTE: The data set WORK.BNB_IE_TOT has 24640 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.04 seconds

186 data bnb_ie_2; 187 set bnb_ie_tot; 188 benefit_value_regional= benefit_value_regional_mn + benefit_value_regional_t; 189 drop benefit_value_regional_mn benefit_value_regional_t; 190 RUN;

NOTE: There were 24640 observations read from the data set WORK.BNB_IE_TOT. NOTE: The data set WORK.BNB_IE_2 has 24640 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.17 seconds cpu time 0.03 seconds

191 192

************************************************************************************

******* 192 ! **** 193 *make changes to the reductions_detail sheet to calculate total ccr_fraction for 193 ! manufacturers and 194 generators combined; Page 8data_combine_03.21.11_log.txt

195 196 *START BY RE-IMPORTING THE SEPARATE MN and GN VALUES; 197 198 *import entrainment data; 199 %import(&inloc.&input,bnb_ent,bnb_ent); 9 The SAS System 12:06 Tuesday, March 22, 2011

NOTE: WORK.BNB_ENT data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 12.81 seconds cpu time 2.79 seconds

200 *import impingement data; 201 %import(&inloc.&input,bnb_imp,bnb_imp);

NOTE: WORK.BNB_IMP data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 12.75 seconds cpu time 3.39 seconds

202 *import combined entrainment and impingement data; 203 %import(&inloc.&input,bnb_ie,bnb_ie);

NOTE: WORK.BNB_IE data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 8.04 seconds cpu time 3.46 seconds

204 *import the reductions detail/ccr.fraction sheet; 205 %import(&inloc.&input,reductions_net,reductions_detail);

NOTE: WORK.REDUCTIONS_DETAIL data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 6.29 seconds cpu time 0.76 seconds

206 207 data bnb_entx; 208 set bnb_ent; 209 RUN;

NOTE: There were 38448 observations read from the data set WORK.BNB_ENT. NOTE: The data set WORK.BNB_ENTX has 38448 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds

210 data bnb_impx; 211 set bnb_imp; 212 RUN;

NOTE: There were 47424 observations read from the data set WORK.BNB_IMP. NOTE: The data set WORK.BNB_IMPX has 47424 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds 10 The SAS System 12:06 Page 9data_combine_03.21.11_log.txt

Tuesday, March 22, 2011

cpu time 0.03 seconds

213 data bnb_iex; 214 set bnb_ie; 215 RUN;

NOTE: There were 49280 observations read from the data set WORK.BNB_IE. NOTE: The data set WORK.BNB_IEX has 49280 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds

216 217 218 Data reductions_detail_1; 219 set reductions_detail; 220 drop regional_reduction_imp regional_reduction_ent ccr_fraction_ent; 221 RUN;

NOTE: There were 56 observations read from the data set WORK.REDUCTIONS_DETAIL. NOTE: The data set WORK.REDUCTIONS_DETAIL_1 has 56 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds

222 Proc sort data=reductions_detail_1; 223 by option_name region; 224 RUN;

NOTE: There were 56 observations read from the data set WORK.REDUCTIONS_DETAIL_1. NOTE: The data set WORK.REDUCTIONS_DETAIL_1 has 56 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds

225 226 Data bnb_imp_x1; 227 length benefit_value_regional_imp $20; 228 format benefit_value_regional_imp $20.; 229 set bnb_impx; 230 if species_econ="zz.all.species"; 231 if region ~="zz.allregions"; 232 if comrec_type="all.types"; 233 if metric="ae1"; 234 benefit_value_regional_imp=benefit_value_regional; 235 drop baseline_value benefit_value baseline_value_regional regional_reduction ccr_fraction 235 ! benefit_value_regional; 236 RUN;

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 11 The SAS System 12:06 Tuesday, March 22, 2011

234:29 NOTE: There were 47424 observations read from the data set WORK.BNB_IMPX. Page 10data_combine_03.21.11_log.txt

NOTE: The data set WORK.BNB_IMP_X1 has 56 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 1.03 seconds cpu time 0.01 seconds

237 Proc sort data=bnb_imp_x1 out=bnb_imp_x1; 238 by option_name region; 239 RUN;

NOTE: There were 56 observations read from the data set WORK.BNB_IMP_X1. NOTE: The data set WORK.BNB_IMP_X1 has 56 observations and 8 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

240 241 Data bnb_ie_x1; 242 set bnb_iex; 243 if species_econ="zz.all.species"; 244 if region ~="zz.allregions"; 245 if comrec_type="all.types"; 246 if metric="ae1"; 247 drop baseline_value benefit_value baseline_value_regional regional_reduction ccr_fraction; 248 RUN;

NOTE: There were 49280 observations read from the data set WORK.BNB_IEX. NOTE: The data set WORK.BNB_IE_X1 has 56 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.37 seconds cpu time 0.01 seconds

249 Proc sort data=bnb_ie_x1 out=bnb_ie_x1; 250 by option_name region; 251 RUN;

NOTE: There were 56 observations read from the data set WORK.BNB_IE_X1. NOTE: The data set WORK.BNB_IE_X1 has 56 observations and 8 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds

252 253 *this calculates separate values for mn and gn; 254 Data reductions_detail_2; 255 merge reductions_detail_1 bnb_imp_x1 bnb_ie_x1; 256 by option_name region; 257 if benefit_value_regional=0 then ccr_fraction_ie=0; 258 if benefit_value_regional~=0 then 12 The SAS System 12:06 Tuesday, March 22, 2011

258 ! ccr_fraction_ie=(ccr_fraction_imp*benefit_value_regional_imp+(benefit_value_regional -benefi 258 ! t_value_regional_imp))/benefit_value_regional; 259 drop value_basis species_econ lossmode metric comrec_type; 260 RUN;

Page 11data_combine_03.21.11_log.txt

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 258:71 258:122 NOTE: There were 56 observations read from the data set WORK.REDUCTIONS_DETAIL_1. NOTE: There were 56 observations read from the data set WORK.BNB_IMP_X1. NOTE: There were 56 observations read from the data set WORK.BNB_IE_X1. NOTE: The data set WORK.REDUCTIONS_DETAIL_2 has 56 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds

261 262 Data reductions_detail_3; 263 264 *length ccr_fraction_imp_mn $30; 265 *format ccr_fraction_imp_mn $30.; 266 *length ccr_fraction_imp_t $30; 267 *format ccr_fraction_imp_t $30.; 268 *length baseline_value_regional_imp_mn $30; 269 *format baseline_value_regional_imp_mn $30.; 270 *length baseline_value_regional_imp_t $30; 271 *format baseline_value_regional_imp_t $30.; 272 *length baseline_value_regional_imp_mn $30; 273 *format baseline_value_regional_imp_mn $30.; 274 *length baseline_value_regional_imp_t $30; 275 *format baseline_value_regional_imp_t $30.; 276 *length baseline_value_regional_mn $30; 277 *format baseline_value_regional_mn $30.; 278 *length baseline_value_regional_t $30; 279 *format baseline_value_regional_t $30.; 280 *length ccr_fraction_ie_mn $30; 281 *format ccr_fraction_ie_mn $30.; 282 *length ccr_fraction_ie_t $30; 283 *format ccr_fraction_ie_t $30.; 284 285 286 set reductions_detail_2; 287 288 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 288 ! option_name="option.mn4" then ccr_fraction_imp_mn=ccr_fraction_imp; 289 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 289 ! option_name="option.t4" then ccr_fraction_imp_mn=0; 290 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 290 ! option_name="option.t4" then ccr_fraction_imp_t=ccr_fraction_imp; 291 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 291 ! option_name="option.mn4" then ccr_fraction_imp_t=0; 292 293 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 293 ! option_name="option.mn4" then benefit_value_regional_imp_mn=benefit_value_regional_imp; 13 The SAS System 12:06 Tuesday, March 22, 2011

294 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 294 ! option_name="option.t4" then benefit_value_regional_imp_mn=0; 295 if option_name="option.t1" | option_name="option.t2" | Page 12data_combine_03.21.11_log.txt

option_name="option.t3" | 295 ! option_name="option.t4" then benefit_value_regional_imp_t=benefit_value_regional_imp; 296 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 296 ! option_name="option.mn4" then benefit_value_regional_imp_t=0; 297 298 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 298 ! option_name="option.mn4" then benefit_value_regional_mn=benefit_value_regional; 299 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 299 ! option_name="option.t4" then benefit_value_regional_mn=0; 300 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 300 ! option_name="option.t4" then benefit_value_regional_t=benefit_value_regional; 301 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 301 ! option_name="option.mn4" then benefit_value_regional_t=0; 302 303 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 303 ! option_name="option.mn4" then ccr_fraction_ie_mn=ccr_fraction_ie; 304 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 304 ! option_name="option.t4" then ccr_fraction_ie_mn=0; 305 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 305 ! option_name="option.t4" then ccr_fraction_ie_t=ccr_fraction_ie; 306 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 306 ! option_name="option.mn4" then ccr_fraction_ie_t=0; 307 308 if ccr_fraction_ie_mn <.0001 then ccr_fraction_ie_mn=0; 309 if ccr_fraction_ie_t <.0001 then ccr_fraction_ie_t=0; 310 311 drop ccr_fraction_imp benefit_value_regional_imp benefit_value_regional ccr_fraction_ie; 312 313 RUN;

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 294:143 296:146 NOTE: There were 56 observations read from the data set WORK.REDUCTIONS_DETAIL_2. NOTE: The data set WORK.REDUCTIONS_DETAIL_3 has 56 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

314 315 Data reductions_detail_3mn; 316 length option_name $20; 317 format option_name $20.; 318 set reductions_detail_3; 319 if option_name="option.t1" | option_name="option.t2" | option_name="option.t3" | 319 ! option_name="option.t4" then delete; 320 drop ccr_fraction_imp_t benefit_value_regional_imp_t benefit_value_regional_t Page 13data_combine_03.21.11_log.txt

320 ! ccr_fraction_ie_t; 321 if option_name="option.mn1" then option_name="option.tmn1"; 322 if option_name="option.mn2" then option_name="option.tmn2"; 323 if option_name="option.mn3" then option_name="option.tmn3"; 324 if option_name="option.mn4" then option_name="option.tmn4"; 14 The SAS System 12:06 Tuesday, March 22, 2011

325 RUN;

NOTE: There were 56 observations read from the data set WORK.REDUCTIONS_DETAIL_3. NOTE: The data set WORK.REDUCTIONS_DETAIL_3MN has 28 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds

326 Proc Sort data=reductions_detail_3mn out=reductions_detail_3mn; 327 by region option_name; 328 RUN;

NOTE: There were 28 observations read from the data set WORK.REDUCTIONS_DETAIL_3MN. NOTE: The data set WORK.REDUCTIONS_DETAIL_3MN has 28 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds

329 330 Data reductions_detail_3t; 331 length option_name $20; 332 format option_name $20.; 333 set reductions_detail_3; 334 if option_name="option.mn1" | option_name="option.mn2" | option_name="option.mn3" | 334 ! option_name="option.mn4" then delete; 335 drop ccr_fraction_imp_mn benefit_value_regional_imp_mn benefit_value_regional_mn 335 ! ccr_fraction_ie_mn; 336 if option_name="option.t1" then option_name="option.tmn1"; 337 if option_name="option.t2" then option_name="option.tmn2"; 338 if option_name="option.t3" then option_name="option.tmn3"; 339 if option_name="option.t4" then option_name="option.tmn4"; 340 RUN;

NOTE: There were 56 observations read from the data set WORK.REDUCTIONS_DETAIL_3. NOTE: The data set WORK.REDUCTIONS_DETAIL_3T has 28 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds

341 Proc Sort data=reductions_detail_3t out=reductions_detail_3t; 342 by region option_name; 343 RUN;

NOTE: There were 28 observations read from the data set WORK.REDUCTIONS_DETAIL_3T. NOTE: The data set WORK.REDUCTIONS_DETAIL_3T has 28 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): Page 14data_combine_03.21.11_log.txt

real time 0.01 seconds cpu time 0.00 seconds

344 15 The SAS System 12:06 Tuesday, March 22, 2011

345 Data reductions_detail_4; 346 merge reductions_detail_3mn reductions_detail_3t; 347 by region option_name; 348 RUN;

NOTE: There were 28 observations read from the data set WORK.REDUCTIONS_DETAIL_3MN. NOTE: There were 28 observations read from the data set WORK.REDUCTIONS_DETAIL_3T. NOTE: The data set WORK.REDUCTIONS_DETAIL_4 has 28 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

349 350 data reductions_detail_5; 351 set reductions_detail_4; 352 ccr_fraction_imp= (ccr_fraction_imp_mn*benefit_value_regional_imp_mn

+ 352 ! ccr_fraction_imp_t*benefit_value_regional_imp_t)/(benefit_value_regional_imp_mn + 352 ! benefit_value_regional_imp_t); 353 ccr_fraction_ie= (ccr_fraction_ie_mn*benefit_value_regional_mn + 353 ! ccr_fraction_ie_t*benefit_value_regional_t)/(benefit_value_regional_mn + 353 ! benefit_value_regional_t); 354 RUN;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 352:41 352:92 352:123 352:155 NOTE: There were 28 observations read from the data set WORK.REDUCTIONS_DETAIL_4. NOTE: The data set WORK.REDUCTIONS_DETAIL_5 has 28 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds

355 356 357 data reductions_detail_6 (keep= option_name region ccr_fraction_imp ccr_fraction_ie); 358 set reductions_detail_5; 359 drop ccr_fraction_ie; 360 RUN;

WARNING: The variable ccr_fraction_ie in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 28 observations read from the data set WORK.REDUCTIONS_DETAIL_5. NOTE: The data set WORK.REDUCTIONS_DETAIL_6 has 28 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

361 362 Proc Sort data=reductions_detail_6 out=reductions_detail_6; Page 15data_combine_03.21.11_log.txt

363 by option_name region; 364 RUN;

NOTE: There were 28 observations read from the data set WORK.REDUCTIONS_DETAIL_6. 16 The SAS System 12:06 Tuesday, March 22, 2011

NOTE: The data set WORK.REDUCTIONS_DETAIL_6 has 28 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.06 seconds cpu time 0.03 seconds

365 366 *export the revised entrainment dataset; 367 %export(bnb_ent_2,"&outloc.&output",bnb_ent);

NOTE: "BNB_ENT" range/sheet was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 21.95 seconds cpu time 0.98 seconds

368 *export the revised impingement dataset; 369 %export(bnb_imp_2,"&outloc.&output",bnb_imp);

NOTE: "BNB_IMP" range/sheet was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 11.68 seconds cpu time 1.28 seconds

370 *export the revised IM&E dataset; 371 %export(bnb_ie_2,"&outloc.&output",bnb_ie);

NOTE: "BNB_IE" range/sheet was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 7.60 seconds cpu time 1.23 seconds

372 *export the reductions detail sheet with the impingement fraction numbers; 373 %export(reductions_detail_6,"&outloc.&output",reductions_detail);

NOTE: "REDUCTIONS_DETAIL" range/sheet was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 6.76 seconds cpu time 0.62 seconds

374 375 *************************************************************************

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 2:25.80 cpu time 25.24 seconds

Page 16