Solved: proc import - unsuccessful

sastuck · Posted 03-03-2018 03:12 PM

Hello,

I am trying to import two datasets but to no avail. The data show up in my output, but SAS tells me that the import was unsuccessful. I've checked to make sure the file paths were correct--this doesn't seem to be the problem.

Here is my code:

libname paper "~/425/425_Final_Paper";

/*import compustat dataset*/
PROC IMPORT out=paper.CompuStat_Execucomp
datafile="~/425/425_Final_Paper/CompuStat_Execucomp.csv"
DBMS=CSV replace;
getnames= yes;
run;

/*import csrp dataset*/
PROC IMPORT out=paper.CSRP_Monthly_Stock
datafile="~/425/425_Final_Paper/CSRP_MonthlyStock.csv"
DBMS=CSV replace;
getnames= yes;
run;

Do you have any suggestions? Thanks!

mkeintz · Posted 03-03-2018 06:15 PM

In line 46 of your data, the CUSIP field has a value of

02376R10

but your import program expects it to be numeric. Hence the

NOTE: Invalid data for CUSIP in line 46 513-520.

on the log. This note is probably due to the fact that PROC import assesses the first few raw data lines to determine whether a variable is number, and if it is character, the number of bytes to expect. Probably line 46 was not pre-scanned for this purpose. And this unexpected condition is repeated a number of times. When it happes the record-level automatic variable _ERROR_ is set to 1. And proc import examines _ERROR_ for each record. If it is 1, then the macrovar EFIERR is set to one, which is apparently tested at the end of the data step.

The proc import documentation says:

For delimited files, the first 20 rows are scanned to determine the variable attributes. You can increase the number of rows that are scanned by using the GUESSINGROWS= statement. All values are read in as character strings. If a Date and Time format or a numeric informat can be applied to the data value, the type is declared as numeric. Otherwise, the type remains character.

So you can add a guessingrows statement to the proc import, (I think it can either precede or succeed the GETNAMES statement):

guessingrows=500;

or even

guessingrows=max;

And you might want to look up how CUSIPs codes are defined.

Finally, did you download your csv data from WRDS? If so, you can re-download, and simply request a PC-SAS format in the download query.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

View solution in original post

Tom · Posted 03-03-2018 03:15 PM

Post the relevant lines from your SAS log. Use the {i} so that formatting is preserved. Do not post a photograph of the log. Especially not a photograph saved into a PDF file.

sastuck · Posted 03-03-2018 03:21 PM

Hello,

Would you like the error messages, the warnings, or the notes? Also how do I preserve formatting? Not sure what {i} means. Thanks for the help

Tom · Posted 03-03-2018 03:37 PM

You only submitted one libname and two proc steps, so just copy the log lines from the libname statement to the last note after the second proc step.

There is a menu bar at the top of the editor window on this forum. Highlight the text in your log and copy using what every key/mouse buttons work on your machine. Then click on the {i} icon and a new window will pop-up and you can paste the text into there and press the OK button to save it.

sastuck · Posted 03-03-2018 05:28 PM

Thanks for the suggestion. I posted the relevant section of the log below.

sastuck · Posted 03-03-2018 04:11 PM

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

70

71 libname paper "~/425/425_Final_Paper";

NOTE: Libref PAPER was successfully assigned as follows:

Engine: V9

Physical Name: /home/apmorabito0/425/425_Final_Paper

72

73 /*import compustat dataset*/

74 PROC IMPORT out=paper.CompuStat_Execucomp

75 datafile="~/425/425_Final_Paper/CompuStat_Execucomp.csv"

76 DBMS=CSV replace;

77 getnames= yes;

78 run;

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

79 /**********************************************************************

80 * PRODUCT: SAS

81 * VERSION: 9.4

82 * CREATOR: External File Interface

83 * DATE: 03MAR18

84 * DESC: Generated SAS Datastep Code

85 * TEMPLATE SOURCE: (None Specified.)

86 ***********************************************************************/

87 data PAPER.COMPUSTAT_EXECUCOMP ;

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

89 infile '~/425/425_Final_Paper/CompuStat_Execucomp.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;

90 informat EXEC_FULLNAME $20. ;

91 informat CFOANN $3. ;

92 informat EXECDIR best32. ;

93 informat OLD_DATAFMT_FLAG best32. ;

94 informat INTERLOCK best32. ;

95 informat REPRICE best32. ;

96 informat EXECRANK best32. ;

97 informat CO_PER_ROL best32. ;

98 informat CONAME $8. ;

99 informat TITLEANN $81. ;

100 informat CEOANN $3. ;

101 informat SALARY best32. ;

102 informat BONUS best32. ;

103 informat STOCK_AWARDS best32. ;

104 informat OPTION_AWARDS best32. ;

105 informat NONEQ_INCENT best32. ;

106 informat PENSION_CHG best32. ;

107 informat OTHCOMP best32. ;

108 informat TOTAL_SEC best32. ;

109 informat TOTAL_CURR best32. ;

110 informat TOTAL_ALT1 best32. ;

111 informat TOTAL_ALT2 best32. ;

112 informat TERM_PYMT best32. ;

113 informat CHG_CTRL_PYMT best32. ;

114 informat SHROWN_TOT best32. ;

115 informat SHROWN_TOT_PCT best32. ;

116 informat SHROWN_EXCL_OPTS best32. ;

117 informat SHROWN_EXCL_OPTS_PCT best32. ;

118 informat OPT_EXER_NUM best32. ;

119 informat OPT_EXER_VAL best32. ;

120 informat SHRS_VEST_NUM best32. ;

121 informat SHRS_VEST_VAL best32. ;

122 informat AGE best32. ;

123 informat OPTION_AWARDS_NUM best32. ;

124 informat OPTION_AWARDS_FV best32. ;

125 informat STOCK_AWARDS_FV best32. ;

126 informat OPT_UNEX_EXER_NUM best32. ;

127 informat OPT_UNEX_UNEXER_NUM best32. ;

128 informat OPT_UNEX_EXER_EST_VAL best32. ;

129 informat OPT_UNEX_UNEXER_EST_VAL best32. ;

130 informat STOCK_UNVEST_NUM best32. ;

131 informat STOCK_UNVEST_VAL best32. ;

132 informat EIP_UNEARN_NUM best32. ;

133 informat EIP_UNEARN_VAL best32. ;

134 informat PENSION_VALUE_TOT best32. ;

135 informat PENSION_PYMTS_TOT best32. ;

136 informat DEFER_CONTRIB_EXEC_TOT best32. ;

137 informat DEFER_CONTRIB_CO_TOT best32. ;

138 informat DEFER_EARNINGS_TOT best32. ;

139 informat DEFER_WITHDR_TOT best32. ;

140 informat DEFER_BALANCE_TOT best32. ;

141 informat DEFER_RPT_AS_COMP_TOT best32. ;

142 informat EXECRANKANN best32. ;

143 informat OTHANN $1. ;

144 informat TDC1 best32. ;

145 informat TDC2 best32. ;

146 informat RSTKGRNT $1. ;

147 informat OPTION_AWARDS_BLK_VALUE $1. ;

148 informat OPTION_AWARDS_RPT_VALUE $1. ;

149 informat LTIP $1. ;

150 informat ALLOTHTOT $1. ;

151 informat ALLOTHPD $1. ;

152 informat SAL_PCT best32. ;

153 informat TOTAL_CURR_PCT best32. ;

154 informat TOTAL_SEC_PCT best32. ;

155 informat TOTAL_ALT1_PCT best32. ;

156 informat TOTAL_ALT2_PCT best32. ;

157 informat TDC1_PCT best32. ;

158 informat TDC2_PCT best32. ;

159 informat RET_YRS $1. ;

160 informat COMMENT $1. ;

161 informat GVKEY best32. ;

162 informat EXECID best32. ;

163 informat YEAR best32. ;

164 informat RSTKVYRS $1. ;

165 informat BECAMECEO best32. ;

166 informat JOINED_CO $1. ;

167 informat REJOIN $1. ;

168 informat LEFTOFC $1. ;

169 informat LEFTCO $1. ;

170 informat RELEFT $1. ;

171 informat PCEO $3. ;

172 informat PCFO $3. ;

173 informat TITLE $55. ;

174 informat REASON $1. ;

175 informat EXEC_LNAME $9. ;

176 informat EXEC_FNAME $7. ;

177 informat EXEC_MNAME $2. ;

178 informat GENDER $4. ;

179 informat NAMEPREFIX $3. ;

180 informat PAGE best32. ;

181 informat CUSIP best32. ;

182 informat EXCHANGE $3. ;

183 informat ADDRESS $41. ;

184 informat CITY $9. ;

185 informat STATE $2. ;

186 informat ZIP best32. ;

187 informat TELE $12. ;

188 informat SICDESC $28. ;

189 informat NAICSDESC $50. ;

190 informat INDDESC $19. ;

191 informat SPCODE $2. ;

192 informat TICKER $3. ;

193 informat SUB_TELE best32. ;

194 informat NAICS best32. ;

195 informat SPINDEX best32. ;

196 informat SIC best32. ;

197 format EXEC_FULLNAME $20. ;

198 format CFOANN $3. ;

199 format EXECDIR best12. ;

200 format OLD_DATAFMT_FLAG best12. ;

201 format INTERLOCK best12. ;

202 format REPRICE best12. ;

203 format EXECRANK best12. ;

204 format CO_PER_ROL best12. ;

205 format CONAME $8. ;

206 format TITLEANN $81. ;

207 format CEOANN $3. ;

208 format SALARY best12. ;

209 format BONUS best12. ;

210 format STOCK_AWARDS best12. ;

211 format OPTION_AWARDS best12. ;

212 format NONEQ_INCENT best12. ;

213 format PENSION_CHG best12. ;

214 format OTHCOMP best12. ;

215 format TOTAL_SEC best12. ;

216 format TOTAL_CURR best12. ;

217 format TOTAL_ALT1 best12. ;

218 format TOTAL_ALT2 best12. ;

219 format TERM_PYMT best12. ;

220 format CHG_CTRL_PYMT best12. ;

221 format SHROWN_TOT best12. ;

222 format SHROWN_TOT_PCT best12. ;

223 format SHROWN_EXCL_OPTS best12. ;

224 format SHROWN_EXCL_OPTS_PCT best12. ;

225 format OPT_EXER_NUM best12. ;

226 format OPT_EXER_VAL best12. ;

227 format SHRS_VEST_NUM best12. ;

228 format SHRS_VEST_VAL best12. ;

229 format AGE best12. ;

230 format OPTION_AWARDS_NUM best12. ;

231 format OPTION_AWARDS_FV best12. ;

232 format STOCK_AWARDS_FV best12. ;

233 format OPT_UNEX_EXER_NUM best12. ;

234 format OPT_UNEX_UNEXER_NUM best12. ;

235 format OPT_UNEX_EXER_EST_VAL best12. ;

236 format OPT_UNEX_UNEXER_EST_VAL best12. ;

237 format STOCK_UNVEST_NUM best12. ;

238 format STOCK_UNVEST_VAL best12. ;

239 format EIP_UNEARN_NUM best12. ;

240 format EIP_UNEARN_VAL best12. ;

241 format PENSION_VALUE_TOT best12. ;

242 format PENSION_PYMTS_TOT best12. ;

243 format DEFER_CONTRIB_EXEC_TOT best12. ;

244 format DEFER_CONTRIB_CO_TOT best12. ;

245 format DEFER_EARNINGS_TOT best12. ;

246 format DEFER_WITHDR_TOT best12. ;

247 format DEFER_BALANCE_TOT best12. ;

248 format DEFER_RPT_AS_COMP_TOT best12. ;

249 format EXECRANKANN best12. ;

250 format OTHANN $1. ;

251 format TDC1 best12. ;

252 format TDC2 best12. ;

253 format RSTKGRNT $1. ;

254 format OPTION_AWARDS_BLK_VALUE $1. ;

255 format OPTION_AWARDS_RPT_VALUE $1. ;

256 format LTIP $1. ;

257 format ALLOTHTOT $1. ;

258 format ALLOTHPD $1. ;

259 format SAL_PCT best12. ;

260 format TOTAL_CURR_PCT best12. ;

261 format TOTAL_SEC_PCT best12. ;

262 format TOTAL_ALT1_PCT best12. ;

263 format TOTAL_ALT2_PCT best12. ;

264 format TDC1_PCT best12. ;

265 format TDC2_PCT best12. ;

266 format RET_YRS $1. ;

267 format COMMENT $1. ;

268 format GVKEY best12. ;

269 format EXECID best12. ;

270 format YEAR best12. ;

271 format RSTKVYRS $1. ;

272 format BECAMECEO best12. ;

273 format JOINED_CO $1. ;

274 format REJOIN $1. ;

275 format LEFTOFC $1. ;

276 format LEFTCO $1. ;

277 format RELEFT $1. ;

278 format PCEO $3. ;

279 format PCFO $3. ;

280 format TITLE $55. ;

281 format REASON $1. ;

282 format EXEC_LNAME $9. ;

283 format EXEC_FNAME $7. ;

284 format EXEC_MNAME $2. ;

285 format GENDER $4. ;

286 format NAMEPREFIX $3. ;

287 format PAGE best12. ;

288 format CUSIP best12. ;

289 format EXCHANGE $3. ;

290 format ADDRESS $41. ;

291 format CITY $9. ;

292 format STATE $2. ;

293 format ZIP best12. ;

294 format TELE $12. ;

295 format SICDESC $28. ;

296 format NAICSDESC $50. ;

297 format INDDESC $19. ;

298 format SPCODE $2. ;

299 format TICKER $3. ;

300 format SUB_TELE best12. ;

301 format NAICS best12. ;

302 format SPINDEX best12. ;

303 format SIC best12. ;

304 input

305 EXEC_FULLNAME $

306 CFOANN $

307 EXECDIR

308 OLD_DATAFMT_FLAG

309 INTERLOCK

310 REPRICE

311 EXECRANK

312 CO_PER_ROL

313 CONAME $

314 TITLEANN $

315 CEOANN $

316 SALARY

317 BONUS

318 STOCK_AWARDS

319 OPTION_AWARDS

320 NONEQ_INCENT

321 PENSION_CHG

322 OTHCOMP

323 TOTAL_SEC

324 TOTAL_CURR

325 TOTAL_ALT1

326 TOTAL_ALT2

327 TERM_PYMT

328 CHG_CTRL_PYMT

329 SHROWN_TOT

330 SHROWN_TOT_PCT

331 SHROWN_EXCL_OPTS

332 SHROWN_EXCL_OPTS_PCT

333 OPT_EXER_NUM

334 OPT_EXER_VAL

335 SHRS_VEST_NUM

336 SHRS_VEST_VAL

337 AGE

338 OPTION_AWARDS_NUM

339 OPTION_AWARDS_FV

340 STOCK_AWARDS_FV

341 OPT_UNEX_EXER_NUM

342 OPT_UNEX_UNEXER_NUM

343 OPT_UNEX_EXER_EST_VAL

344 OPT_UNEX_UNEXER_EST_VAL

345 STOCK_UNVEST_NUM

346 STOCK_UNVEST_VAL

347 EIP_UNEARN_NUM

348 EIP_UNEARN_VAL

349 PENSION_VALUE_TOT

350 PENSION_PYMTS_TOT

351 DEFER_CONTRIB_EXEC_TOT

352 DEFER_CONTRIB_CO_TOT

353 DEFER_EARNINGS_TOT

354 DEFER_WITHDR_TOT

355 DEFER_BALANCE_TOT

356 DEFER_RPT_AS_COMP_TOT

