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 1
data_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" then

Page 2
data_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 3
data_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 4
data_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 5
data_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 6
data_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 7
data_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 8
data_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 9
data_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 10
data_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 11
data_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 12
data_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 13
data_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 14
data_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 15
data_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