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

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   ... View more

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 ... View more

great advice--thank you! ... View more

This is the error when I tried using xlsx so I just switched everything to cvs and got exactly what I was looking for. Thanks! ... View more

  Here are some screenshots. I am trying to retain the column names and all of the instnm column. And you are correct, I would like to for my export destination to be CSV. I will take ballardw's advice and change the outfile to this: outfile="/home/apmorabito0/my_courses/paper_c/arrests_schools.csv" ... View more

Thank you. ... View more

Great. I will try to implement these. Thank you. ... View more

I appreciate your feedback--let me be a bit more specific (and yes, I am quite lost in terms of creating the dummy variable as well). The variable "instnm" is a character variable. I would like to be able to compare the crime rates of FIPS with institutions (1) and without institutions (0). Here is the code again after deleting my edits:   data paper.arrests_schools; set paper.arrests_schools; presence=instnm; if instnm= then presence=1; if instnm= then presence=0; run;   Any further suggestions? I really appreciate the help ... View more