357 EXECRANKANN

358 OTHANN $

359 TDC1

360 TDC2

361 RSTKGRNT $

362 OPTION_AWARDS_BLK_VALUE $

363 OPTION_AWARDS_RPT_VALUE $

364 LTIP $

365 ALLOTHTOT $

366 ALLOTHPD $

367 SAL_PCT

368 TOTAL_CURR_PCT

369 TOTAL_SEC_PCT

370 TOTAL_ALT1_PCT

371 TOTAL_ALT2_PCT

372 TDC1_PCT

373 TDC2_PCT

374 RET_YRS $

375 COMMENT $

376 GVKEY

377 EXECID

378 YEAR

379 RSTKVYRS $

380 BECAMECEO

381 JOINED_CO $

382 REJOIN $

383 LEFTOFC $

384 LEFTCO $

385 RELEFT $

386 PCEO $

387 PCFO $

388 TITLE $

389 REASON $

390 EXEC_LNAME $

391 EXEC_FNAME $

392 EXEC_MNAME $

393 GENDER $

394 NAMEPREFIX $

395 PAGE

396 CUSIP

397 EXCHANGE $

398 ADDRESS $

399 CITY $

400 STATE $

401 ZIP

402 TELE $

403 SICDESC $

404 NAICSDESC $

405 INDDESC $

406 SPCODE $

407 TICKER $

408 SUB_TELE

409 NAICS

410 SPINDEX

411 SIC

412 ;

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

414 run;

NOTE: The infile '~/425/425_Final_Paper/CompuStat_Execucomp.csv' is:

Filename=/home/apmorabito0/425/425_Final_Paper/CompuStat_Execucomp.csv,

Owner Name=apmorabito0,Group Name=oda,

Access Permission=-rw-r--r--,

Last Modified=03Mar2018:02:40:25,

File Size (bytes)=50937550

NOTE: Invalid data for CUSIP in line 46 513-520.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

46 Gerard J. Arpey,,1,0,0,0,,14221,AMERICAN AIRLINES GROUP INC,Chairman and Chief Executive Officer,CEO

101 ,669.646,0,3280.68,1185.94,0.467,721.282,94.66,5952.675,669.646,5952.675,1808.393,12991.194,30112.79

201 4,2455.718,,2455.718,,0,0,43.75,322.338,51,301,1185.94,3280.68,737,819.2,245.804,1217.996,835.54,650

301 8.857,856,6668.24,4711.65,0,0,0,0,0,0,0,1,,5231.393,4045.453,,,,,,,0,0,5.713,5.713,-15.069,10.77,7.4

401 45,,,1045,14591,2010,,20030425,,,20111128,,,,,Chairman and Chief Executive Officer,,Arpey,Gerard,J.,

501 MALE,Mr.,58,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT,

601 SCHEDULED",Scheduled Passenger Air Transportation,Airlines,SP,AAL,817,481111,2030,4512 687

EXEC_FULLNAME=Gerard J. Arpey CFOANN= EXECDIR=1 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=14221

CONAME=AMERICAN TITLEANN=Chairman and Chief Executive Officer CEOANN=CEO SALARY=669.646 BONUS=0 STOCK_AWARDS=3280.68

OPTION_AWARDS=1185.94 NONEQ_INCENT=0.467 PENSION_CHG=721.282 OTHCOMP=94.66 TOTAL_SEC=5952.675 TOTAL_CURR=669.646 TOTAL_ALT1=5952.675

TOTAL_ALT2=1808.393 TERM_PYMT=12991.194 CHG_CTRL_PYMT=30112.794 SHROWN_TOT=2455.718 SHROWN_TOT_PCT=. SHROWN_EXCL_OPTS=2455.718

SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=43.75 SHRS_VEST_VAL=322.338 AGE=51 OPTION_AWARDS_NUM=301

OPTION_AWARDS_FV=1185.94 STOCK_AWARDS_FV=3280.68 OPT_UNEX_EXER_NUM=737 OPT_UNEX_UNEXER_NUM=819.2 OPT_UNEX_EXER_EST_VAL=245.804

OPT_UNEX_UNEXER_EST_VAL=1217.996 STOCK_UNVEST_NUM=835.54 STOCK_UNVEST_VAL=6508.857 EIP_UNEARN_NUM=856 EIP_UNEARN_VAL=6668.24

PENSION_VALUE_TOT=4711.65 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0

DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=1 OTHANN= TDC1=5231.393 TDC2=4045.453 RSTKGRNT=

OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=0 TOTAL_CURR_PCT=0 TOTAL_SEC_PCT=5.713

TOTAL_ALT1_PCT=5.713 TOTAL_ALT2_PCT=-15.069 TDC1_PCT=10.77 TDC2_PCT=7.445 RET_YRS= COMMENT= GVKEY=1045 EXECID=14591 YEAR=2010

RSTKVYRS= BECAMECEO=20030425 JOINED_CO= REJOIN= LEFTOFC=2 LEFTCO= RELEFT= PCEO= PCFO=

TITLE=Chairman and Chief Executive Officer REASON= EXEC_LNAME=Arpey EXEC_FNAME=Gerard EXEC_MNAME=J. GENDER=MALE NAMEPREFIX=Mr.

PAGE=58 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=45

NOTE: Invalid data for CUSIP in line 47 727-734.

47 Daniel P. Garton,,0,0,0,0,,16477,AMERICAN AIRLINES GROUP INC,"Executive Vice President of Marketing,

101 Chief Executive Officer of American Eagle Airlines, President of American Eagle Airlines and Execut

201 ive Vice President of Marketing at American Airlines Inc",,530.478,0,1353.982,458.222,0.25,535.95,29

301 .208,2908.09,530.478,2908.09,1270.619,7157.058,12242.437,873.324,,873.324,,0,0,23.7,174.733,52,116.3

401 ,458.222,1353.982,351.39,320.93,95.094,471.091,433.061,3373.545,239.25,1863.758,3786.516,0,0,0,0,0,0

501 ,0,4,,2372.14,1913.918,,,,,,,0,0,1.883,1.883,-17.546,9.762,6.881,,,1045,16654,2010,,,,,,,,,,Executiv

601 e Vice President of Marketing and Executive Vice President of Marketing - American Airlines Inc,,Gar

701 ton,Daniel,P.,MALE,Mr.,59,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth,TX,76155,817-963-1234,"

801 AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transportation,Airlines,SP,AAL,817,481111,2030,451

901 2 901

EXEC_FULLNAME=Daniel P. Garton CFOANN= EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=16477

CONAME=AMERICAN TITLEANN=Executive Vice President of Marketing, Chief Executive Officer of American Eagle CEOANN= SALARY=530.478

BONUS=0 STOCK_AWARDS=1353.982 OPTION_AWARDS=458.222 NONEQ_INCENT=0.25 PENSION_CHG=535.95 OTHCOMP=29.208 TOTAL_SEC=2908.09

TOTAL_CURR=530.478 TOTAL_ALT1=2908.09 TOTAL_ALT2=1270.619 TERM_PYMT=7157.058 CHG_CTRL_PYMT=12242.437 SHROWN_TOT=873.324

SHROWN_TOT_PCT=. SHROWN_EXCL_OPTS=873.324 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=23.7

SHRS_VEST_VAL=174.733 AGE=52 OPTION_AWARDS_NUM=116.3 OPTION_AWARDS_FV=458.222 STOCK_AWARDS_FV=1353.982 OPT_UNEX_EXER_NUM=351.39

OPT_UNEX_UNEXER_NUM=320.93 OPT_UNEX_EXER_EST_VAL=95.094 OPT_UNEX_UNEXER_EST_VAL=471.091 STOCK_UNVEST_NUM=433.061

STOCK_UNVEST_VAL=3373.545 EIP_UNEARN_NUM=239.25 EIP_UNEARN_VAL=1863.758 PENSION_VALUE_TOT=3786.516 PENSION_PYMTS_TOT=0

DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0

EXECRANKANN=4 OTHANN= TDC1=2372.14 TDC2=1913.918 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT=

ALLOTHPD= SAL_PCT=0 TOTAL_CURR_PCT=0 TOTAL_SEC_PCT=1.883 TOTAL_ALT1_PCT=1.883 TOTAL_ALT2_PCT=-17.546 TDC1_PCT=9.762 TDC2_PCT=6.881

RET_YRS= COMMENT= GVKEY=1045 EXECID=16654 YEAR=2010 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO=

PCFO= TITLE=Executive Vice President of Marketing and Executive Vic REASON= EXEC_LNAME=Garton EXEC_FNAME=Daniel EXEC_MNAME=P.

GENDER=MALE NAMEPREFIX=Mr. PAGE=59 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155

TELE=817-963-1234 SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP

TICKER=AAL SUB_TELE=817 NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=46

NOTE: Invalid data for CUSIP in line 48 871-878.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

48 "Gary F. Kennedy, Esq.",,0,0,0,0,,29348,AMERICAN AIRLINES GROUP INC,"Chief Compliance Officer, Senio

101 r Vice President, General Counsel, Chief Compliance Officer of American Airlines Inc, Senior Vice Pr

201 esident of American Airlines Inc and General Counsel of American Airlines Inc",,502.543,0,912.643,32

301 9.848,0.467,403.457,30.568,2179.526,502.543,2179.526,1023.816,4849.281,10824.533,403.31,,403.31,,0,0

401 ,11.65,86.781,55,83.2,329.848,912.643,195.81,199.69,81.329,277.24,221.76,1727.512,150.8,1174.733,286

501 9.992,0,0,0,0,0,0,0,5,,1776.069,1446.221,,,,,,,2.844,2.844,14.615,14.615,-13.977,28.245,23.192,,,104

601 5,28279,2010,,,,,,,,,,"Chief Compliance officer, Senior Vice President, General Counsel, Chief Compl

701 iance officer of American Airlines Inc, Senior Vice President of American Airlines Inc and General C

801 ounsel of American Airlines Inc",,"Kennedy, Esq.",Gary,F.,MALE,Mr.,62,02376R10,NAS,4333 Amon Carter

901 Boulevard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transp

1001 ortation,Airlines,SP,AAL,817,481111,2030,4512 1045

EXEC_FULLNAME=Gary F. Kennedy, Esq CFOANN= EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=29348

CONAME=AMERICAN TITLEANN=Chief Compliance Officer, Senior Vice President, General Counsel, Chief Complianc CEOANN= SALARY=502.543

BONUS=0 STOCK_AWARDS=912.643 OPTION_AWARDS=329.848 NONEQ_INCENT=0.467 PENSION_CHG=403.457 OTHCOMP=30.568 TOTAL_SEC=2179.526

TOTAL_CURR=502.543 TOTAL_ALT1=2179.526 TOTAL_ALT2=1023.816 TERM_PYMT=4849.281 CHG_CTRL_PYMT=10824.533 SHROWN_TOT=403.31

SHROWN_TOT_PCT=. SHROWN_EXCL_OPTS=403.31 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=11.65

SHRS_VEST_VAL=86.781 AGE=55 OPTION_AWARDS_NUM=83.2 OPTION_AWARDS_FV=329.848 STOCK_AWARDS_FV=912.643 OPT_UNEX_EXER_NUM=195.81

OPT_UNEX_UNEXER_NUM=199.69 OPT_UNEX_EXER_EST_VAL=81.329 OPT_UNEX_UNEXER_EST_VAL=277.24 STOCK_UNVEST_NUM=221.76

STOCK_UNVEST_VAL=1727.512 EIP_UNEARN_NUM=150.8 EIP_UNEARN_VAL=1174.733 PENSION_VALUE_TOT=2869.992 PENSION_PYMTS_TOT=0

DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0

EXECRANKANN=5 OTHANN= TDC1=1776.069 TDC2=1446.221 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT=

ALLOTHPD= SAL_PCT=2.844 TOTAL_CURR_PCT=2.844 TOTAL_SEC_PCT=14.615 TOTAL_ALT1_PCT=14.615 TOTAL_ALT2_PCT=-13.977 TDC1_PCT=28.245

TDC2_PCT=23.192 RET_YRS= COMMENT= GVKEY=1045 EXECID=28279 YEAR=2010 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO=

RELEFT= PCEO= PCFO= TITLE=Chief Compliance officer, Senior Vice President, Genera REASON= EXEC_LNAME=Kennedy, EXEC_FNAME=Gary

EXEC_MNAME=F. GENDER=MALE NAMEPREFIX=Mr. PAGE=62 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX

ZIP=76155 TELE=817-963-1234 SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines

SPCODE=SP TICKER=AAL SUB_TELE=817 NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=47

NOTE: Invalid data for CUSIP in line 49 654-661.

49 Robert William Reding,,0,0,0,0,,29349,AMERICAN AIRLINES GROUP INC,Executive Vice President of Operat

101 ions and Executive Vice President of Operations at American Airlines Inc,,530.479,0,1266.357,458.222

201 ,0.467,465.173,33.383,2754.081,530.479,2754.081,1181.375,4640.965,13405.938,805.884,,805.884,,0,0,20

301 .5,151.873,60,116.3,458.222,1266.357,255.81,317.59,107.994,471.091,293.75,2288.313,239.25,1863.758,2

401 191.653,0,0,0,0,0,0,0,3,,2288.908,1830.686,,,,,,,0,0,6.397,6.397,-3.412,9.942,6.966,,,1045,28280,201

501 0,,,,,,,,,,Executive Vice President of Operations and Executive Vice President of Operations at Amer

601 ican Airlines Inc,,Reding,Robert,William,MALE,Mr.,67,02376R10,NAS,4333 Amon Carter Boulevard,Fort Wo

701 rth,TX,76155,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transportation,Airlines

801 ,SP,AAL,817,481111,2030,4512 828

EXEC_FULLNAME=Robert William Redin CFOANN= EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=29349

CONAME=AMERICAN TITLEANN=Executive Vice President of Operations and Executive Vice President of Operations CEOANN= SALARY=530.479

BONUS=0 STOCK_AWARDS=1266.357 OPTION_AWARDS=458.222 NONEQ_INCENT=0.467 PENSION_CHG=465.173 OTHCOMP=33.383 TOTAL_SEC=2754.081

TOTAL_CURR=530.479 TOTAL_ALT1=2754.081 TOTAL_ALT2=1181.375 TERM_PYMT=4640.965 CHG_CTRL_PYMT=13405.938 SHROWN_TOT=805.884

SHROWN_TOT_PCT=. SHROWN_EXCL_OPTS=805.884 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=20.5

SHRS_VEST_VAL=151.873 AGE=60 OPTION_AWARDS_NUM=116.3 OPTION_AWARDS_FV=458.222 STOCK_AWARDS_FV=1266.357 OPT_UNEX_EXER_NUM=255.81

OPT_UNEX_UNEXER_NUM=317.59 OPT_UNEX_EXER_EST_VAL=107.994 OPT_UNEX_UNEXER_EST_VAL=471.091 STOCK_UNVEST_NUM=293.75

STOCK_UNVEST_VAL=2288.313 EIP_UNEARN_NUM=239.25 EIP_UNEARN_VAL=1863.758 PENSION_VALUE_TOT=2191.653 PENSION_PYMTS_TOT=0

DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0

EXECRANKANN=3 OTHANN= TDC1=2288.908 TDC2=1830.686 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT=

ALLOTHPD= SAL_PCT=0 TOTAL_CURR_PCT=0 TOTAL_SEC_PCT=6.397 TOTAL_ALT1_PCT=6.397 TOTAL_ALT2_PCT=-3.412 TDC1_PCT=9.942 TDC2_PCT=6.966

RET_YRS= COMMENT= GVKEY=1045 EXECID=28280 YEAR=2010 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO=

PCFO= TITLE=Executive Vice President of Operations and Executive Vi REASON= EXEC_LNAME=Reding EXEC_FNAME=Robert EXEC_MNAME=Wi

GENDER=MALE NAMEPREFIX=Mr. PAGE=67 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155

TELE=817-963-1234 SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP

TICKER=AAL SUB_TELE=817 NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=48

NOTE: Invalid data for CUSIP in line 50 551-558.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

50 Thomas W. Horton,CFO,1,0,0,0,,33126,AMERICAN AIRLINES GROUP INC,President and President of American

101 Airlines Inc,,618.135,0,1831.548,661.628,0.467,553.539,30.304,3695.621,618.135,3695.621,1355.13,1063

201 8.058,15893.916,977.058,,977.058,,0,0,20.5,152.685,49,166.4,661.628,1831.548,172.43,382.87,95.094,49

301 7.644,328.7,2560.574,282.15,2197.949,3539.154,0,0,0,0,0,0,0,2,,3142.082,2480.454,,,,,,,0,0,21.674,21

401 .674,-24.161,44.956,38.022,,,1045,26059,2010,,20111128,,,20131209,,,,,"Chairman, Chief Executive Off

501 icer and President",,Horton,Thomas,W.,MALE,Mr.,56,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth

601 ,TX,76155,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transportation,Airlines,SP

701 ,AAL,817,481111,2030,4512 725

EXEC_FULLNAME=Thomas W. Horton CFOANN=CFO EXECDIR=1 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=33126

CONAME=AMERICAN TITLEANN=President and President of American Airlines Inc CEOANN= SALARY=618.135 BONUS=0 STOCK_AWARDS=1831.548

OPTION_AWARDS=661.628 NONEQ_INCENT=0.467 PENSION_CHG=553.539 OTHCOMP=30.304 TOTAL_SEC=3695.621 TOTAL_CURR=618.135

TOTAL_ALT1=3695.621 TOTAL_ALT2=1355.13 TERM_PYMT=10638.058 CHG_CTRL_PYMT=15893.916 SHROWN_TOT=977.058 SHROWN_TOT_PCT=.

SHROWN_EXCL_OPTS=977.058 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=20.5 SHRS_VEST_VAL=152.685 AGE=49

OPTION_AWARDS_NUM=166.4 OPTION_AWARDS_FV=661.628 STOCK_AWARDS_FV=1831.548 OPT_UNEX_EXER_NUM=172.43 OPT_UNEX_UNEXER_NUM=382.87

OPT_UNEX_EXER_EST_VAL=95.094 OPT_UNEX_UNEXER_EST_VAL=497.644 STOCK_UNVEST_NUM=328.7 STOCK_UNVEST_VAL=2560.574 EIP_UNEARN_NUM=282.15

EIP_UNEARN_VAL=2197.949 PENSION_VALUE_TOT=3539.154 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0

DEFER_EARNINGS_TOT=0 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=2 OTHANN= TDC1=3142.082

TDC2=2480.454 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=0

TOTAL_CURR_PCT=0 TOTAL_SEC_PCT=21.674 TOTAL_ALT1_PCT=21.674 TOTAL_ALT2_PCT=-24.161 TDC1_PCT=44.956 TDC2_PCT=38.022 RET_YRS=

COMMENT= GVKEY=1045 EXECID=26059 YEAR=2010 RSTKVYRS= BECAMECEO=20111128 JOINED_CO= REJOIN= LEFTOFC=2 LEFTCO= RELEFT= PCEO=

PCFO= TITLE=Chairman, Chief Executive Officer and President REASON= EXEC_LNAME=Horton EXEC_FNAME=Thomas EXEC_MNAME=W. GENDER=MALE

NAMEPREFIX=Mr. PAGE=56 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=49

NOTE: Invalid data for CUSIP in line 51 560-567.

51 Isabella D. Goren,,0,0,0,0,,43629,AMERICAN AIRLINES GROUP INC,"Chief Financial Officer, Principal Ac

101 counting Officer and Senior Vice President",,423.993,0,912.643,329.848,0.467,316.129,28.57,2011.65,

201 423.993,2011.65,855.94,3322.171,6701.804,500.202,,500.202,,0,0,11.65,86.781,49,83.2,329.848,912.643,

301 170.01,201.99,54.149,277.24,200.43,1561.352,150.8,1174.733,1584.237,0,0,0,0,0,0,0,6,,1695.521,1365.6

401 73,,,,,,,,,,,,,,,,1045,41119,2010,,,,,,,,,,"Chief Financial Officer, Principal Accounting Officer a

501 nd Senior Vice President",,Goren,Isabella,D.,FEMALE,Ms.,56,02376R10,NAS,4333 Amon Carter Boulevard,F

601 ort Worth,TX,76155,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transportation,Ai

701 rlines,SP,AAL,817,481111,2030,4512 734

EXEC_FULLNAME=Isabella D. Goren CFOANN= EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=43629

CONAME=AMERICAN TITLEANN=Chief Financial Officer, Principal Accounting Officer and Senior Vice President CEOANN= SALARY=423.993

BONUS=0 STOCK_AWARDS=912.643 OPTION_AWARDS=329.848 NONEQ_INCENT=0.467 PENSION_CHG=316.129 OTHCOMP=28.57 TOTAL_SEC=2011.65

TOTAL_CURR=423.993 TOTAL_ALT1=2011.65 TOTAL_ALT2=855.94 TERM_PYMT=3322.171 CHG_CTRL_PYMT=6701.804 SHROWN_TOT=500.202

SHROWN_TOT_PCT=. SHROWN_EXCL_OPTS=500.202 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=11.65

SHRS_VEST_VAL=86.781 AGE=49 OPTION_AWARDS_NUM=83.2 OPTION_AWARDS_FV=329.848 STOCK_AWARDS_FV=912.643 OPT_UNEX_EXER_NUM=170.01

OPT_UNEX_UNEXER_NUM=201.99 OPT_UNEX_EXER_EST_VAL=54.149 OPT_UNEX_UNEXER_EST_VAL=277.24 STOCK_UNVEST_NUM=200.43

STOCK_UNVEST_VAL=1561.352 EIP_UNEARN_NUM=150.8 EIP_UNEARN_VAL=1174.733 PENSION_VALUE_TOT=1584.237 PENSION_PYMTS_TOT=0

DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0

EXECRANKANN=6 OTHANN= TDC1=1695.521 TDC2=1365.673 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT=

ALLOTHPD= SAL_PCT=. TOTAL_CURR_PCT=. TOTAL_SEC_PCT=. TOTAL_ALT1_PCT=. TOTAL_ALT2_PCT=. TDC1_PCT=. TDC2_PCT=. RET_YRS= COMMENT=

GVKEY=1045 EXECID=41119 YEAR=2010 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO= PCFO=

TITLE=Chief Financial Officer, Principal Accounting Officer REASON= EXEC_LNAME=Goren EXEC_FNAME=Isabell EXEC_MNAME=D. GENDER=FEMA

NAMEPREFIX=Ms. PAGE=56 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=50

NOTE: Invalid data for CUSIP in line 52 453-460.

52 Gerard J. Arpey,,1,0,0,0,,14221,AMERICAN AIRLINES GROUP INC,Chairman and Chief Executive Officer,CEO

101 ,613.842,0,4020.38,798.6,0.017,2055.707,93.996,7582.542,613.842,7582.542,4184.722,0,0,0,,0,0,0,0,231

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

201 ,1421.16,52,220,798.6,4020.38,0,0,0,0,0,0,0,0,6767.357,0,0,0,0,0,0,0,2,,5526.835,4728.235,,,,,,,-8.3

301 33,-8.333,27.38,27.38,131.406,5.647,16.878,,,1045,14591,2011,,20030425,,,20111128,,,,,Chairman and C

401 hief Executive Officer,,Arpey,Gerard,J.,MALE,Mr.,58,02376R10,NAS,4333 Amon Carter Boulevard,Fort Wor

501 th,TX,76155,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transportation,Airlines,

601 SP,AAL,817,481111,2030,4512 627

EXEC_FULLNAME=Gerard J. Arpey CFOANN= EXECDIR=1 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=14221

CONAME=AMERICAN TITLEANN=Chairman and Chief Executive Officer CEOANN=CEO SALARY=613.842 BONUS=0 STOCK_AWARDS=4020.38

OPTION_AWARDS=798.6 NONEQ_INCENT=0.017 PENSION_CHG=2055.707 OTHCOMP=93.996 TOTAL_SEC=7582.542 TOTAL_CURR=613.842 TOTAL_ALT1=7582.542

TOTAL_ALT2=4184.722 TERM_PYMT=0 CHG_CTRL_PYMT=0 SHROWN_TOT=0 SHROWN_TOT_PCT=. SHROWN_EXCL_OPTS=0 SHROWN_EXCL_OPTS_PCT=0

OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=231 SHRS_VEST_VAL=1421.16 AGE=52 OPTION_AWARDS_NUM=220 OPTION_AWARDS_FV=798.6

STOCK_AWARDS_FV=4020.38 OPT_UNEX_EXER_NUM=0 OPT_UNEX_UNEXER_NUM=0 OPT_UNEX_EXER_EST_VAL=0 OPT_UNEX_UNEXER_EST_VAL=0

STOCK_UNVEST_NUM=0 STOCK_UNVEST_VAL=0 EIP_UNEARN_NUM=0 EIP_UNEARN_VAL=0 PENSION_VALUE_TOT=6767.357 PENSION_PYMTS_TOT=0

DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0

EXECRANKANN=2 OTHANN= TDC1=5526.835 TDC2=4728.235 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT=

ALLOTHPD= SAL_PCT=-8.333 TOTAL_CURR_PCT=-8.333 TOTAL_SEC_PCT=27.38 TOTAL_ALT1_PCT=27.38 TOTAL_ALT2_PCT=131.406 TDC1_PCT=5.647

TDC2_PCT=16.878 RET_YRS= COMMENT= GVKEY=1045 EXECID=14591 YEAR=2011 RSTKVYRS= BECAMECEO=20030425 JOINED_CO= REJOIN= LEFTOFC=2

LEFTCO= RELEFT= PCEO= PCFO= TITLE=Chairman and Chief Executive Officer REASON= EXEC_LNAME=Arpey EXEC_FNAME=Gerard EXEC_MNAME=J.

GENDER=MALE NAMEPREFIX=Mr. PAGE=58 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155

TELE=817-963-1234 SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP

TICKER=AAL SUB_TELE=817 NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=51

NOTE: Invalid data for CUSIP in line 53 714-721.

53 Daniel P. Garton,,0,0,0,0,,16477,AMERICAN AIRLINES GROUP INC,"Executive Vice President of Marketing,

101 Chief Executive Officer of American Eagle Airlines, President of American Eagle Airlines and Execut

201 ive Vice President of Marketing at American Airlines Inc",,530.478,0,1639.078,308.187,0,892.917,31.7

301 08,3402.368,530.478,3402.368,2123.232,5367.376,5116.821,357.093,,60.503,,0,0,108.59,668.129,53,84.9,

401 308.187,1639.078,380.59,316.63,0,0,551.241,192.935,205.7,71.996,4679.433,0,0,0,0,0,0,0,4,,2509.451,2

501 201.264,,,,,,,0,0,16.997,16.997,67.102,5.788,15.013,,,1045,16654,2011,,,,,,,,,,Executive Vice Presid

601 ent of Marketing and Executive Vice President of Marketing - American Airlines Inc,,Garton,Daniel,P.

701 ,MALE,Mr.,59,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT

801 , SCHEDULED",Scheduled Passenger Air Transportation,Airlines,SP,AAL,817,481111,2030,4512 888

EXEC_FULLNAME=Daniel P. Garton CFOANN= EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=16477

CONAME=AMERICAN TITLEANN=Executive Vice President of Marketing, Chief Executive Officer of American Eagle CEOANN= SALARY=530.478

BONUS=0 STOCK_AWARDS=1639.078 OPTION_AWARDS=308.187 NONEQ_INCENT=0 PENSION_CHG=892.917 OTHCOMP=31.708 TOTAL_SEC=3402.368

TOTAL_CURR=530.478 TOTAL_ALT1=3402.368 TOTAL_ALT2=2123.232 TERM_PYMT=5367.376 CHG_CTRL_PYMT=5116.821 SHROWN_TOT=357.093

SHROWN_TOT_PCT=. SHROWN_EXCL_OPTS=60.503 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=108.59

SHRS_VEST_VAL=668.129 AGE=53 OPTION_AWARDS_NUM=84.9 OPTION_AWARDS_FV=308.187 STOCK_AWARDS_FV=1639.078 OPT_UNEX_EXER_NUM=380.59

OPT_UNEX_UNEXER_NUM=316.63 OPT_UNEX_EXER_EST_VAL=0 OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=551.241 STOCK_UNVEST_VAL=192.935

EIP_UNEARN_NUM=205.7 EIP_UNEARN_VAL=71.996 PENSION_VALUE_TOT=4679.433 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0

DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=4 OTHANN=

TDC1=2509.451 TDC2=2201.264 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=0

TOTAL_CURR_PCT=0 TOTAL_SEC_PCT=16.997 TOTAL_ALT1_PCT=16.997 TOTAL_ALT2_PCT=67.102 TDC1_PCT=5.788 TDC2_PCT=15.013 RET_YRS= COMMENT=

GVKEY=1045 EXECID=16654 YEAR=2011 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO= PCFO=

TITLE=Executive Vice President of Marketing and Executive Vic REASON= EXEC_LNAME=Garton EXEC_FNAME=Daniel EXEC_MNAME=P. GENDER=MALE

NAMEPREFIX=Mr. PAGE=59 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=52

NOTE: Invalid data for CUSIP in line 54 844-851.

54 "Gary F. Kennedy, Esq.",,0,0,0,0,,29348,AMERICAN AIRLINES GROUP INC,"General Counsel of American Air

101 lines Inc, Chief Compliance officer of American Airlines Inc, Senior Vice President, Senior Vice Pre

201 sident of American Airlines Inc, General Counsel and Chief Compliance officer",,522,0,883.694,175.51

301 1,0.083,682.007,29.894,2293.189,522,2293.189,1577.577,4640.721,8121.918,243.378,,41.408,,0,0,56.3,34

401 3.593,56,48.35,175.511,883.694,229.97,193.88,0,0,287.04,100.466,131.7,46.096,3552,0,0,0,0,0,0,0,5,,1

501 611.182,1435.671,,,,,,,3.872,3.872,5.215,5.215,54.088,-9.284,-0.729,,,1045,28279,2011,,,,,,,,,,"Chie

601 f Compliance officer, Senior Vice President, General Counsel, Chief Compliance officer of American A

701 irlines Inc, Senior Vice President of American Airlines Inc and General Counsel of American Airlines

801 Inc",,"Kennedy, Esq.",Gary,F.,MALE,Mr.,62,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth,TX,761

901 55,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transportation,Airlines,SP,AAL,81

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

1001 7,481111,2030,4512 1018

EXEC_FULLNAME=Gary F. Kennedy, Esq CFOANN= EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=29348

CONAME=AMERICAN TITLEANN=General Counsel of American Airlines Inc, Chief Compliance officer of American Ai CEOANN= SALARY=522

BONUS=0 STOCK_AWARDS=883.694 OPTION_AWARDS=175.511 NONEQ_INCENT=0.083 PENSION_CHG=682.007 OTHCOMP=29.894 TOTAL_SEC=2293.189

TOTAL_CURR=522 TOTAL_ALT1=2293.189 TOTAL_ALT2=1577.577 TERM_PYMT=4640.721 CHG_CTRL_PYMT=8121.918 SHROWN_TOT=243.378 SHROWN_TOT_PCT=.

SHROWN_EXCL_OPTS=41.408 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=56.3 SHRS_VEST_VAL=343.593 AGE=56

OPTION_AWARDS_NUM=48.35 OPTION_AWARDS_FV=175.511 STOCK_AWARDS_FV=883.694 OPT_UNEX_EXER_NUM=229.97 OPT_UNEX_UNEXER_NUM=193.88

OPT_UNEX_EXER_EST_VAL=0 OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=287.04 STOCK_UNVEST_VAL=100.466 EIP_UNEARN_NUM=131.7

EIP_UNEARN_VAL=46.096 PENSION_VALUE_TOT=3552 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0

DEFER_EARNINGS_TOT=0 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=5 OTHANN= TDC1=1611.182

TDC2=1435.671 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=3.872

TOTAL_CURR_PCT=3.872 TOTAL_SEC_PCT=5.215 TOTAL_ALT1_PCT=5.215 TOTAL_ALT2_PCT=54.088 TDC1_PCT=-9.284 TDC2_PCT=-0.729 RET_YRS=

COMMENT= GVKEY=1045 EXECID=28279 YEAR=2011 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO= PCFO=

TITLE=Chief Compliance officer, Senior Vice President, Genera REASON= EXEC_LNAME=Kennedy, EXEC_FNAME=Gary EXEC_MNAME=F. GENDER=MALE

NAMEPREFIX=Mr. PAGE=62 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=53

NOTE: Invalid data for CUSIP in line 55 612-619.

55 Robert William Reding,,0,0,0,0,,29349,AMERICAN AIRLINES GROUP INC,Executive Vice President of Operat

101 ions and Executive Vice President of Operations at American Airlines Inc,,530.479,0,1551.564,308.187

201 ,0.083,1072.644,34.55,3497.507,530.479,3497.507,2241.017,0,0,0,,0,,0,0,98.85,603.261,61,84.9,308.187

301 ,1551.564,321.67,316.63,0,0,408.37,142.93,205.7,71.996,3258.949,0,0,0,0,0,0,0,3,,2424.863,2116.676,,

401 ,,,,,0,0,26.994,26.994,89.696,5.94,15.622,,,1045,28280,2011,,,,,,,,,,Executive Vice President of Ope

501 rations and Executive Vice President of Operations at American Airlines Inc,,Reding,Robert,William,M

601 ALE,Mr.,67,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT,

701 SCHEDULED",Scheduled Passenger Air Transportation,Airlines,SP,AAL,817,481111,2030,4512 786

EXEC_FULLNAME=Robert William Redin CFOANN= EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=29349

CONAME=AMERICAN TITLEANN=Executive Vice President of Operations and Executive Vice President of Operations CEOANN= SALARY=530.479

BONUS=0 STOCK_AWARDS=1551.564 OPTION_AWARDS=308.187 NONEQ_INCENT=0.083 PENSION_CHG=1072.644 OTHCOMP=34.55 TOTAL_SEC=3497.507

TOTAL_CURR=530.479 TOTAL_ALT1=3497.507 TOTAL_ALT2=2241.017 TERM_PYMT=0 CHG_CTRL_PYMT=0 SHROWN_TOT=0 SHROWN_TOT_PCT=.

SHROWN_EXCL_OPTS=0 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=98.85 SHRS_VEST_VAL=603.261 AGE=61

OPTION_AWARDS_NUM=84.9 OPTION_AWARDS_FV=308.187 STOCK_AWARDS_FV=1551.564 OPT_UNEX_EXER_NUM=321.67 OPT_UNEX_UNEXER_NUM=316.63

OPT_UNEX_EXER_EST_VAL=0 OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=408.37 STOCK_UNVEST_VAL=142.93 EIP_UNEARN_NUM=205.7

EIP_UNEARN_VAL=71.996 PENSION_VALUE_TOT=3258.949 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0

DEFER_EARNINGS_TOT=0 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=3 OTHANN= TDC1=2424.863

TDC2=2116.676 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=0

TOTAL_CURR_PCT=0 TOTAL_SEC_PCT=26.994 TOTAL_ALT1_PCT=26.994 TOTAL_ALT2_PCT=89.696 TDC1_PCT=5.94 TDC2_PCT=15.622 RET_YRS= COMMENT=

GVKEY=1045 EXECID=28280 YEAR=2011 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO= PCFO=

TITLE=Executive Vice President of Operations and Executive Vi REASON= EXEC_LNAME=Reding EXEC_FNAME=Robert EXEC_MNAME=Wi GENDER=MALE

NAMEPREFIX=Mr. PAGE=67 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=54

NOTE: Invalid data for CUSIP in line 56 568-575.

56 Thomas W. Horton,,1,0,0,0,,33126,AMERICAN AIRLINES GROUP INC,"Chairman, Chief Executive Officer, Pre

101 sident and President of American Airlines Inc",,618.135,0,2220.421,441.045,0.083,871.138,31.978,4182

201 .8,618.135,4182.8,2124.595,7347.255,13480.053,411.098,,172.608,,0,0,98.85,603.261,50,121.5,441.045,2

301 220.421,283.49,393.31,0,0,499.22,174.728,294.35,103.023,4410.359,0,0,0,0,0,0,0,1,,3311.662,2870.617,

401 ,,,,,,0,0,13.183,13.183,56.782,5.397,15.729,,,1045,26059,2011,,20111128,,,20131209,,,,,"Chairman, Ch

501 ief Executive Officer and President",,Horton,Thomas,W.,MALE,Mr.,56,02376R10,NAS,4333 Amon Carter Bou

601 levard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transport

701 ation,Airlines,SP,AAL,817,481111,2030,4512 742

EXEC_FULLNAME=Thomas W. Horton CFOANN= EXECDIR=1 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=33126

CONAME=AMERICAN TITLEANN=Chairman, Chief Executive Officer, President and President of American Airlines I CEOANN= SALARY=618.135

BONUS=0 STOCK_AWARDS=2220.421 OPTION_AWARDS=441.045 NONEQ_INCENT=0.083 PENSION_CHG=871.138 OTHCOMP=31.978 TOTAL_SEC=4182.8

TOTAL_CURR=618.135 TOTAL_ALT1=4182.8 TOTAL_ALT2=2124.595 TERM_PYMT=7347.255 CHG_CTRL_PYMT=13480.053 SHROWN_TOT=411.098

SHROWN_TOT_PCT=. SHROWN_EXCL_OPTS=172.608 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=98.85

SHRS_VEST_VAL=603.261 AGE=50 OPTION_AWARDS_NUM=121.5 OPTION_AWARDS_FV=441.045 STOCK_AWARDS_FV=2220.421 OPT_UNEX_EXER_NUM=283.49

OPT_UNEX_UNEXER_NUM=393.31 OPT_UNEX_EXER_EST_VAL=0 OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=499.22 STOCK_UNVEST_VAL=174.728

EIP_UNEARN_NUM=294.35 EIP_UNEARN_VAL=103.023 PENSION_VALUE_TOT=4410.359 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0

DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=1 OTHANN=

TDC1=3311.662 TDC2=2870.617 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=0

TOTAL_CURR_PCT=0 TOTAL_SEC_PCT=13.183 TOTAL_ALT1_PCT=13.183 TOTAL_ALT2_PCT=56.782 TDC1_PCT=5.397 TDC2_PCT=15.729 RET_YRS= COMMENT=

GVKEY=1045 EXECID=26059 YEAR=2011 RSTKVYRS= BECAMECEO=20111128 JOINED_CO= REJOIN= LEFTOFC=2 LEFTCO= RELEFT= PCEO= PCFO=

TITLE=Chairman, Chief Executive Officer and President REASON= EXEC_LNAME=Horton EXEC_FNAME=Thomas EXEC_MNAME=W. GENDER=MALE

NAMEPREFIX=Mr. PAGE=56 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=55

NOTE: Invalid data for CUSIP in line 57 591-598.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

57 Isabella D. Goren,CFO,0,0,0,0,,43629,AMERICAN AIRLINES GROUP INC,"Chief Financial Officer, Principal

101 Accounting Officer and Senior Vice President",,508.007,0,883.694,175.511,0.083,561.082,31.939,2160

201 .316,508.007,2160.316,1444.704,2768.121,6795.767,249.442,,70.972,,0,0,56.3,343.593,50,48.35,175.511,

301 883.694,206.47,193.88,0,0,265.71,93.001,131.7,46.096,2145.319,0,0,0,0,0,0,0,6,,1599.234,1423.723,,,,

401 ,,,19.815,19.815,7.39,7.39,68.786,-5.679,4.251,,,1045,41119,2011,,,,,,,,,,"Chief Financial Officer,

501 Principal Accounting Officer and Senior Vice President",,Goren,Isabella,D.,FEMALE,Ms.,56,02376R10,N

601 AS,4333 Amon Carter Boulevard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled

701 Passenger Air Transportation,Airlines,SP,AAL,817,481111,2030,4512 765

EXEC_FULLNAME=Isabella D. Goren CFOANN=CFO EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=43629

CONAME=AMERICAN TITLEANN=Chief Financial Officer, Principal Accounting Officer and Senior Vice President CEOANN= SALARY=508.007

BONUS=0 STOCK_AWARDS=883.694 OPTION_AWARDS=175.511 NONEQ_INCENT=0.083 PENSION_CHG=561.082 OTHCOMP=31.939 TOTAL_SEC=2160.316

TOTAL_CURR=508.007 TOTAL_ALT1=2160.316 TOTAL_ALT2=1444.704 TERM_PYMT=2768.121 CHG_CTRL_PYMT=6795.767 SHROWN_TOT=249.442

SHROWN_TOT_PCT=. SHROWN_EXCL_OPTS=70.972 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=56.3

SHRS_VEST_VAL=343.593 AGE=50 OPTION_AWARDS_NUM=48.35 OPTION_AWARDS_FV=175.511 STOCK_AWARDS_FV=883.694 OPT_UNEX_EXER_NUM=206.47

OPT_UNEX_UNEXER_NUM=193.88 OPT_UNEX_EXER_EST_VAL=0 OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=265.71 STOCK_UNVEST_VAL=93.001

EIP_UNEARN_NUM=131.7 EIP_UNEARN_VAL=46.096 PENSION_VALUE_TOT=2145.319 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0

DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=6 OTHANN=

TDC1=1599.234 TDC2=1423.723 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD=

SAL_PCT=19.815 TOTAL_CURR_PCT=19.815 TOTAL_SEC_PCT=7.39 TOTAL_ALT1_PCT=7.39 TOTAL_ALT2_PCT=68.786 TDC1_PCT=-5.679 TDC2_PCT=4.251

RET_YRS= COMMENT= GVKEY=1045 EXECID=41119 YEAR=2011 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO=

PCFO= TITLE=Chief Financial Officer, Principal Accounting Officer REASON= EXEC_LNAME=Goren EXEC_FNAME=Isabell EXEC_MNAME=D.

GENDER=FEMA NAMEPREFIX=Ms. PAGE=56 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155

TELE=817-963-1234 SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP

TICKER=AAL SUB_TELE=817 NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=56

NOTE: Invalid data for CUSIP in line 58 688-695.

58 Daniel P. Garton,,0,0,0,0,,16477,AMERICAN AIRLINES GROUP INC,"Executive Vice President of Marketing,

101 Chief Executive Officer of American Eagle Airlines, President of American Eagle Airlines and Execut

201 ive Vice President of Marketing at American Airlines Inc",,530.478,0,0,0,0,1112.837,34.282,1677.597,

301 530.478,1677.597,1788.749,7335.446,8812.908,670.724,,275.654,,0,0,215.151,111.152,54,0,0,0,395.07,21

401 8.15,0,0,395.82,316.656,106.15,84.92,5792.27,0,0,0,0,0,0,0,4,,564.76,564.76,,,,,,,0,0,-50.693,-50.69

501 3,-15.753,-77.495,-74.344,,,1045,16654,2012,,,,,,,,,,Executive Vice President of Marketing and Execu

601 tive Vice President of Marketing - American Airlines Inc,,Garton,Daniel,P.,MALE,Mr.,59,02376R10,NAS,

701 4333 Amon Carter Boulevard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Pas

801 senger Air Transportation,Airlines,SP,AAL,817,481111,2030,4512 862

EXEC_FULLNAME=Daniel P. Garton CFOANN= EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=16477

CONAME=AMERICAN TITLEANN=Executive Vice President of Marketing, Chief Executive Officer of American Eagle CEOANN= SALARY=530.478

BONUS=0 STOCK_AWARDS=0 OPTION_AWARDS=0 NONEQ_INCENT=0 PENSION_CHG=1112.837 OTHCOMP=34.282 TOTAL_SEC=1677.597 TOTAL_CURR=530.478

TOTAL_ALT1=1677.597 TOTAL_ALT2=1788.749 TERM_PYMT=7335.446 CHG_CTRL_PYMT=8812.908 SHROWN_TOT=670.724 SHROWN_TOT_PCT=.

SHROWN_EXCL_OPTS=275.654 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=215.151 SHRS_VEST_VAL=111.152 AGE=54

OPTION_AWARDS_NUM=0 OPTION_AWARDS_FV=0 STOCK_AWARDS_FV=0 OPT_UNEX_EXER_NUM=395.07 OPT_UNEX_UNEXER_NUM=218.15 OPT_UNEX_EXER_EST_VAL=0

OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=395.82 STOCK_UNVEST_VAL=316.656 EIP_UNEARN_NUM=106.15 EIP_UNEARN_VAL=84.92

PENSION_VALUE_TOT=5792.27 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0

DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=4 OTHANN= TDC1=564.76 TDC2=564.76 RSTKGRNT=

OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=0 TOTAL_CURR_PCT=0 TOTAL_SEC_PCT=-50.693

TOTAL_ALT1_PCT=-50.693 TOTAL_ALT2_PCT=-15.753 TDC1_PCT=-77.495 TDC2_PCT=-74.344 RET_YRS= COMMENT= GVKEY=1045 EXECID=16654

YEAR=2012 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO= PCFO=

TITLE=Executive Vice President of Marketing and Executive Vic REASON= EXEC_LNAME=Garton EXEC_FNAME=Daniel EXEC_MNAME=P. GENDER=MALE

NAMEPREFIX=Mr. PAGE=59 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=57

NOTE: Invalid data for CUSIP in line 59 811-818.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

59 "Gary F. Kennedy, Esq.",,0,0,0,0,,29348,AMERICAN AIRLINES GROUP INC,"Chief Compliance officer, Senio

101 r Vice President, General Counsel, Chief Compliance officer of American Airlines Inc, Senior Vice Pr

201 esident of American Airlines Inc and General Counsel of American Airlines Inc",,522,0,0,0,0.633,817.

301 644,37.414,1377.691,522,1377.691,1435.593,5361.03,9163.652,415.378,,153.938,,0,0,112.53,57.902,57,0,

401 0,0,261.44,134.41,0,0,217.26,173.808,60.45,48.36,4369.643,0,0,0,0,0,0,0,5,,560.047,560.047,,,,,,,0,0

501 ,-39.922,-39.922,-9,-65.24,-60.991,,,1045,28279,2012,,,,,,,,,,"Chief Compliance officer, Senior Vice

601 President, General Counsel, Chief Compliance officer of American Airlines Inc, Senior Vice Presiden

701 t of American Airlines Inc and General Counsel of American Airlines Inc",,"Kennedy, Esq.",Gary,F.,MA

801 LE,Mr.,62,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT, S

901 CHEDULED",Scheduled Passenger Air Transportation,Airlines,SP,AAL,817,481111,2030,4512 985

EXEC_FULLNAME=Gary F. Kennedy, Esq CFOANN= EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=29348

CONAME=AMERICAN TITLEANN=Chief Compliance officer, Senior Vice President, General Counsel, Chief Complianc CEOANN= SALARY=522

BONUS=0 STOCK_AWARDS=0 OPTION_AWARDS=0 NONEQ_INCENT=0.633 PENSION_CHG=817.644 OTHCOMP=37.414 TOTAL_SEC=1377.691 TOTAL_CURR=522

TOTAL_ALT1=1377.691 TOTAL_ALT2=1435.593 TERM_PYMT=5361.03 CHG_CTRL_PYMT=9163.652 SHROWN_TOT=415.378 SHROWN_TOT_PCT=.

SHROWN_EXCL_OPTS=153.938 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=112.53 SHRS_VEST_VAL=57.902 AGE=57

OPTION_AWARDS_NUM=0 OPTION_AWARDS_FV=0 STOCK_AWARDS_FV=0 OPT_UNEX_EXER_NUM=261.44 OPT_UNEX_UNEXER_NUM=134.41 OPT_UNEX_EXER_EST_VAL=0

OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=217.26 STOCK_UNVEST_VAL=173.808 EIP_UNEARN_NUM=60.45 EIP_UNEARN_VAL=48.36

PENSION_VALUE_TOT=4369.643 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0

DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=5 OTHANN= TDC1=560.047 TDC2=560.047 RSTKGRNT=

OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=0 TOTAL_CURR_PCT=0 TOTAL_SEC_PCT=-39.922

TOTAL_ALT1_PCT=-39.922 TOTAL_ALT2_PCT=-9 TDC1_PCT=-65.24 TDC2_PCT=-60.991 RET_YRS= COMMENT= GVKEY=1045 EXECID=28279 YEAR=2012

RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO= PCFO=

TITLE=Chief Compliance officer, Senior Vice President, Genera REASON= EXEC_LNAME=Kennedy, EXEC_FNAME=Gary EXEC_MNAME=F. GENDER=MALE

NAMEPREFIX=Mr. PAGE=62 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=58

NOTE: Invalid data for CUSIP in line 60 548-555.

60 Thomas W. Horton,,1,0,0,0,,33126,AMERICAN AIRLINES GROUP INC,"Chairman, Chief Executive Officer, Pre

101 sident and President of American Airlines Inc",CEO,618.135,0,0,0,0.633,1092.937,37.458,1749.163,618.

201 135,1749.163,1850.849,6437.627,15332.137,724.538,,325.228,,0,0,197.62,101.686,51,0,0,0,399.31,277.49

301 ,0,0,387.07,309.656,151.9,121.52,5503.296,0,0,0,0,0,0,0,1,,656.226,656.226,,,,,,,0,0,-58.182,-58.182

401 ,-12.885,-80.184,-77.14,,,1045,26059,2012,,20111128,,,20131209,,,,,"Chairman, Chief Executive Office

501 r and President",,Horton,Thomas,W.,MALE,Mr.,56,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth,TX

601 ,76155,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transportation,Airlines,SP,AA

701 L,817,481111,2030,4512 722

EXEC_FULLNAME=Thomas W. Horton CFOANN= EXECDIR=1 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=33126

CONAME=AMERICAN TITLEANN=Chairman, Chief Executive Officer, President and President of American Airlines I CEOANN=CEO SALARY=618.135

BONUS=0 STOCK_AWARDS=0 OPTION_AWARDS=0 NONEQ_INCENT=0.633 PENSION_CHG=1092.937 OTHCOMP=37.458 TOTAL_SEC=1749.163 TOTAL_CURR=618.135

TOTAL_ALT1=1749.163 TOTAL_ALT2=1850.849 TERM_PYMT=6437.627 CHG_CTRL_PYMT=15332.137 SHROWN_TOT=724.538 SHROWN_TOT_PCT=.

SHROWN_EXCL_OPTS=325.228 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=197.62 SHRS_VEST_VAL=101.686 AGE=51

OPTION_AWARDS_NUM=0 OPTION_AWARDS_FV=0 STOCK_AWARDS_FV=0 OPT_UNEX_EXER_NUM=399.31 OPT_UNEX_UNEXER_NUM=277.49 OPT_UNEX_EXER_EST_VAL=0

OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=387.07 STOCK_UNVEST_VAL=309.656 EIP_UNEARN_NUM=151.9 EIP_UNEARN_VAL=121.52

PENSION_VALUE_TOT=5503.296 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0

DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=1 OTHANN= TDC1=656.226 TDC2=656.226 RSTKGRNT=

OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=0 TOTAL_CURR_PCT=0 TOTAL_SEC_PCT=-58.182

TOTAL_ALT1_PCT=-58.182 TOTAL_ALT2_PCT=-12.885 TDC1_PCT=-80.184 TDC2_PCT=-77.14 RET_YRS= COMMENT= GVKEY=1045 EXECID=26059 YEAR=2012

RSTKVYRS= BECAMECEO=20111128 JOINED_CO= REJOIN= LEFTOFC=2 LEFTCO= RELEFT= PCEO= PCFO=

TITLE=Chairman, Chief Executive Officer and President REASON= EXEC_LNAME=Horton EXEC_FNAME=Thomas EXEC_MNAME=W. GENDER=MALE

NAMEPREFIX=Mr. PAGE=56 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=59

NOTE: Invalid data for CUSIP in line 61 570-577.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

61 Isabella D. Goren,CFO,0,0,0,0,,43629,AMERICAN AIRLINES GROUP INC,"Chief Financial Officer, Principal

101 Accounting Officer and Senior Vice President",,540.385,0,0,0,0.633,771.956,36.823,1349.797,540.385

201 ,1349.797,1407.699,3589.058,5860.147,421.442,,183.502,,0,0,112.53,57.902,51,0,0,0,237.94,134.41,0,0,

301 195.93,156.744,60.45,48.36,2917.275,0,0,0,0,0,0,0,3,,577.841,577.841,,,,,,,6.374,6.374,-37.519,-37.5

401 19,-2.561,-63.868,-59.413,,,1045,41119,2012,,,,,,,,,,"Chief Financial Officer, Principal Accounting

501 Officer and Senior Vice President",,Goren,Isabella,D.,FEMALE,Ms.,56,02376R10,NAS,4333 Amon Carter B

601 oulevard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transpo

701 rtation,Airlines,SP,AAL,817,481111,2030,4512 744

EXEC_FULLNAME=Isabella D. Goren CFOANN=CFO EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=43629

CONAME=AMERICAN TITLEANN=Chief Financial Officer, Principal Accounting Officer and Senior Vice President CEOANN= SALARY=540.385

BONUS=0 STOCK_AWARDS=0 OPTION_AWARDS=0 NONEQ_INCENT=0.633 PENSION_CHG=771.956 OTHCOMP=36.823 TOTAL_SEC=1349.797 TOTAL_CURR=540.385

TOTAL_ALT1=1349.797 TOTAL_ALT2=1407.699 TERM_PYMT=3589.058 CHG_CTRL_PYMT=5860.147 SHROWN_TOT=421.442 SHROWN_TOT_PCT=.

SHROWN_EXCL_OPTS=183.502 SHROWN_EXCL_OPTS_PCT=. OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=112.53 SHRS_VEST_VAL=57.902 AGE=51

OPTION_AWARDS_NUM=0 OPTION_AWARDS_FV=0 STOCK_AWARDS_FV=0 OPT_UNEX_EXER_NUM=237.94 OPT_UNEX_UNEXER_NUM=134.41 OPT_UNEX_EXER_EST_VAL=0

OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=195.93 STOCK_UNVEST_VAL=156.744 EIP_UNEARN_NUM=60.45 EIP_UNEARN_VAL=48.36

PENSION_VALUE_TOT=2917.275 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=0 DEFER_EARNINGS_TOT=0

DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=0 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=3 OTHANN= TDC1=577.841 TDC2=577.841 RSTKGRNT=

OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=6.374 TOTAL_CURR_PCT=6.374

TOTAL_SEC_PCT=-37.519 TOTAL_ALT1_PCT=-37.519 TOTAL_ALT2_PCT=-2.561 TDC1_PCT=-63.868 TDC2_PCT=-59.413 RET_YRS= COMMENT= GVKEY=1045

EXECID=41119 YEAR=2012 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO= PCFO=

TITLE=Chief Financial Officer, Principal Accounting Officer REASON= EXEC_LNAME=Goren EXEC_FNAME=Isabell EXEC_MNAME=D. GENDER=FEMA

NAMEPREFIX=Ms. PAGE=56 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=60

NOTE: Invalid data for CUSIP in line 62 440-447.

62 James B. Ream,,0,0,0,0,,46951,AMERICAN AIRLINES GROUP INC,"Senior Vice President of Operations, Amer

101 ican",,569.8,0,0,0,0.633,15.06,56.054,641.547,569.8,641.547,664.457,682.695,2578.476,198.51,,112.53,

201 ,0,0,47.73,22.91,56,0,0,0,69.37,128.23,0,0,218.82,175.056,60.45,48.36,74.412,0,0,14.423,0.089,0,29.7

301 65,0,2,,626.487,626.487,,,,,,,,,,,,,,,,1045,44119,2012,,,,,,,,,,Senior Vice President of Operations

401 of American,,Ream,James,B.,MALE,Mr.,61,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth,TX,76155,8

501 17-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transportation,Airlines,SP,AAL,817,48

601 1111,2030,4512 614

EXEC_FULLNAME=James B. Ream CFOANN= EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=46951 CONAME=AMERICAN

TITLEANN=Senior Vice President of Operations, American CEOANN= SALARY=569.8 BONUS=0 STOCK_AWARDS=0 OPTION_AWARDS=0

NONEQ_INCENT=0.633 PENSION_CHG=15.06 OTHCOMP=56.054 TOTAL_SEC=641.547 TOTAL_CURR=569.8 TOTAL_ALT1=641.547 TOTAL_ALT2=664.457

TERM_PYMT=682.695 CHG_CTRL_PYMT=2578.476 SHROWN_TOT=198.51 SHROWN_TOT_PCT=. SHROWN_EXCL_OPTS=112.53 SHROWN_EXCL_OPTS_PCT=.

OPT_EXER_NUM=0 OPT_EXER_VAL=0 SHRS_VEST_NUM=47.73 SHRS_VEST_VAL=22.91 AGE=56 OPTION_AWARDS_NUM=0 OPTION_AWARDS_FV=0

STOCK_AWARDS_FV=0 OPT_UNEX_EXER_NUM=69.37 OPT_UNEX_UNEXER_NUM=128.23 OPT_UNEX_EXER_EST_VAL=0 OPT_UNEX_UNEXER_EST_VAL=0

STOCK_UNVEST_NUM=218.82 STOCK_UNVEST_VAL=175.056 EIP_UNEARN_NUM=60.45 EIP_UNEARN_VAL=48.36 PENSION_VALUE_TOT=74.412

PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=14.423 DEFER_EARNINGS_TOT=0.089 DEFER_WITHDR_TOT=0

DEFER_BALANCE_TOT=29.765 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=2 OTHANN= TDC1=626.487 TDC2=626.487 RSTKGRNT=

OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=. TOTAL_CURR_PCT=. TOTAL_SEC_PCT=.

TOTAL_ALT1_PCT=. TOTAL_ALT2_PCT=. TDC1_PCT=. TDC2_PCT=. RET_YRS= COMMENT= GVKEY=1045 EXECID=44119 YEAR=2012 RSTKVYRS= BECAMECEO=.

JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO= PCFO= TITLE=Senior Vice President of Operations of American REASON=

EXEC_LNAME=Ream EXEC_FNAME=James EXEC_MNAME=B. GENDER=MALE NAMEPREFIX=Mr. PAGE=61 CUSIP=. EXCHANGE=NAS

ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234 SICDESC=AIR TRANSPORT, SCHEDULED

NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817 NAICS=481111 SPINDEX=2030

SIC=4512 _ERROR_=1 _N_=61

NOTE: Invalid data for CUSIP in line 63 607-614.

63 Daniel P. Garton,,0,0,0,0,,16477,AMERICAN AIRLINES GROUP INC,Executive Vice President of Marketing a

101 nd Executive Vice President of Marketing - American Airlines Inc,,541.087,0,4803.789,0,937.705,320.2

201 4,3459.466,10062.287,541.087,10062.287,7451.004,0,0,0,,0,0,330.97,1235.326,42.447,957.18,55,0,0,4803

301 .789,0,0,0,0,152.829,3858.922,0,0,6112.506,0,0,15.735,0.009,0,15.744,0,4,,9742.047,10977.373,,,,,,,2

401 ,2,499.804,499.804,316.548,1624.989,1843.724,,,1045,16654,2013,,,,,,,,,,Executive Vice President of

501 Marketing and Executive Vice President of Marketing - American Airlines Inc,,Garton,Daniel,P.,MALE,M

601 r.,59,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT, SCHED

701 ULED",Scheduled Passenger Air Transportation,Airlines,SP,AAL,817,481111,2030,4512 781

EXEC_FULLNAME=Daniel P. Garton CFOANN= EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=16477

CONAME=AMERICAN TITLEANN=Executive Vice President of Marketing and Executive Vice President of Marketing - CEOANN= SALARY=541.087

BONUS=0 STOCK_AWARDS=4803.789 OPTION_AWARDS=0 NONEQ_INCENT=937.705 PENSION_CHG=320.24 OTHCOMP=3459.466 TOTAL_SEC=10062.287

TOTAL_CURR=541.087 TOTAL_ALT1=10062.287 TOTAL_ALT2=7451.004 TERM_PYMT=0 CHG_CTRL_PYMT=0 SHROWN_TOT=0 SHROWN_TOT_PCT=.

SHROWN_EXCL_OPTS=0 SHROWN_EXCL_OPTS_PCT=0 OPT_EXER_NUM=330.97 OPT_EXER_VAL=1235.326 SHRS_VEST_NUM=42.447 SHRS_VEST_VAL=957.18 AGE=55

OPTION_AWARDS_NUM=0 OPTION_AWARDS_FV=0 STOCK_AWARDS_FV=4803.789 OPT_UNEX_EXER_NUM=0 OPT_UNEX_UNEXER_NUM=0 OPT_UNEX_EXER_EST_VAL=0

OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=152.829 STOCK_UNVEST_VAL=3858.922 EIP_UNEARN_NUM=0 EIP_UNEARN_VAL=0

PENSION_VALUE_TOT=6112.506 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=15.735 DEFER_EARNINGS_TOT=0.009

DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=15.744 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=4 OTHANN= TDC1=9742.047 TDC2=10977.373 RSTKGRNT=

OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=2 TOTAL_CURR_PCT=2 TOTAL_SEC_PCT=499.804

TOTAL_ALT1_PCT=499.804 TOTAL_ALT2_PCT=316.548 TDC1_PCT=1624.989 TDC2_PCT=1843.724 RET_YRS= COMMENT= GVKEY=1045 EXECID=16654

YEAR=2013 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO= PCFO=

TITLE=Executive Vice President of Marketing and Executive Vic REASON= EXEC_LNAME=Garton EXEC_FNAME=Daniel EXEC_MNAME=P. GENDER=MALE

NAMEPREFIX=Mr. PAGE=59 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155 TELE=817-963-1234

SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP TICKER=AAL SUB_TELE=817

NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=62

NOTE: Invalid data for CUSIP in line 64 544-551.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

64 Thomas W. Horton,,1,0,0,0,,33126,AMERICAN AIRLINES GROUP INC,"Chairman, Chief Executive Officer and

101 President",CEO,591.911,0,4199.761,0,1183.822,250.143,13117.484,19343.121,591.911,19343.121,21023.902

201 ,0,0,287.718,0.061,287.718,0.061,375.67,2030.761,170.722,3849.781,52,0,0,4199.761,0,0,0,0,0,0,0,0,57

301 53.439,0,0,18.53,0.013,0,18.543,0,1,,19092.978,21123.739,,,,,,,-4.242,-4.242,1005.85,1005.85,1035.90

401 6,2809.513,3118.973,,,1045,26059,2013,,20111128,,,20131209,,,,,"Chairman, Chief Executive Officer an

501 d President",,Horton,Thomas,W.,MALE,Mr.,56,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth,TX,761

601 55,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passenger Air Transportation,Airlines,SP,AAL,81

701 7,481111,2030,4512 718

EXEC_FULLNAME=Thomas W. Horton CFOANN= EXECDIR=1 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=33126

CONAME=AMERICAN TITLEANN=Chairman, Chief Executive Officer and President CEOANN=CEO SALARY=591.911 BONUS=0 STOCK_AWARDS=4199.761

OPTION_AWARDS=0 NONEQ_INCENT=1183.822 PENSION_CHG=250.143 OTHCOMP=13117.484 TOTAL_SEC=19343.121 TOTAL_CURR=591.911

TOTAL_ALT1=19343.121 TOTAL_ALT2=21023.902 TERM_PYMT=0 CHG_CTRL_PYMT=0 SHROWN_TOT=287.718 SHROWN_TOT_PCT=0.061

SHROWN_EXCL_OPTS=287.718 SHROWN_EXCL_OPTS_PCT=0.061 OPT_EXER_NUM=375.67 OPT_EXER_VAL=2030.761 SHRS_VEST_NUM=170.722

SHRS_VEST_VAL=3849.781 AGE=52 OPTION_AWARDS_NUM=0 OPTION_AWARDS_FV=0 STOCK_AWARDS_FV=4199.761 OPT_UNEX_EXER_NUM=0

OPT_UNEX_UNEXER_NUM=0 OPT_UNEX_EXER_EST_VAL=0 OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=0 STOCK_UNVEST_VAL=0 EIP_UNEARN_NUM=0

EIP_UNEARN_VAL=0 PENSION_VALUE_TOT=5753.439 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0 DEFER_CONTRIB_CO_TOT=18.53

DEFER_EARNINGS_TOT=0.013 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=18.543 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=1 OTHANN= TDC1=19092.978

TDC2=21123.739 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD= SAL_PCT=-4.242

TOTAL_CURR_PCT=-4.242 TOTAL_SEC_PCT=1005.85 TOTAL_ALT1_PCT=1005.85 TOTAL_ALT2_PCT=1035.906 TDC1_PCT=2809.513 TDC2_PCT=3118.973

RET_YRS= COMMENT= GVKEY=1045 EXECID=26059 YEAR=2013 RSTKVYRS= BECAMECEO=20111128 JOINED_CO= REJOIN= LEFTOFC=2 LEFTCO= RELEFT=

PCEO= PCFO= TITLE=Chairman, Chief Executive Officer and President REASON= EXEC_LNAME=Horton EXEC_FNAME=Thomas EXEC_MNAME=W.

GENDER=MALE NAMEPREFIX=Mr. PAGE=56 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155

TELE=817-963-1234 SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP

TICKER=AAL SUB_TELE=817 NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=63

NOTE: Invalid data for CUSIP in line 65 586-593.

WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.

65 Isabella D. Goren,CFO,0,0,0,0,,43629,AMERICAN AIRLINES GROUP INC,"Chief Financial Officer, Principal

101 Accounting Officer and Senior Vice President",,551.193,0,4185.64,0,955.217,251.894,3549.428,9493.3

201 72,551.193,9493.372,6864.469,0,0,13.284,0.002,13.284,0.002,198.65,788.436,34.071,768.301,52,0,0,4185

301 .64,0,0,0,0,136.077,3435.945,0,0,3169.168,0,0,16.291,0.009,0,16.3,0,3,,9241.478,10029.914,,,,,,,2,2,

401 603.318,603.318,387.638,1499.312,1635.757,,,1045,41119,2013,,,,,,,,,,"Chief Financial Officer, Princ

501 ipal Accounting Officer and Senior Vice President",,Goren,Isabella,D.,FEMALE,Ms.,56,02376R10,NAS,43

601 33 Amon Carter Boulevard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT, SCHEDULED",Scheduled Passe

701 nger Air Transportation,Airlines,SP,AAL,817,481111,2030,4512 760

EXEC_FULLNAME=Isabella D. Goren CFOANN=CFO EXECDIR=0 OLD_DATAFMT_FLAG=0 INTERLOCK=0 REPRICE=0 EXECRANK=. CO_PER_ROL=43629

CONAME=AMERICAN TITLEANN=Chief Financial Officer, Principal Accounting Officer and Senior Vice President CEOANN= SALARY=551.193

BONUS=0 STOCK_AWARDS=4185.64 OPTION_AWARDS=0 NONEQ_INCENT=955.217 PENSION_CHG=251.894 OTHCOMP=3549.428 TOTAL_SEC=9493.372

TOTAL_CURR=551.193 TOTAL_ALT1=9493.372 TOTAL_ALT2=6864.469 TERM_PYMT=0 CHG_CTRL_PYMT=0 SHROWN_TOT=13.284 SHROWN_TOT_PCT=0.002

SHROWN_EXCL_OPTS=13.284 SHROWN_EXCL_OPTS_PCT=0.002 OPT_EXER_NUM=198.65 OPT_EXER_VAL=788.436 SHRS_VEST_NUM=34.071

SHRS_VEST_VAL=768.301 AGE=52 OPTION_AWARDS_NUM=0 OPTION_AWARDS_FV=0 STOCK_AWARDS_FV=4185.64 OPT_UNEX_EXER_NUM=0

OPT_UNEX_UNEXER_NUM=0 OPT_UNEX_EXER_EST_VAL=0 OPT_UNEX_UNEXER_EST_VAL=0 STOCK_UNVEST_NUM=136.077 STOCK_UNVEST_VAL=3435.945

EIP_UNEARN_NUM=0 EIP_UNEARN_VAL=0 PENSION_VALUE_TOT=3169.168 PENSION_PYMTS_TOT=0 DEFER_CONTRIB_EXEC_TOT=0

DEFER_CONTRIB_CO_TOT=16.291 DEFER_EARNINGS_TOT=0.009 DEFER_WITHDR_TOT=0 DEFER_BALANCE_TOT=16.3 DEFER_RPT_AS_COMP_TOT=0 EXECRANKANN=3

OTHANN= TDC1=9241.478 TDC2=10029.914 RSTKGRNT= OPTION_AWARDS_BLK_VALUE= OPTION_AWARDS_RPT_VALUE= LTIP= ALLOTHTOT= ALLOTHPD=

SAL_PCT=2 TOTAL_CURR_PCT=2 TOTAL_SEC_PCT=603.318 TOTAL_ALT1_PCT=603.318 TOTAL_ALT2_PCT=387.638 TDC1_PCT=1499.312 TDC2_PCT=1635.757

RET_YRS= COMMENT= GVKEY=1045 EXECID=41119 YEAR=2013 RSTKVYRS= BECAMECEO=. JOINED_CO= REJOIN= LEFTOFC= LEFTCO= RELEFT= PCEO=

PCFO= TITLE=Chief Financial Officer, Principal Accounting Officer REASON= EXEC_LNAME=Goren EXEC_FNAME=Isabell EXEC_MNAME=D.

GENDER=FEMA NAMEPREFIX=Ms. PAGE=56 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter Boulevard CITY=Fort Wort STATE=TX ZIP=76155

TELE=817-963-1234 SICDESC=AIR TRANSPORT, SCHEDULED NAICSDESC=Scheduled Passenger Air Transportation INDDESC=Airlines SPCODE=SP

TICKER=AAL SUB_TELE=817 NAICS=481111 SPINDEX=2030 SIC=4512 _ERROR_=1 _N_=64

NOTE: 74300 records were read from the infile '~/425/425_Final_Paper/CompuStat_Execucomp.csv'.

The minimum record length was 299.

The maximum record length was 1177.

NOTE: The data set PAPER.COMPUSTAT_EXECUCOMP has 74300 observations and 107 variables.

NOTE: DATA statement used (Total process time):

real time 0.70 seconds

user cpu time 0.51 seconds

system cpu time 0.08 seconds

memory 14972.84k

OS Memory 45608.00k

Timestamp 03/03/2018 08:18:38 PM

Step Count 58 Switch Count 1

Page Faults 0

Page Reclaims 325

Page Swaps 0

Voluntary Context Switches 1302

Involuntary Context Switches 14

Block Input Operations 0

Block Output Operations 136968

Errors detected in submitted DATA step. Examine log.

74300 rows created in PAPER.COMPUSTAT_EXECUCOMP from ~/425/425_Final_Paper/CompuStat_Execucomp.csv.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.97 seconds

user cpu time 0.71 seconds

system cpu time 0.10 seconds

memory 14972.84k

OS Memory 46124.00k

Timestamp 03/03/2018 08:18:38 PM

Step Count 58 Switch Count 9

Page Faults 0

Page Reclaims 6462

Page Swaps 0

Voluntary Context Switches 1383

Involuntary Context Switches 15

Block Input Operations 288

Block Output Operations 137040

415

416 /*import csrp dataset*/

417 PROC IMPORT out=paper.CSRP_Monthly_Stock

418 datafile="~/425/425_Final_Paper/CSRP_MonthlyStock.csv"

419 DBMS=CSV replace;

420 getnames= yes;

421 run;

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

422 /**********************************************************************

423 * PRODUCT: SAS

424 * VERSION: 9.4

425 * CREATOR: External File Interface

426 * DATE: 03MAR18

427 * DESC: Generated SAS Datastep Code

428 * TEMPLATE SOURCE: (None Specified.)

429 ***********************************************************************/

430 data PAPER.CSRP_MONTHLY_STOCK ;

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

432 infile '~/425/425_Final_Paper/CSRP_MonthlyStock.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;

433 informat PERMNO best32. ;

434 informat date best32. ;

435 informat NAMEENDT best32. ;

436 informat SHRCD best32. ;

437 informat EXCHCD best32. ;

438 informat SICCD best32. ;

439 informat NCUSIP $8. ;

440 informat TICKER $4. ;

441 informat COMNAM $15. ;

442 informat SHRCLS $1. ;

443 informat TSYMBOL $4. ;

444 informat NAICS best32. ;

445 informat PRIMEXCH $1. ;

446 informat TRDSTAT $1. ;

447 informat SECSTAT $1. ;

448 informat PERMCO best32. ;

449 informat ISSUNO best32. ;

450 informat HEXCD best32. ;

451 informat HSICCD best32. ;

452 informat CUSIP best32. ;

453 informat DCLRDT best32. ;

454 informat DLAMT $1. ;

455 informat DLPDT $1. ;

456 informat DLSTCD $1. ;

457 informat NEXTDT $1. ;

458 informat PAYDT best32. ;

459 informat RCRDDT best32. ;

460 informat SHRFLG best32. ;

461 informat HSICMG $1. ;

462 informat HSICIG $1. ;

463 informat DISTCD best32. ;

464 informat DIVAMT best32. ;

465 informat FACPR best32. ;

466 informat FACSHR best32. ;

467 informat ACPERM $1. ;

468 informat ACCOMP $1. ;

469 informat SHRENDDT best32. ;

470 informat NWPERM $1. ;

471 informat DLRETX $1. ;

472 informat DLPRC $1. ;

473 informat DLRET $1. ;

474 informat TRTSCD best32. ;

475 informat NMSIND best32. ;

476 informat MMCNT best32. ;

477 informat NSDINX best32. ;

478 informat BIDLO best32. ;

479 informat ASKHI best32. ;

480 informat PRC best32. ;

481 informat VOL best32. ;

482 informat RET best32. ;

483 informat BID best32. ;

484 informat ASK best32. ;

485 informat SHROUT best32. ;

486 informat CFACPR best32. ;

487 informat CFACSHR best32. ;

488 informat ALTPRC best32. ;

489 informat SPREAD $1. ;

490 informat ALTPRCDT best32. ;

491 informat RETX best32. ;

492 informat vwretd best32. ;

493 informat vwretx best32. ;

494 informat ewretd best32. ;

495 informat ewretx best32. ;

496 informat sprtrn best32. ;

497 format PERMNO best12. ;

498 format date best12. ;

499 format NAMEENDT best12. ;

500 format SHRCD best12. ;

501 format EXCHCD best12. ;

502 format SICCD best12. ;

503 format NCUSIP $8. ;

504 format TICKER $4. ;

505 format COMNAM $15. ;

506 format SHRCLS $1. ;

507 format TSYMBOL $4. ;

508 format NAICS best12. ;

509 format PRIMEXCH $1. ;

510 format TRDSTAT $1. ;

511 format SECSTAT $1. ;

512 format PERMCO best12. ;

513 format ISSUNO best12. ;

514 format HEXCD best12. ;

515 format HSICCD best12. ;

516 format CUSIP best12. ;

517 format DCLRDT best12. ;

518 format DLAMT $1. ;

519 format DLPDT $1. ;

520 format DLSTCD $1. ;

521 format NEXTDT $1. ;

522 format PAYDT best12. ;

523 format RCRDDT best12. ;

524 format SHRFLG best12. ;

525 format HSICMG $1. ;

526 format HSICIG $1. ;

527 format DISTCD best12. ;

528 format DIVAMT best12. ;

529 format FACPR best12. ;

530 format FACSHR best12. ;

531 format ACPERM $1. ;

532 format ACCOMP $1. ;

533 format SHRENDDT best12. ;

534 format NWPERM $1. ;

535 format DLRETX $1. ;

536 format DLPRC $1. ;

537 format DLRET $1. ;

538 format TRTSCD best12. ;

539 format NMSIND best12. ;

540 format MMCNT best12. ;

541 format NSDINX best12. ;

542 format BIDLO best12. ;

543 format ASKHI best12. ;

544 format PRC best12. ;

545 format VOL best12. ;

546 format RET best12. ;

547 format BID best12. ;

548 format ASK best12. ;

549 format SHROUT best12. ;

550 format CFACPR best12. ;

551 format CFACSHR best12. ;

552 format ALTPRC best12. ;

553 format SPREAD $1. ;

554 format ALTPRCDT best12. ;

555 format RETX best12. ;

556 format vwretd best12. ;

557 format vwretx best12. ;

558 format ewretd best12. ;

559 format ewretx best12. ;

560 format sprtrn best12. ;

561 input

562 PERMNO

563 date

564 NAMEENDT

565 SHRCD

566 EXCHCD

567 SICCD

568 NCUSIP $

569 TICKER $

570 COMNAM $

571 SHRCLS $

572 TSYMBOL $

573 NAICS

574 PRIMEXCH $

575 TRDSTAT $

576 SECSTAT $

577 PERMCO

578 ISSUNO

579 HEXCD

580 HSICCD

581 CUSIP

582 DCLRDT

583 DLAMT $

584 DLPDT $

585 DLSTCD $

586 NEXTDT $

587 PAYDT

588 RCRDDT

589 SHRFLG

590 HSICMG $

591 HSICIG $

592 DISTCD

593 DIVAMT

594 FACPR

595 FACSHR

596 ACPERM $

597 ACCOMP $

598 SHRENDDT

599 NWPERM $

600 DLRETX $

601 DLPRC $

602 DLRET $

603 TRTSCD

604 NMSIND

605 MMCNT

606 NSDINX

607 BIDLO

608 ASKHI

609 PRC

610 VOL

611 RET

612 BID

613 ASK

614 SHROUT

615 CFACPR

616 CFACSHR

617 ALTPRC

618 SPREAD $

619 ALTPRCDT

620 RETX

621 vwretd

622 vwretx

623 ewretd

624 ewretx

625 sprtrn

626 ;

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

628 run;

NOTE: The infile '~/425/425_Final_Paper/CSRP_MonthlyStock.csv' is:

Filename=/home/apmorabito0/425/425_Final_Paper/CSRP_MonthlyStock.csv,

Owner Name=apmorabito0,Group Name=oda,

Access Permission=-rw-r--r--,

Last Modified=20Feb2018:10:08:33,

File Size (bytes)=185718030

NOTE: Invalid data for CUSIP in line 94 108-115.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

94 10002,20100129,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,,,,,,1,6,26,3,2.74,3.955,3.92,7547,0.365854,3.83,3.92,17634,1,1,3.9

201 2,,20100129,0.365854,-0.037096,-0.038109,-0.011388,-0.012292,-0.036974 270

PERMNO=10002 date=20100129 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=. NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=26 NSDINX=3 BIDLO=2.74 ASKHI=3.955 PRC=3.92 VOL=7547

RET=0.365854 BID=3.83 ASK=3.92 SHROUT=17634 CFACPR=1 CFACSHR=1 ALTPRC=3.92 SPREAD= ALTPRCDT=20100129 RETX=0.365854 vwretd=-0.037096

vwretx=-0.038109 ewretd=-0.011388 ewretx=-0.012292 sprtrn=-0.036974 _ERROR_=1 _N_=93

NOTE: Invalid data for CUSIP in line 95 108-115.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

95 10002,20100226,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,,,,,,1,6,27,3,3.86,4.95,4.53,5861,0.155612,4.54,4.63,17634,1,1,4.53

201 ,,20100226,0.155612,0.034774,0.032688,0.033603,0.032232,0.028514 264

PERMNO=10002 date=20100226 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=. NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=27 NSDINX=3 BIDLO=3.86 ASKHI=4.95 PRC=4.53 VOL=5861

RET=0.155612 BID=4.54 ASK=4.63 SHROUT=17634 CFACPR=1 CFACSHR=1 ALTPRC=4.53 SPREAD= ALTPRCDT=20100226 RETX=0.155612 vwretd=0.034774

vwretx=0.032688 ewretd=0.033603 ewretx=0.032232 sprtrn=0.028514 _ERROR_=1 _N_=94

NOTE: Invalid data for CUSIP in line 96 108-115.

96 10002,20100331,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20100505,,,,,1,6,27,3,4.55,4.97,4.85,5061,0.07064,4.85,5,17639,1,1,

201 4.85,,20100331,0.07064,0.063606,0.06192,0.069289,0.067252,0.058796 266

PERMNO=10002 date=20100331 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20100505 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=27 NSDINX=3 BIDLO=4.55 ASKHI=4.97 PRC=4.85 VOL=5061

RET=0.07064 BID=4.85 ASK=5 SHROUT=17639 CFACPR=1 CFACSHR=1 ALTPRC=4.85 SPREAD= ALTPRCDT=20100331 RETX=0.07064 vwretd=0.063606

vwretx=0.06192 ewretd=0.069289 ewretx=0.067252 sprtrn=0.058796 _ERROR_=1 _N_=95

NOTE: Invalid data for CUSIP in line 97 108-115.

97 10002,20100430,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,,,,,,1,6,27,3,4.8499,6.3,6.19,5208,0.276289,6.21,6.32,17639,1,1,6.1

201 9,,20100430,0.276289,0.020043,0.01893,0.057843,0.056698,0.014759 264

PERMNO=10002 date=20100430 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=. NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=27 NSDINX=3 BIDLO=4.8499 ASKHI=6.3 PRC=6.19 VOL=5208

RET=0.276289 BID=6.21 ASK=6.32 SHROUT=17639 CFACPR=1 CFACSHR=1 ALTPRC=6.19 SPREAD= ALTPRCDT=20100430 RETX=0.276289 vwretd=0.020043

vwretx=0.01893 ewretd=0.057843 ewretx=0.056698 sprtrn=0.014759 _ERROR_=1 _N_=96

NOTE: Invalid data for CUSIP in line 98 108-115.

98 10002,20100528,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20100629,,,,,1,6,27,3,4.33,5.7,4.43,3610,-0.28433,4.43,4.45,17686,1

201 ,1,4.43,,20100528,-0.28433,-0.079136,-0.081224,-0.076929,-0.078435,-0.081976 276

PERMNO=10002 date=20100528 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20100629 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=27 NSDINX=3 BIDLO=4.33 ASKHI=5.7 PRC=4.43 VOL=3610

RET=-0.28433 BID=4.43 ASK=4.45 SHROUT=17686 CFACPR=1 CFACSHR=1 ALTPRC=4.43 SPREAD= ALTPRCDT=20100528 RETX=-0.28433 vwretd=-0.079136

vwretx=-0.081224 ewretd=-0.076929 ewretx=-0.078435 sprtrn=-0.081976 _ERROR_=1 _N_=97

NOTE: Invalid data for CUSIP in line 99 108-115.

99 10002,20100630,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20100808,,,,,1,6,26,3,3.7,4.73,3.7,2832,-0.164786,3.71,3.77,17639,1

201 ,1,3.7,,20100630,-0.164786,-0.050725,-0.052465,-0.056799,-0.058868,-0.053882 276

PERMNO=10002 date=20100630 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20100808 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=26 NSDINX=3 BIDLO=3.7 ASKHI=4.73 PRC=3.7 VOL=2832

RET=-0.164786 BID=3.71 ASK=3.77 SHROUT=17639 CFACPR=1 CFACSHR=1 ALTPRC=3.7 SPREAD= ALTPRCDT=20100630 RETX=-0.164786

vwretd=-0.050725 vwretx=-0.052465 ewretd=-0.056799 ewretx=-0.058868 sprtrn=-0.053882 _ERROR_=1 _N_=98

NOTE: Invalid data for CUSIP in line 100 108-115.

100 10002,20100730,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,,,,,,1,6,28,3,2.96,3.76,3.07,3247,-0.17027,3.07,3.09,17639,1,1,3.07

201 ,,20100730,-0.17027,0.070292,0.068594,0.05994,0.058682,0.068778 263

PERMNO=10002 date=20100730 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=. NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=28 NSDINX=3 BIDLO=2.96 ASKHI=3.76 PRC=3.07 VOL=3247

RET=-0.17027 BID=3.07 ASK=3.09 SHROUT=17639 CFACPR=1 CFACSHR=1 ALTPRC=3.07 SPREAD= ALTPRCDT=20100730 RETX=-0.17027 vwretd=0.070292

vwretx=0.068594 ewretd=0.05994 ewretx=0.058682 sprtrn=0.068778 _ERROR_=1 _N_=99

NOTE: Invalid data for CUSIP in line 101 108-115.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

101 10002,20100831,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20100929,,,,,1,6,26,3,3.03,3.56,3.1,5429,0.009772,3.11,3.15,17639,1

201 ,1,3.1,,20100831,0.009772,-0.042813,-0.044938,-0.047566,-0.049083,-0.047449 275

PERMNO=10002 date=20100831 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20100929 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=26 NSDINX=3 BIDLO=3.03 ASKHI=3.56 PRC=3.1 VOL=5429

RET=0.009772 BID=3.11 ASK=3.15 SHROUT=17639 CFACPR=1 CFACSHR=1 ALTPRC=3.1 SPREAD= ALTPRCDT=20100831 RETX=0.009772 vwretd=-0.042813

vwretx=-0.044938 ewretd=-0.047566 ewretx=-0.049083 sprtrn=-0.047449 _ERROR_=1 _N_=100

NOTE: Invalid data for CUSIP in line 102 108-115.

102 10002,20100930,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20101108,,,,,1,6,27,3,2.92,3.32,3.05,5048,-0.016129,3.02,3.1,17639,

201 1,1,3.05,,20100930,-0.016129,0.091518,0.089635,0.096418,0.094485,0.087551 273

PERMNO=10002 date=20100930 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20101108 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=27 NSDINX=3 BIDLO=2.92 ASKHI=3.32 PRC=3.05 VOL=5048

RET=-0.016129 BID=3.02 ASK=3.1 SHROUT=17639 CFACPR=1 CFACSHR=1 ALTPRC=3.05 SPREAD= ALTPRCDT=20100930 RETX=-0.016129 vwretd=0.091518

vwretx=0.089635 ewretd=0.096418 ewretx=0.094485 sprtrn=0.087551 _ERROR_=1 _N_=101

NOTE: Invalid data for CUSIP in line 103 108-115.

103 10002,20101029,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,,,,,,1,6,25,3,2.88,3.24,2.88,2653,-0.055738,2.87,2.9,17639,1,1,2.88

201 ,,20101029,-0.055738,0.038531,0.037009,0.040681,0.039488,0.036856 265

PERMNO=10002 date=20101029 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=. NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=25 NSDINX=3 BIDLO=2.88 ASKHI=3.24 PRC=2.88 VOL=2653

RET=-0.055738 BID=2.87 ASK=2.9 SHROUT=17639 CFACPR=1 CFACSHR=1 ALTPRC=2.88 SPREAD= ALTPRCDT=20101029 RETX=-0.055738 vwretd=0.038531

vwretx=0.037009 ewretd=0.040681 ewretx=0.039488 sprtrn=0.036856 _ERROR_=1 _N_=102

NOTE: Invalid data for CUSIP in line 104 108-115.

104 10002,20101130,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20101230,,,,,1,6,27,3,2.51,3,2.51,4131,-0.128472,2.51,2.57,17640,1,

201 1,2.51,,20101130,-0.128472,0.005108,0.002908,0.010736,0.008972,-0.00229 271

PERMNO=10002 date=20101130 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20101230 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=27 NSDINX=3 BIDLO=2.51 ASKHI=3 PRC=2.51 VOL=4131

RET=-0.128472 BID=2.51 ASK=2.57 SHROUT=17640 CFACPR=1 CFACSHR=1 ALTPRC=2.51 SPREAD= ALTPRCDT=20101130 RETX=-0.128472

vwretd=0.005108 vwretx=0.002908 ewretd=0.010736 ewretx=0.008972 sprtrn=-0.00229 _ERROR_=1 _N_=103

NOTE: Invalid data for CUSIP in line 105 108-115.

105 10002,20101231,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20110323,,,,,1,6,26,3,2.4,2.77,2.67,7350,0.063745,2.67,2.68,17639,1

201 ,1,2.67,,20101231,0.063745,0.06715,0.064817,0.068851,0.065469,0.0653 268

PERMNO=10002 date=20101231 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20110323 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=26 NSDINX=3 BIDLO=2.4 ASKHI=2.77 PRC=2.67 VOL=7350

RET=0.063745 BID=2.67 ASK=2.68 SHROUT=17639 CFACPR=1 CFACSHR=1 ALTPRC=2.67 SPREAD= ALTPRCDT=20101231 RETX=0.063745 vwretd=0.06715

vwretx=0.064817 ewretd=0.068851 ewretx=0.065469 sprtrn=0.0653 _ERROR_=1 _N_=104

NOTE: Invalid data for CUSIP in line 106 108-115.

106 10002,20110131,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

101 3,6020,05978R10,,,,,,,,,,,,,,,,,,,,,,,,,,2.55,2.9,2.78,6831,0.041198,2.75,2.8,17639,1,1,2.78,,201101

201 31,0.041198,0.019157,0.018203,0.014412,0.013611,0.022646 256

PERMNO=10002 date=20110131 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=. HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=. NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=. NMSIND=. MMCNT=. NSDINX=. BIDLO=2.55 ASKHI=2.9 PRC=2.78 VOL=6831 RET=0.041198

BID=2.75 ASK=2.8 SHROUT=17639 CFACPR=1 CFACSHR=1 ALTPRC=2.78 SPREAD= ALTPRCDT=20110131 RETX=0.041198 vwretd=0.019157

vwretx=0.018203 ewretd=0.014412 ewretx=0.013611 sprtrn=0.022646 _ERROR_=1 _N_=105

NOTE: Invalid data for CUSIP in line 107 108-115.

107 10002,20110228,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,,,,,,1,6,27,3,2.58,2.7,2.64,5840,-0.05036,2.6,2.63,17639,1,1,2.64,,

201 20110228,-0.05036,0.038165,0.036232,0.037036,0.035725,0.031957 262

PERMNO=10002 date=20110228 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=. NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=27 NSDINX=3 BIDLO=2.58 ASKHI=2.7 PRC=2.64 VOL=5840 RET=-0.05036

BID=2.6 ASK=2.63 SHROUT=17639 CFACPR=1 CFACSHR=1 ALTPRC=2.64 SPREAD= ALTPRCDT=20110228 RETX=-0.05036 vwretd=0.038165

vwretx=0.036232 ewretd=0.037036 ewretx=0.035725 sprtrn=0.031957 _ERROR_=1 _N_=106

NOTE: Invalid data for CUSIP in line 108 108-115.

108 10002,20110331,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20110403,,,,,1,6,26,3,2.34,2.7,2.46,6597,-0.068182,2.39,2.4,17936,1

201 ,1,2.46,,20110331,-0.068182,0.003366,0.001781,0.008605,0.006786,-0.001047 273

PERMNO=10002 date=20110331 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20110403 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=26 NSDINX=3 BIDLO=2.34 ASKHI=2.7 PRC=2.46 VOL=6597

RET=-0.068182 BID=2.39 ASK=2.4 SHROUT=17936 CFACPR=1 CFACSHR=1 ALTPRC=2.46 SPREAD= ALTPRCDT=20110331 RETX=-0.068182 vwretd=0.003366

vwretx=0.001781 ewretd=0.008605 ewretx=0.006786 sprtrn=-0.001047 _ERROR_=1 _N_=107

NOTE: Invalid data for CUSIP in line 109 108-115.

109 10002,20110429,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20110508,,,,,1,6,27,3,2.5,2.74,2.5,2077,0.01626,2.51,2.54,17980,1,1

201 ,2.5,,20110429,0.01626,0.028688,0.027573,0.019203,0.018109,0.028495 267

PERMNO=10002 date=20110429 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20110508 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=27 NSDINX=3 BIDLO=2.5 ASKHI=2.74 PRC=2.5 VOL=2077

RET=0.01626 BID=2.51 ASK=2.54 SHROUT=17980 CFACPR=1 CFACSHR=1 ALTPRC=2.5 SPREAD= ALTPRCDT=20110429 RETX=0.01626 vwretd=0.028688

vwretx=0.027573 ewretd=0.019203 ewretx=0.018109 sprtrn=0.028495 _ERROR_=1 _N_=108

NOTE: Invalid data for CUSIP in line 110 108-115.

110 10002,20110531,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20110629,,,,,1,6,28,3,2.4,2.53,2.44,1893,-0.024,2.45,2.5,17983,1,1,

201 2.44,,20110531,-0.024,-0.014935,-0.016942,-0.018549,-0.020191,-0.013501 271

PERMNO=10002 date=20110531 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20110629 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=28 NSDINX=3 BIDLO=2.4 ASKHI=2.53 PRC=2.44 VOL=1893

RET=-0.024 BID=2.45 ASK=2.5 SHROUT=17983 CFACPR=1 CFACSHR=1 ALTPRC=2.44 SPREAD= ALTPRCDT=20110531 RETX=-0.024 vwretd=-0.014935

vwretx=-0.016942 ewretd=-0.018549 ewretx=-0.020191 sprtrn=-0.013501 _ERROR_=1 _N_=109

NOTE: Invalid data for CUSIP in line 111 108-115.

111 10002,20110630,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20110809,,,,,1,6,27,3,2.3,2.67,2.57,1971,0.053279,2.56,2.6,17952,1,

201 1,2.57,,20110630,0.053279,-0.018395,-0.020161,-0.024106,-0.026251,-0.018258 275

PERMNO=10002 date=20110630 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20110809 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=27 NSDINX=3 BIDLO=2.3 ASKHI=2.67 PRC=2.57 VOL=1971

RET=0.053279 BID=2.56 ASK=2.6 SHROUT=17952 CFACPR=1 CFACSHR=1 ALTPRC=2.57 SPREAD= ALTPRCDT=20110630 RETX=0.053279 vwretd=-0.018395

vwretx=-0.020161 ewretd=-0.024106 ewretx=-0.026251 sprtrn=-0.018258 _ERROR_=1 _N_=110

NOTE: Invalid data for CUSIP in line 112 108-115.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0

112 10002,20110729,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,,,,,,1,6,29,3,2.33,2.58,2.37,1396,-0.077821,2.37,2.39,17952,1,1,2.3

201 7,,20110729,-0.077821,-0.02247,-0.023611,-0.021813,-0.022838,-0.021474 270

PERMNO=10002 date=20110729 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=. NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=29 NSDINX=3 BIDLO=2.33 ASKHI=2.58 PRC=2.37 VOL=1396

RET=-0.077821 BID=2.37 ASK=2.39 SHROUT=17952 CFACPR=1 CFACSHR=1 ALTPRC=2.37 SPREAD= ALTPRCDT=20110729 RETX=-0.077821

vwretd=-0.02247 vwretx=-0.023611 ewretd=-0.021813 ewretx=-0.022838 sprtrn=-0.021474 _ERROR_=1 _N_=111

NOTE: Invalid data for CUSIP in line 113 108-115.

WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.

113 10002,20110831,,11,3,6020,05978R10,BTFG,BANCTRUST FINANCIAL GROUP INC,,BTFG,551111,Q,A,R,7954,10399,

101 3,6020,05978R10,,,,,,,,0,,,,,,,,,20110929,,,,,1,6,27,3,2.3,2.4,2.3,2772,-0.029536,2.32,2.38,17980,1,

201 1,2.3,,20110831,-0.029536,-0.057472,-0.059612,-0.075715,-0.077329,-0.056791 275

PERMNO=10002 date=20110831 NAMEENDT=. SHRCD=11 EXCHCD=3 SICCD=6020 NCUSIP=05978R10 TICKER=BTFG COMNAM=BANCTRUST FINAN SHRCLS=

TSYMBOL=BTFG NAICS=551111 PRIMEXCH=Q TRDSTAT=A SECSTAT=R PERMCO=7954 ISSUNO=10399 HEXCD=3 HSICCD=6020 CUSIP=. DCLRDT=. DLAMT=

DLPDT= DLSTCD= NEXTDT= PAYDT=. RCRDDT=. SHRFLG=0 HSICMG= HSICIG= DISTCD=. DIVAMT=. FACPR=. FACSHR=. ACPERM= ACCOMP=

SHRENDDT=20110929 NWPERM= DLRETX= DLPRC= DLRET= TRTSCD=1 NMSIND=6 MMCNT=27 NSDINX=3 BIDLO=2.3 ASKHI=2.4 PRC=2.3 VOL=2772

RET=-0.029536 BID=2.32 ASK=2.38 SHROUT=17980 CFACPR=1 CFACSHR=1 ALTPRC=2.3 SPREAD= ALTPRCDT=20110831 RETX=-0.029536

vwretd=-0.057472 vwretx=-0.059612 ewretd=-0.075715 ewretx=-0.077329 sprtrn=-0.056791 _ERROR_=1 _N_=112

NOTE: 677216 records were read from the infile '~/425/425_Final_Paper/CSRP_MonthlyStock.csv'.

The minimum record length was 140.

The maximum record length was 354.

NOTE: The data set PAPER.CSRP_MONTHLY_STOCK has 677216 observations and 64 variables.

NOTE: DATA statement used (Total process time):

real time 4.45 seconds

user cpu time 2.68 seconds

system cpu time 0.25 seconds

memory 13107.71k

OS Memory 43556.00k

Timestamp 03/03/2018 08:18:43 PM

Step Count 59 Switch Count 1

Page Faults 0

Page Reclaims 260

Page Swaps 0

Voluntary Context Switches 6708

Involuntary Context Switches 15

Block Input Operations 0

Block Output Operations 519176

Errors detected in submitted DATA step. Examine log.

677216 rows created in PAPER.CSRP_MONTHLY_STOCK from ~/425/425_Final_Paper/CSRP_MonthlyStock.csv.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 4.64 seconds

user cpu time 2.78 seconds

system cpu time 0.29 seconds

memory 13107.71k

OS Memory 44072.00k

Timestamp 03/03/2018 08:18:43 PM

Step Count 59 Switch Count 9

Page Faults 0

Page Reclaims 5585

Page Swaps 0

Voluntary Context Switches 6801

Involuntary Context Switches 15

Block Input Operations 288

Block Output Operations 519200

629

630 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

642

mkeintz · Posted 03-03-2018 06:15 PM

In line 46 of your data, the CUSIP field has a value of

02376R10

but your import program expects it to be numeric. Hence the

NOTE: Invalid data for CUSIP in line 46 513-520.

on the log. This note is probably due to the fact that PROC import assesses the first few raw data lines to determine whether a variable is number, and if it is character, the number of bytes to expect. Probably line 46 was not pre-scanned for this purpose. And this unexpected condition is repeated a number of times. When it happes the record-level automatic variable _ERROR_ is set to 1. And proc import examines _ERROR_ for each record. If it is 1, then the macrovar EFIERR is set to one, which is apparently tested at the end of the data step.

The proc import documentation says:

For delimited files, the first 20 rows are scanned to determine the variable attributes. You can increase the number of rows that are scanned by using the GUESSINGROWS= statement. All values are read in as character strings. If a Date and Time format or a numeric informat can be applied to the data value, the type is declared as numeric. Otherwise, the type remains character.

So you can add a guessingrows statement to the proc import, (I think it can either precede or succeed the GETNAMES statement):

guessingrows=500;

or even

guessingrows=max;

And you might want to look up how CUSIPs codes are defined.

Finally, did you download your csv data from WRDS? If so, you can re-download, and simply request a PC-SAS format in the download query.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

sastuck · Posted 03-05-2018 06:53 PM

Hey! Thanks again for the help on this proc import statement. My only issue now is that with the guessing rows max statement, the running time is very very slow. Are there any alternatives? I tried instead going through the rows by the thousands always got the same error message. Here's my code again:

/*import csrp dataset*/
PROC IMPORT out=paper.CSRP_Monthly_Stock
	datafile="~/425/425_Final_Paper/CSRP_MonthlyStock.csv"
	DBMS=CSV replace;
	getnames= yes;
	/*guessingrows=max;*/
run;

I had the same issue with my other data set, but I fixed this by doing the following (again, this didn't work for the CSRP dataset):

PROC IMPORT out=paper.CompuStat_Execucomp
	datafile="~/425/425_Final_Paper/CompuStat_Execucomp.csv"
	DBMS=CSV replace;
	getnames= yes;
	guessingrows=2000;
run;

mkeintz · Posted 03-05-2018 08:03 PM

This is the price paid by inserting Excel into data analysis that requires consistency of data types within a column.

If you don't want to apply "guessingrows=max" and you find that values like "guessingrows=2000" insufficient to solve the problem, then it time to actually learn about the data.

Then you can take the DATA step generated by proc import and modify it.

For instance variable CUSIP is almost certainly never more then a 9-character variable in your data set (6 digit issuer id, 2 digit issue id, and a check digit). So change its informat and format to $9., and have the INPUT statement trail the CUSIP varname with a $.

If you get similar error messages for other variables, then go to your data source and get documentation on the nature of the problem variable(s). And modify the data step accordingly.

Editted addition. Since you are using an academic account, and you are obviously reading Compustat data (the only vendor with the GVKEY id variable), it's possible you downloaded the data from WRDS using an academic subscription. If so, then download the same data, but choose the SAS data format as the download data file format. Avoid this headache.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Tom · Posted 03-05-2018 08:33 PM

Get the documentation on the data and write a data step to read it that will define the variable as they are intended instead of guessing.

At this point you would have spent less time just writing your own data step to read the data than it has taken you to debug the mess that results from trying to guess what type of data your file contains.

A data step to read a CSV file does not need to be as messy and complicated as the code that PROC IMPORT generates. Just follow these steps.

1) Start with a DATA and INFILE statement.

data want ;
  infile 'myfile.csv' dsd truncover firstobs=2 ;

2) Copy the header row and turn it into a LENGTH statement to define the variables. You can probably figure out from looking at just the names and maybe an example or two what type of data each variable should hold.

LENGTH
  PERMNO 8
  date 8
  NAMEENDT 8
  SHRCD
  EXCHCD
  SICCD
  NCUSIP $10
  TICKER $5
  COMNAM $20
...
  sprtrn 8
;

3) Add in a format statement and informat statement for any variables that NEED them. Probably only the date and time variables.

informat date nameendt anydtdte. ;
format date nameendt yymmdd10. ;

4) Add an INPUT statement. Just use a positional variable list since you know you defined the variables in the proper order in the LENGTH statement.

input PERMNO -- sprtrn ;

5) End the data step.

run;

sastuck · Posted 03-05-2018 09:22 PM

working through this now. Does the $ denote variables with characters in it? What is the purpose of using different numbers ($10,$5,$20) while just using 8 to denote the numeric variables? Here's my length statement so far:

/*import using datastep*/
data paper.CSRP_Monthly_Stock;
  infile '~/425/425_Final_Paper/CSRP_MonthlyStock.csv' dsd truncover firstobs=2 ;
  LENGTH
  PERMNO 8
  date 8
  NAMEENDT 8
  SHRCD
  EXCHCD
  SICCD
  NCUSIP $10
  TICKER $5
  COMNAM $20
  SHRCLS
  TSYMBOL
  NAICS
  PRIMEXCH
  TRDSTAT
  SECSTAT
  PERMCO
  ISSUNO
  HEXCD
  HSICCD
  CUSIP
  DCLRDT
  DLAMT
  DLPDT
  DLSTCD
  NEXTDT
  PAYDT
  RCRDDT
  SHRFLG
  HSICMG
  HSICIG
  DISTCD
  DIVAMT
  FACPR
  FACSHR
  ACPERM
  ACCOMP
  SHRENDDT
  NWPERM
  DLRETX
  DLPRC
  DLRET
  TRTSCD
  NMSIND
  MMCNT
  NSDINX
  BIDLO
  ASKHI
  PRC
  VOL
  RET
  BID
  ASK
  SHROUT
  CFACPR
  CFACSHR
  ALTPRC
  SPREAD
  ALTPRCDT
  RETX
  vwretd
  vwretx
  ewretd
  ewretx
  sprtrn 8
;

Thanks!

Tom · Posted 03-05-2018 11:01 PM

SAS has two types of variables. Floating point numbers and fixed length character strings.

The $ signifies that the length is for a character variable.

http://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=p1hgqgmxm3dpqcn1d4w5za5qbz0d.htm&docs...

Since floating point numbers take 64 bits the length for a numeric variable should always be 8. You can store them in the dataset using using fewer bytes by setting the length to something smaller than 8, but that just means that SAS throws away the least significant bits. So you should only do that for small integer values, but it is normally not worth the effort or the potential confusion to do that.

The length for a character variable should be as long as you need to hold the longest value you expect. The maximum length for a character variable is 32767, but your will probably never need or want to use anything near that large.

Typically you will have some variables where you know the exact length, like a gender code or a yes/no variable. You will have other categorical or ID variables that are usually in the order of about 10 bytes. Maybe some others like names that need to be more like 50 bytes. And then a few open ended variables, like a comment, that might have to be longer.

If your data file is not large, less than a few million observations, then you don't need to worry too much about whether you will be wasting space by making the variables too long. But if you do make them too long you do risk the cost of confusing yourself about what they hold. Why define a variable than can only hold short single word values with a length of $200? If you do have a lot of long character variables then use the the system (or dataset) option COMPRESS=YES to save some space on the disk.

Also be careful as the the syntax of the length statement is that you can have one or more variable names and then a length specification. When there are more than one name in row without a length being specified between them then all of the variables will be set to the length that is listed. For example: LENGTH A B C1-C5 D E 8; would defined 9 numeric variables. This can be useful when you have many similar variables in a row and save some typing.

Tom · Posted 03-03-2018 09:54 PM

You still skipped the step of clicking on the {i} Insert Code button and pasting the lines of the log into the pop-box so that the formatting is preserved.

Here are the key things from your log (I tried to fix some of the formatted that was destroyed by not use the Insert Code function to paste in the lines.)

71 libname paper "~/425/425_Final_Paper";
NOTE: Libref PAPER was successfully assigned as follows:
...
74 PROC IMPORT out=paper.CompuStat_Execucomp
75 datafile="~/425/425_Final_Paper/CompuStat_Execucomp.csv"
76 DBMS=CSV replace;
77 getnames= yes;
78 run;
...
87 data PAPER.COMPUSTAT_EXECUCOMP ;
88 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
89 infile '~/425/425_Final_Paper/CompuStat_Execucomp.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
...
288 format CUSIP best12. ;
... 
NOTE: The infile '~/425/425_Final_Paper/CompuStat_Execucomp.csv' is:
...
 
NOTE: Invalid data for CUSIP in line 46 513-520.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
 46 Gerard J. Arpey,,1,0,0,0,,14221,AMERICAN AIRLINES GROUP INC,Chairman and Chief Executive Officer,CEO
101 ,669.646,0,3280.68,1185.94,0.467,721.282,94.66,5952.675,669.646,5952.675,1808.393,12991.194,30112.79
201 4,2455.718,,2455.718,,0,0,43.75,322.338,51,301,1185.94,3280.68,737,819.2,245.804,1217.996,835.54,650
301 8.857,856,6668.24,4711.65,0,0,0,0,0,0,0,1,,5231.393,4045.453,,,,,,,0,0,5.713,5.713,-15.069,10.77,7.4
401 45,,,1045,14591,2010,,20030425,,,20111128,,,,,Chairman and Chief Executive Officer,,Arpey,Gerard,J.,
501 MALE,Mr.,58,02376R10,NAS,4333 Amon Carter Boulevard,Fort Worth,TX,76155,817-963-1234,"AIR TRANSPORT,
601 SCHEDULED",Scheduled Passenger Air Transportation,Airlines,SP,AAL,817,481111,2030,4512 687
...
PAGE=58 CUSIP=. EXCHANGE=NAS ADDRESS=4333 Amon Carter 
...

So you can see that PROC IMPORT decided that CUSID should be a number, but then when it tried to read line 43 it found a value

02376R10

that has a letter in the middle.

You need to add GUESSINGROWS statement to your PROC IMPORT so that PROC IMPORT will see the letter R on line 43 and make the variable character instead.

Or better still get the documentation on the data and write a data step to read it that will define the variable as they are intended instead of guessing.

proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

Re: proc import - unsuccessful

2025 SAS Hackathon: There is still time!

SAS Training: Just a Click Away