-----------------------------------------------------------------------------------------------------------------------------
name: <unnamed>
log: /Users/baum/Documents/Chuck/ ChuckLitGov2/proxy13_2_plus24.smcl
log type: smcl
opened on: 25 Apr 2010, 11:06:42
. * proxy13 calculate 24 months' CARA ending at filing date
. * cfb 8928 rev to append with original
. * cfb 9423 tweaked to handle 18-24 months
. * cfb 9B30 rev to back off to (-25, -1)
. * cfb 0424 altered to calculate abret 24 months after FD
.
. include proxy.doh
. local mp4 `c(processors_mach)'
. if `mp4' == 4 {
. cd "/Users/baum/Documents/chuck/ ChuckLitGov2/"
/Users/baum/Documents/Chuck/ ChuckLitGov2/
. }
. else {
. cd "/Users/baum/doc/ Chucky/ ChuckLitGov2/"
. }
.
.
. local infile proxy_proxyR2
. local outfile proxy_proxyCARAplus24
.
. use `infile', clear
.
. // fixup case_code
. replace case_code = "COVD_01" if case_code == "COVD-01"
(5 real changes made)
.
. egen tagc = tag(case_code)
. keep if tagc
(2003 observations deleted)
.
. g filing_m = int(mofd(filing_d))
. su filing_d filing_m
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
filing_d | 493 14782.88 737.5104 13174 16068
filing_m | 493 485.213 24.251 432 527
. tab filing_m
filing_m | Freq. Percent Cum.
------------+-----------------------------------
432 | 1 0.20 0.20
433 | 1 0.20 0.41
434 | 1 0.20 0.61
435 | 1 0.20 0.81
437 | 1 0.20 1.01
438 | 1 0.20 1.22
439 | 5 1.01 2.23
440 | 1 0.20 2.43
441 | 2 0.41 2.84
442 | 2 0.41 3.25
444 | 5 1.01 4.26
445 | 6 1.22 5.48
446 | 1 0.20 5.68
447 | 7 1.42 7.10
448 | 3 0.61 7.71
449 | 2 0.41 8.11
450 | 2 0.41 8.52
451 | 5 1.01 9.53
452 | 7 1.42 10.95
453 | 6 1.22 12.17
454 | 4 0.81 12.98
455 | 6 1.22 14.20
456 | 12 2.43 16.63
457 | 1 0.20 16.84
458 | 5 1.01 17.85
459 | 7 1.42 19.27
460 | 2 0.41 19.68
461 | 5 1.01 20.69
462 | 4 0.81 21.50
463 | 9 1.83 23.33
464 | 5 1.01 24.34
465 | 8 1.62 25.96
466 | 5 1.01 26.98
467 | 3 0.61 27.59
468 | 6 1.22 28.80
469 | 4 0.81 29.61
470 | 10 2.03 31.64
471 | 8 1.62 33.27
472 | 2 0.41 33.67
473 | 6 1.22 34.89
474 | 2 0.41 35.29
475 | 2 0.41 35.70
476 | 8 1.62 37.32
477 | 10 2.03 39.35
478 | 3 0.61 39.96
479 | 9 1.83 41.78
480 | 4 0.81 42.60
481 | 10 2.03 44.62
482 | 7 1.42 46.04
483 | 6 1.22 47.26
484 | 6 1.22 48.48
485 | 4 0.81 49.29
486 | 6 1.22 50.51
487 | 4 0.81 51.32
488 | 4 0.81 52.13
489 | 8 1.62 53.75
490 | 7 1.42 55.17
491 | 1 0.20 55.38
492 | 3 0.61 55.98
493 | 4 0.81 56.80
494 | 9 1.83 58.62
495 | 10 2.03 60.65
496 | 3 0.61 61.26
497 | 7 1.42 62.68
498 | 5 1.01 63.69
499 | 5 1.01 64.71
500 | 3 0.61 65.31
501 | 10 2.03 67.34
502 | 6 1.22 68.56
503 | 8 1.62 70.18
504 | 6 1.22 71.40
505 | 5 1.01 72.41
506 | 7 1.42 73.83
507 | 10 2.03 75.86
508 | 9 1.83 77.69
509 | 5 1.01 78.70
510 | 18 3.65 82.35
511 | 11 2.23 84.58
512 | 3 0.61 85.19
513 | 13 2.64 87.83
514 | 8 1.62 89.45
515 | 5 1.01 90.47
516 | 6 1.22 91.68
517 | 4 0.81 92.49
518 | 4 0.81 93.31
519 | 5 1.01 94.32
520 | 2 0.41 94.73
521 | 5 1.01 95.74
522 | 1 0.20 95.94
523 | 3 0.61 96.55
524 | 3 0.61 97.16
525 | 3 0.61 97.77
526 | 7 1.42 99.19
527 | 4 0.81 100.00
------------+-----------------------------------
Total | 493 100.00
.
. tab extd
extd | Freq. Percent Cum.
------------+-----------------------------------
0 | 371 75.25 75.25
1 | 122 24.75 100.00
------------+-----------------------------------
Total | 493 100.00
. desc
Contains data from proxy_proxyR2.dta
obs: 493
vars: 407 22 Apr 2010 10:21
size: 1,670,777 (99.7% of memory free)
-----------------------------------------------------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-----------------------------------------------------------------------------------------------------------------------------
source str8 %9s
mtgdate str11 %11s
proxy_status str8 %9s Proxy_status
missing_proxy~n str52 %52s Missing_proxy_reason
id str4 %9s
comnam str42 %42s
ticker str5 %9s
case_code str7 %9s
cusip str9 %9s
permno double %12.0g
year int %8.0g
suityear byte %8.0g Suit-Year
meeting_d float %td
proxy_d float %9.0g
filing_d float %td
casenr long %8.0g casenr
extd byte %8.0g
fname str19 %19s
lname str20 %20s
endofclassper~d str11 %11s End of Class Period
endwithinoney~r str3 %9s End within One Year
filingdate str11 %11s Filing date
filingwinoney~r str3 %9s Filing w/in one year
notescodes str22 %22s Notes Codes
notes str105 %105s Notes
isnotagoodcase str5 %9s Is not a good case?
goodactions byte %8.0g 1=good actions
endcp_d float %td
permco long %12.0g PERMCO
date long %12.0g DATE
ncusip str8 %9s NCUSIP
tickerC str5 %9s TICKER
firstobs byte %8.0g
ret396 double %11.0g 396 ret
abret396 double %10.0g 396 abret
ret397 double %11.0g 397 ret
abret397 double %10.0g 397 abret
ret398 double %11.0g 398 ret
abret398 double %10.0g 398 abret
ret399 double %11.0g 399 ret
abret399 double %10.0g 399 abret
ret400 double %11.0g 400 ret
abret400 double %10.0g 400 abret
ret401 double %11.0g 401 ret
abret401 double %10.0g 401 abret
ret402 double %11.0g 402 ret
abret402 double %10.0g 402 abret
ret403 double %11.0g 403 ret
abret403 double %10.0g 403 abret
ret404 double %11.0g 404 ret
abret404 double %10.0g 404 abret
ret405 double %11.0g 405 ret
abret405 double %10.0g 405 abret
ret406 double %11.0g 406 ret
abret406 double %10.0g 406 abret
ret407 double %11.0g 407 ret
abret407 double %10.0g 407 abret
ret408 double %11.0g 408 ret
abret408 double %10.0g 408 abret
ret409 double %11.0g 409 ret
abret409 double %10.0g 409 abret
ret410 double %11.0g 410 ret
abret410 double %10.0g 410 abret
ret411 double %11.0g 411 ret
abret411 double %10.0g 411 abret
ret412 double %11.0g 412 ret
abret412 double %10.0g 412 abret
ret413 double %11.0g 413 ret
abret413 double %10.0g 413 abret
ret414 double %11.0g 414 ret
abret414 double %10.0g 414 abret
ret415 double %11.0g 415 ret
abret415 double %10.0g 415 abret
ret416 double %11.0g 416 ret
abret416 double %10.0g 416 abret
ret417 double %11.0g 417 ret
abret417 double %10.0g 417 abret
ret418 double %11.0g 418 ret
abret418 double %10.0g 418 abret
ret419 double %11.0g 419 ret
abret419 double %10.0g 419 abret
ret420 double %11.0g 420 ret
abret420 double %10.0g 420 abret
ret421 double %11.0g 421 ret
abret421 double %10.0g 421 abret
ret422 double %11.0g 422 ret
abret422 double %10.0g 422 abret
ret423 double %11.0g 423 ret
abret423 double %10.0g 423 abret
ret424 double %11.0g 424 ret
abret424 double %10.0g 424 abret
ret425 double %11.0g 425 ret
abret425 double %10.0g 425 abret
ret426 double %11.0g 426 ret
abret426 double %10.0g 426 abret
ret427 double %11.0g 427 ret
abret427 double %10.0g 427 abret
ret428 double %11.0g 428 ret
abret428 double %10.0g 428 abret
ret429 double %11.0g 429 ret
abret429 double %10.0g 429 abret
ret430 double %11.0g 430 ret
abret430 double %10.0g 430 abret
ret431 double %11.0g 431 ret
abret431 double %10.0g 431 abret
ret432 double %11.0g 432 ret
abret432 double %10.0g 432 abret
ret433 double %11.0g 433 ret
abret433 double %10.0g 433 abret
ret434 double %11.0g 434 ret
abret434 double %10.0g 434 abret
ret435 double %11.0g 435 ret
abret435 double %10.0g 435 abret
ret436 double %11.0g 436 ret
abret436 double %10.0g 436 abret
ret437 double %11.0g 437 ret
abret437 double %10.0g 437 abret
ret438 double %11.0g 438 ret
abret438 double %10.0g 438 abret
ret439 double %11.0g 439 ret
abret439 double %10.0g 439 abret
ret440 double %11.0g 440 ret
abret440 double %10.0g 440 abret
ret441 double %11.0g 441 ret
abret441 double %10.0g 441 abret
ret442 double %11.0g 442 ret
abret442 double %10.0g 442 abret
ret443 double %11.0g 443 ret
abret443 double %10.0g 443 abret
ret444 double %11.0g 444 ret
abret444 double %10.0g 444 abret
ret445 double %11.0g 445 ret
abret445 double %10.0g 445 abret
ret446 double %11.0g 446 ret
abret446 double %10.0g 446 abret
ret447 double %11.0g 447 ret
abret447 double %10.0g 447 abret
ret448 double %11.0g 448 ret
abret448 double %10.0g 448 abret
ret449 double %11.0g 449 ret
abret449 double %10.0g 449 abret
ret450 double %11.0g 450 ret
abret450 double %10.0g 450 abret
ret451 double %11.0g 451 ret
abret451 double %10.0g 451 abret
ret452 double %11.0g 452 ret
abret452 double %10.0g 452 abret
ret453 double %11.0g 453 ret
abret453 double %10.0g 453 abret
ret454 double %11.0g 454 ret
abret454 double %10.0g 454 abret
ret455 double %11.0g 455 ret
abret455 double %10.0g 455 abret
ret456 double %11.0g 456 ret
abret456 double %10.0g 456 abret
ret457 double %11.0g 457 ret
abret457 double %10.0g 457 abret
ret458 double %11.0g 458 ret
abret458 double %10.0g 458 abret
ret459 double %11.0g 459 ret
abret459 double %10.0g 459 abret
ret460 double %11.0g 460 ret
abret460 double %10.0g 460 abret
ret461 double %11.0g 461 ret
abret461 double %10.0g 461 abret
ret462 double %11.0g 462 ret
abret462 double %10.0g 462 abret
ret463 double %11.0g 463 ret
abret463 double %10.0g 463 abret
ret464 double %11.0g 464 ret
abret464 double %10.0g 464 abret
ret465 double %11.0g 465 ret
abret465 double %10.0g 465 abret
ret466 double %11.0g 466 ret
abret466 double %10.0g 466 abret
ret467 double %11.0g 467 ret
abret467 double %10.0g 467 abret
ret468 double %11.0g 468 ret
abret468 double %10.0g 468 abret
ret469 double %11.0g 469 ret
abret469 double %10.0g 469 abret
ret470 double %11.0g 470 ret
abret470 double %10.0g 470 abret
ret471 double %11.0g 471 ret
abret471 double %10.0g 471 abret
ret472 double %11.0g 472 ret
abret472 double %10.0g 472 abret
ret473 double %11.0g 473 ret
abret473 double %10.0g 473 abret
ret474 double %11.0g 474 ret
abret474 double %10.0g 474 abret
ret475 double %11.0g 475 ret
abret475 double %10.0g 475 abret
ret476 double %11.0g 476 ret
abret476 double %10.0g 476 abret
ret477 double %11.0g 477 ret
abret477 double %10.0g 477 abret
ret478 double %11.0g 478 ret
abret478 double %10.0g 478 abret
ret479 double %11.0g 479 ret
abret479 double %10.0g 479 abret
ret480 double %11.0g 480 ret
abret480 double %10.0g 480 abret
ret481 double %11.0g 481 ret
abret481 double %10.0g 481 abret
ret482 double %11.0g 482 ret
abret482 double %10.0g 482 abret
ret483 double %11.0g 483 ret
abret483 double %10.0g 483 abret
ret484 double %11.0g 484 ret
abret484 double %10.0g 484 abret
ret485 double %11.0g 485 ret
abret485 double %10.0g 485 abret
ret486 double %11.0g 486 ret
abret486 double %10.0g 486 abret
ret487 double %11.0g 487 ret
abret487 double %10.0g 487 abret
ret488 double %11.0g 488 ret
abret488 double %10.0g 488 abret
ret489 double %11.0g 489 ret
abret489 double %10.0g 489 abret
ret490 double %11.0g 490 ret
abret490 double %10.0g 490 abret
ret491 double %11.0g 491 ret
abret491 double %10.0g 491 abret
ret492 double %11.0g 492 ret
abret492 double %10.0g 492 abret
ret493 double %11.0g 493 ret
abret493 double %10.0g 493 abret
ret494 double %11.0g 494 ret
abret494 double %10.0g 494 abret
ret495 double %11.0g 495 ret
abret495 double %10.0g 495 abret
ret496 double %11.0g 496 ret
abret496 double %10.0g 496 abret
ret497 double %11.0g 497 ret
abret497 double %10.0g 497 abret
ret498 double %11.0g 498 ret
abret498 double %10.0g 498 abret
ret499 double %11.0g 499 ret
abret499 double %10.0g 499 abret
ret500 double %11.0g 500 ret
abret500 double %10.0g 500 abret
ret501 double %11.0g 501 ret
abret501 double %10.0g 501 abret
ret502 double %11.0g 502 ret
abret502 double %10.0g 502 abret
ret503 double %11.0g 503 ret
abret503 double %10.0g 503 abret
ret504 double %11.0g 504 ret
abret504 double %10.0g 504 abret
ret505 double %11.0g 505 ret
abret505 double %10.0g 505 abret
ret506 double %11.0g 506 ret
abret506 double %10.0g 506 abret
ret507 double %11.0g 507 ret
abret507 double %10.0g 507 abret
ret508 double %11.0g 508 ret
abret508 double %10.0g 508 abret
ret509 double %11.0g 509 ret
abret509 double %10.0g 509 abret
ret510 double %11.0g 510 ret
abret510 double %10.0g 510 abret
ret511 double %11.0g 511 ret
abret511 double %10.0g 511 abret
ret512 double %11.0g 512 ret
abret512 double %10.0g 512 abret
ret513 double %11.0g 513 ret
abret513 double %10.0g 513 abret
ret514 double %11.0g 514 ret
abret514 double %10.0g 514 abret
ret515 double %11.0g 515 ret
abret515 double %10.0g 515 abret
ret516 double %11.0g 516 ret
abret516 double %10.0g 516 abret
ret517 double %11.0g 517 ret
abret517 double %10.0g 517 abret
ret518 double %11.0g 518 ret
abret518 double %10.0g 518 abret
ret519 double %11.0g 519 ret
abret519 double %10.0g 519 abret
ret520 double %11.0g 520 ret
abret520 double %10.0g 520 abret
ret521 double %11.0g 521 ret
abret521 double %10.0g 521 abret
ret522 double %11.0g 522 ret
abret522 double %10.0g 522 abret
ret523 double %11.0g 523 ret
abret523 double %10.0g 523 abret
ret524 double %11.0g 524 ret
abret524 double %10.0g 524 abret
ret525 double %11.0g 525 ret
abret525 double %10.0g 525 abret
ret526 double %11.0g 526 ret
abret526 double %10.0g 526 abret
ret527 double %11.0g 527 ret
abret527 double %10.0g 527 abret
ret528 double %11.0g 528 ret
abret528 double %10.0g 528 abret
ret529 double %11.0g 529 ret
abret529 double %10.0g 529 abret
ret530 double %11.0g 530 ret
abret530 double %10.0g 530 abret
ret531 double %11.0g 531 ret
abret531 double %10.0g 531 abret
ret532 double %11.0g 532 ret
abret532 double %10.0g 532 abret
ret533 double %11.0g 533 ret
abret533 double %10.0g 533 abret
ret534 double %11.0g 534 ret
abret534 double %10.0g 534 abret
ret535 double %11.0g 535 ret
abret535 double %10.0g 535 abret
ret536 double %11.0g 536 ret
abret536 double %10.0g 536 abret
ret537 double %11.0g 537 ret
abret537 double %10.0g 537 abret
ret538 double %11.0g 538 ret
abret538 double %10.0g 538 abret
ret539 double %11.0g 539 ret
abret539 double %10.0g 539 abret
ret540 double %11.0g 540 ret
abret540 double %10.0g 540 abret
ret541 double %11.0g 541 ret
abret541 double %10.0g 541 abret
ret542 double %11.0g 542 ret
abret542 double %10.0g 542 abret
ret543 double %11.0g 543 ret
abret543 double %10.0g 543 abret
ret544 double %11.0g 544 ret
abret544 double %10.0g 544 abret
ret545 double %11.0g 545 ret
abret545 double %10.0g 545 abret
ret546 double %11.0g 546 ret
abret546 double %10.0g 546 abret
ret547 double %11.0g 547 ret
abret547 double %10.0g 547 abret
ret548 double %11.0g 548 ret
abret548 double %10.0g 548 abret
ret549 double %11.0g 549 ret
abret549 double %10.0g 549 abret
ret550 double %11.0g 550 ret
abret550 double %10.0g 550 abret
ret551 double %11.0g 551 ret
abret551 double %10.0g 551 abret
ret552 double %11.0g 552 ret
abret552 double %10.0g 552 abret
ret553 double %11.0g 553 ret
abret553 double %10.0g 553 abret
ret554 double %11.0g 554 ret
abret554 double %10.0g 554 abret
ret555 double %11.0g 555 ret
abret555 double %10.0g 555 abret
ret556 double %11.0g 556 ret
abret556 double %10.0g 556 abret
ret557 double %11.0g 557 ret
abret557 double %10.0g 557 abret
ret558 double %11.0g 558 ret
abret558 double %10.0g 558 abret
ret559 double %11.0g 559 ret
abret559 double %10.0g 559 abret
ret560 double %11.0g 560 ret
abret560 double %10.0g 560 abret
ret561 double %11.0g 561 ret
abret561 double %10.0g 561 abret
ret562 double %11.0g 562 ret
abret562 double %10.0g 562 abret
ret563 double %11.0g 563 ret
abret563 double %10.0g 563 abret
ret564 double %11.0g 564 ret
abret564 double %10.0g 564 abret
ret565 double %11.0g 565 ret
abret565 double %10.0g 565 abret
ret566 double %11.0g 566 ret
abret566 double %10.0g 566 abret
ret567 double %11.0g 567 ret
abret567 double %10.0g 567 abret
ret568 double %11.0g 568 ret
abret568 double %10.0g 568 abret
ret569 double %11.0g 569 ret
abret569 double %10.0g 569 abret
ret570 double %11.0g 570 ret
abret570 double %10.0g 570 abret
ret571 double %11.0g 571 ret
abret571 double %10.0g 571 abret
ret572 double %11.0g 572 ret
abret572 double %10.0g 572 abret
ret573 double %11.0g 573 ret
abret573 double %10.0g 573 abret
ret574 double %11.0g 574 ret
abret574 double %10.0g 574 abret
ret575 double %11.0g 575 ret
abret575 double %10.0g 575 abret
ret576 double %11.0g 576 ret
abret576 double %10.0g 576 abret
ret577 double %11.0g 577 ret
abret577 double %10.0g 577 abret
ret578 double %11.0g 578 ret
abret578 double %10.0g 578 abret
ret579 double %11.0g 579 ret
abret579 double %10.0g 579 abret
ret580 double %11.0g 580 ret
abret580 double %10.0g 580 abret
ret581 double %11.0g 581 ret
abret581 double %10.0g 581 abret
tagc byte %8.0g tag(case_code)
filing_m float %9.0g
-----------------------------------------------------------------------------------------------------------------------------
Sorted by:
Note: dataset has changed since last saved
. // su
.
. levelsof casenr, local(cases)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
> 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
> 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120
> 121 122 123 124 125 126 127 128 129 130 131 132 133 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 15
> 2 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 1
> 83 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213
> 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244
> 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 27
> 5 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 3
> 06 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336
> 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367
> 368 369 370 371 372 373 374
. local monback 23
. local monahead 23
. local adjok 6
. local lomo 396
. // modified to consider abret > FD
. local himo 581
.
. keep if suityear == 0
(0 observations deleted)
.
. // tabstat filing_d, by(case_code) stat(N)
.
. gen double cara = .
(493 missing values generated)
. g obsnr = _n
. foreach c of local cases {
2.
. // 9422: determine range of available abret
. local minavail = `lomo'
3. forv i = `lomo'/`himo' {
4. su abret`i' if casenr == `c', mean
5. if r(N) > 0 {
6. local minavail = `i'
7. continue, break
8. }
9. }
10. local maxavail = `himo'
11. forv i = `himo'(-1)`lomo' {
12. su abret`i' if casenr == `c', mean
13. if r(N) > 0 {
14. local maxavail = `i'
15. continue, break
16. }
17. }
18. // local maxavail = cond(`maxavail' < `himo', `maxavail' + 1, `maxavail')
. local maxavail = cond(`minavail' == `maxavail', `himo', `maxavail')
19. local minavail = cond(`minavail' == `maxavail', `lomo', `minavail')
20.
. summ filing_m if casenr == `c', meanonly
21.
. local fdst = r(min) + 1
22. // local fdst = `fdend' - `monback'
. local fdend = `fdst' + `monahead'
23.
. // local fdst = cond(`fdst' < `minavail' & `minavail' - `fdst' <= `adjok', ///
. // `minavail', `fdst')
. local fdend = cond(`fdend' > `maxavail' & `fdend' - `maxavail' <= `adjok', ///
> `maxavail', `fdend')
24. local ok = cond(`fdst' >= `minavail' & `fdend' <= `maxavail', " ok ", " FAIL ")
25. su obsnr if casenr == `c', mean
26. local cc = case_code[`r(min)']
27. di as err "`c' `cc' min/max avail `minavail' `maxavail' need `fdst' `fdend' `ok'" %tm `fdst' " " %tm
> `fdend'
28. // fix here too
. qui replace cara = 0 if casenr==`c' & filing_m == `fdst' - 1
29. forv i=`fdst'/`fdend' {
30. qui replace cara = cara + abret`i' if casenr==`c'
31. // di "`i' abret`i'"
. // su cara if casenr == `c'
.
. // qui replace cara = cara + cond(!mi(abret`i'), abret`i', 0) if casenr==`c'
. }
32. }
1 AAM__01 min/max avail 396 581 need 453 476 ok 1997m10 1999m9
2 ABIG_01 min/max avail 396 581 need 457 480 ok 1998m2 2000m1
3 ACDO_01 min/max avail 396 581 need 472 495 ok 1999m5 2001m4
4 ACTN_01 min/max avail 400 550 need 479 502 ok 1999m12 2001m11
5 ACXM_01 min/max avail 396 581 need 477 500 ok 1999m10 2001m9
6 ADAC_01 min/max avail 396 581 need 468 491 ok 1999m1 2000m12
7 ADAP_01 min/max avail 396 495 need 459 482 ok 1998m4 2000m3
8 ADBE_01 min/max avail 396 581 need 434 457 ok 1996m3 1998m2
9 ADPT_01 min/max avail 396 581 need 457 480 ok 1998m2 2000m1
10 ADRX_01 min/max avail 407 581 need 507 530 ok 2002m4 2004m3
11 ADSK_01 min/max avail 396 581 need 483 506 ok 2000m4 2002m3
12 ADVNA01 min/max avail 396 581 need 450 473 ok 1997m7 1999m6
13 AEP__01 min/max avail 396 581 need 446 469 ok 1997m3 1999m2
14 AES__01 min/max avail 396 581 need 482 505 ok 2000m3 2002m2
15 AET__01 min/max avail 396 496 need 453 476 ok 1997m10 1999m9
16 AET__02 min/max avail 396 581 need 503 526 ok 2001m12 2003m11
17 AHC__01 min/max avail 396 581 need 477 500 ok 1999m10 2001m9
18 AVY__01 min/max avail 396 581 need 521 544 ok 2003m6 2005m5
19 AHP__01 min/max avail 396 581 need 453 476 ok 1997m10 1999m9
20 AKS__01 min/max avail 411 581 need 484 507 ok 2000m5 2002m4
21 ALLP_01 min/max avail 396 581 need 495 518 ok 2001m4 2003m3
22 ALO__01 min/max avail 396 581 need 491 514 ok 2000m12 2002m11
23 AMCC_01 min/max avail 455 581 need 496 519 ok 2001m5 2003m4
24 AMGN_01 min/max avail 396 581 need 452 475 ok 1997m9 1999m8
25 AMZN_01 min/max avail 424 581 need 477 500 ok 1999m10 2001m9
26 ANF__01 min/max avail 396 581 need 478 501 ok 1999m11 2001m10
27 ANN__01 min/max avail 396 581 need 436 459 ok 1996m5 1998m4
28 AOC__01 min/max avail 396 581 need 512 535 ok 2002m9 2004m8
29 CHK__01 min/max avail 398 581 need 452 475 ok 1997m9 1999m8
30 APD__01 min/max avail 396 581 need 449 472 ok 1997m6 1999m5
31 ARTG_01 min/max avail 446 581 need 464 487 ok 1998m9 2000m8
32 ASHW_01 min/max avail 396 581 need 469 492 ok 1999m2 2001m1
33 ASM__01 min/max avail 396 581 need 463 486 ok 1998m8 2000m7
34 ASND_01 min/max avail 413 581 need 456 479 ok 1998m1 1999m12
35 ASO__01 min/max avail 396 561 need 440 463 ok 1996m9 1998m8
36 ATHM_01 min/max avail 396 581 need 463 486 ok 1998m8 2000m7
37 ATIS_01 min/max avail 396 581 need 462 485 ok 1998m7 2000m6
38 ATX__01 min/max avail 396 581 need 472 495 ok 1999m5 2001m4
39 AVA__01 min/max avail 396 581 need 487 510 ok 2000m8 2002m7
40 AWA__01 min/max avail 398 581 need 471 494 ok 1999m4 2001m3
41 AWE__01 min/max avail 435 536 need 471 494 ok 1999m4 2001m3
42 AXP__01 min/max avail 396 581 need 478 501 ok 1999m11 2001m10
43 BAC__01 min/max avail 396 482 need 450 473 ok 1997m7 1999m6
44 BAX__01 min/max avail 396 581 need 502 525 ok 2001m11 2003m10
45 BAY__01 min/max avail 396 581 need 440 463 ok 1996m9 1998m8
46 BA___01 min/max avail 396 581 need 454 477 ok 1997m11 1999m10
47 BBC__01 min/max avail 396 581 need 478 501 ok 1999m11 2001m10
48 BBI__01 min/max avail 396 571 need 446 469 ok 1997m3 1999m2
49 BEV__01 min/max avail 406 553 need 461 484 ok 1998m6 2000m5
50 BHE__01 min/max avail 396 581 need 479 502 ok 1999m12 2001m11
51 BHI__01 min/max avail 396 581 need 480 503 ok 2000m1 2001m12
52 BID__01 min/max avail 396 581 need 435 458 ok 1996m4 1998m3
53 BLS__01 min/max avail 396 581 need 512 535 ok 2002m9 2004m8
54 BMCS_01 min/max avail 396 581 need 451 474 ok 1997m8 1999m7
55 BMY__01 min/max avail 396 581 need 440 463 ok 1996m9 1998m8
56 BOL__01 min/max avail 396 572 need 496 519 ok 2001m5 2003m4
57 BRCM_01 min/max avail 396 581 need 443 466 ok 1996m12 1998m11
58 BRW__01 min/max avail 396 581 need 514 537 ok 2002m11 2004m10
59 BSX__01 min/max avail 396 581 need 467 490 ok 1998m12 2000m11
60 BTGC_01 min/max avail 396 581 need 440 463 ok 1996m9 1998m8
61 BT___01 min/max avail 396 579 need 457 480 ok 1998m2 2000m1
62 BVSN_01 min/max avail 396 581 need 496 519 ok 2001m5 2003m4
63 CAG__01 min/max avail 396 581 need 500 523 ok 2001m9 2003m8
64 CATP_01 min/max avail 396 497 need 471 494 ok 1999m4 2001m3
65 CA___01 min/max avail 396 581 need 463 486 ok 1998m8 2000m7
66 CB___01 min/max avail 396 581 need 448 471 ok 1997m5 1999m4
67 CCL__01 min/max avail 396 581 need 482 505 ok 2000m3 2002m2
68 CC___01 min/max avail 396 581 need 508 531 ok 2002m5 2004m4
69 CDE__01 min/max avail 396 581 need 451 474 ok 1997m8 1999m7
70 CDN__01 min/max avail 396 581 need 472 495 ok 1999m5 2001m4
71 CDO__01 min/max avail 396 515 need 495 515 ok 2001m4 2002m12
72 CEFT_01 min/max avail 396 581 need 480 503 ok 2000m1 2001m12
73 CELL_01 min/max avail 412 581 need 474 497 ok 1999m7 2001m6
74 CEN__01 min/max avail 396 581 need 453 476 ok 1997m10 1999m9
75 CGO__01 min/max avail 396 581 need 514 537 ok 2002m11 2004m10
76 CHB__01 min/max avail 396 581 need 474 497 ok 1999m7 2001m6
77 CITU_01 min/max avail 396 521 need 452 475 ok 1997m9 1999m8
78 CI___01 min/max avail 396 581 need 514 537 ok 2002m11 2004m10
79 CLST_01 min/max avail 408 565 need 457 480 ok 1998m2 2000m1
80 CLX__01 min/max avail 396 581 need 478 501 ok 1999m11 2001m10
81 CMA__01 min/max avail 396 581 need 514 537 ok 2002m11 2004m10
82 CMGI_01 min/max avail 409 581 need 512 535 ok 2002m9 2004m8
83 CMS__01 min/max avail 396 581 need 466 489 ok 1998m11 2000m10
84 CMVT_01 min/max avail 396 581 need 496 519 ok 2001m5 2003m4
85 CNC__01 min/max avail 396 510 need 461 484 ok 1998m6 2000m5
86 CNTO_01 min/max avail 396 540 need 457 480 ok 1998m2 2000m1
87 COF__01 min/max avail 419 581 need 511 534 ok 2002m8 2004m7
88 COL__01 min/max avail 396 581 need 448 471 ok 1997m5 1999m4
89 COMS_01 min/max avail 396 581 need 447 470 ok 1997m4 1999m3
90 CORR_01 min/max avail 396 504 need 457 480 ok 1998m2 2000m1
91 COVD_01 min/max avail 458 581 need 490 513 ok 2000m11 2002m10
92 CPB__01 min/max avail 396 581 need 481 504 ok 2000m2 2002m1
93 CPN__01 min/max avail 417 581 need 472 495 ok 1999m5 2001m4
94 CPQ__01 min/max avail 396 507 need 460 483 ok 1998m5 2000m4
95 CPRO_01 min/max avail 396 581 need 459 482 ok 1998m4 2000m3
96 CPU__01 min/max avail 396 581 need 460 483 ok 1998m5 2000m4
97 CPWR_01 min/max avail 396 581 need 454 477 ok 1997m11 1999m10
98 CRR__01 min/max avail 396 581 need 446 469 ok 1997m3 1999m2
99 CRY__01 min/max avail 398 581 need 466 489 ok 1998m11 2000m10
100 CSCO_01 min/max avail 396 581 need 496 519 ok 2001m5 2003m4
101 CS___01 min/max avail 396 563 need 454 477 ok 1997m11 1999m10
102 CTXS_01 min/max avail 432 581 need 486 509 ok 2000m7 2002m6
103 CU___01 min/max avail 396 581 need 460 483 ok 1998m5 2000m4
104 CVS__01 min/max avail 396 581 need 500 523 ok 2001m9 2003m8
105 CYGN_01 min/max avail 396 581 need 465 488 ok 1998m10 2000m9
106 CYTC_01 min/max avail 404 572 need 490 513 ok 2000m11 2002m10
107 C____01 min/max avail 396 581 need 464 487 ok 1998m9 2000m8
108 DFS__01 min/max avail 396 581 need 452 475 ok 1997m9 1999m8
109 DG___01 min/max avail 396 581 need 496 519 ok 2001m5 2003m4
110 DIS__01 min/max avail 396 581 need 433 456 ok 1996m2 1998m1
111 DOW__01 min/max avail 396 581 need 485 508 ok 2000m6 2002m5
112 DPL__01 min/max avail 396 581 need 512 535 ok 2002m9 2004m8
113 DTII_01 min/max avail 412 581 need 485 508 ok 2000m6 2002m5
114 DUK__01 min/max avail 396 581 need 471 494 ok 1999m4 2001m3
115 DURA_01 min/max avail 396 522 need 469 492 ok 1999m2 2001m1
116 DYN__01 min/max avail 420 581 need 508 531 ok 2002m5 2004m4
117 EDS__01 min/max avail 438 581 need 484 507 ok 2000m5 2002m4
118 EFII_01 min/max avail 396 581 need 449 472 ok 1997m6 1999m5
119 EIX__01 min/max avail 396 581 need 460 483 ok 1998m5 2000m4
120 EMLX_01 min/max avail 396 581 need 494 517 ok 2001m3 2003m2
121 ENE__01 min/max avail 396 581 need 502 525 ok 2001m11 2003m10
122 ENTU_01 min/max avail 408 581 need 487 510 ok 2000m8 2002m7
123 ENVY_01 min/max avail 396 581 need 464 487 ok 1998m9 2000m8
124 EP___01 min/max avail 396 581 need 511 534 ok 2002m8 2004m7
125 ESST_01 min/max avail 396 581 need 513 536 ok 2002m10 2004m9
126 ETS__01 min/max avail 396 581 need 506 529 ok 2002m3 2004m2
127 EWB__01 min/max avail 401 496 need 494 517 FAIL 2001m3 2003m2
128 EXC__01 min/max avail 396 581 need 509 532 ok 2002m6 2004m5
129 EXDS_01 min/max avail 459 499 need 499 522 FAIL 2001m8 2003m7
130 FCAA_01 min/max avail 396 525 need 446 469 ok 1997m3 1999m2
131 FD___01 min/max avail 396 581 need 488 511 ok 2000m9 2002m8
132 FGCI_01 min/max avail 419 483 need 482 505 FAIL 2000m3 2002m2
133 FHPC_01 min/max avail 396 444 need 448 471 FAIL 1997m5 1999m4
135 FLR__01 min/max avail 396 581 need 454 477 ok 1997m11 1999m10
136 FMO__01 min/max avail 396 506 need 486 506 ok 2000m7 2002m3
137 FMXI_01 min/max avail 408 547 need 472 495 ok 1999m5 2001m4
138 FNV__01 min/max avail 396 504 need 483 504 ok 2000m4 2002m1
139 FON__01 min/max avail 396 581 need 498 521 ok 2001m7 2003m6
140 FP___01 min/max avail 434 471 need 466 489 FAIL 1998m11 2000m10
141 FRTR_01 min/max avail 396 492 need 487 510 FAIL 2000m8 2002m7
142 FTL__01 min/max avail 396 482 need 462 482 ok 1998m7 2000m3
143 FTS__01 min/max avail 442 526 need 515 538 FAIL 2002m12 2004m11
144 FTU__01 min/max avail 396 581 need 474 497 ok 1999m7 2001m6
145 F____01 min/max avail 396 581 need 489 512 ok 2000m10 2002m9
146 GAP__01 min/max avail 396 581 need 510 533 ok 2002m7 2004m6
147 GAS__01 min/max avail 396 581 need 511 534 ok 2002m8 2004m7
148 GBFE_01 min/max avail 396 468 need 464 487 FAIL 1998m9 2000m8
149 GEN__01 min/max avail 396 500 need 460 483 ok 1998m5 2000m4
150 GFD__01 min/max avail 396 504 need 466 489 ok 1998m11 2000m10
151 GLC__01 min/max avail 451 500 need 466 489 ok 1998m11 2000m10
152 GLW__01 min/max avail 396 581 need 504 527 ok 2002m1 2003m12
153 GND__01 min/max avail 396 467 need 441 464 ok 1996m10 1998m9
154 GNT__01 min/max avail 396 461 need 456 479 FAIL 1998m1 1999m12
155 GRB__01 min/max avail 396 581 need 508 531 ok 2002m5 2004m4
156 GSPN_01 min/max avail 474 529 need 503 526 ok 2001m12 2003m11
157 GTK__01 min/max avail 396 558 need 488 511 ok 2000m9 2002m8
158 GTW__01 min/max avail 408 572 need 492 515 ok 2001m1 2002m12
159 GWF__01 min/max avail 396 449 need 438 461 FAIL 1996m7 1998m6
160 GX___01 min/max avail 464 503 need 506 529 FAIL 2002m3 2004m2
161 HAL__01 min/max avail 396 581 need 510 533 ok 2002m7 2004m6
162 HAZ__01 min/max avail 439 502 need 502 525 FAIL 2001m11 2003m10
163 HC___01 min/max avail 451 570 need 505 528 ok 2002m2 2004m1
164 HGR__01 min/max avail 396 581 need 491 514 ok 2000m12 2002m11
165 HI___01 min/max avail 396 517 need 512 535 FAIL 2002m9 2004m8
166 HMT__01 min/max avail 396 581 need 470 493 ok 1999m3 2001m2
167 HMX__01 min/max avail 396 581 need 502 525 ok 2001m11 2003m10
168 HNCS_01 min/max avail 426 510 need 508 531 FAIL 2002m5 2004m4
169 HOMS_01 min/max avail 476 581 need 504 527 ok 2002m1 2003m12
170 HON__01 min/max avail 396 581 need 487 510 ok 2000m8 2002m7
171 HPH__01 min/max avail 396 478 need 462 485 FAIL 1998m7 2000m6
172 HRBC_01 min/max avail 428 484 need 477 500 FAIL 1999m10 2001m9
173 HRB__01 min/max avail 396 581 need 515 538 ok 2002m12 2004m11
174 HRC__01 min/max avail 396 581 need 465 488 ok 1998m10 2000m9
175 HRC__02 min/max avail 396 581 need 512 535 ok 2002m9 2004m8
176 HUM__01 min/max avail 396 581 need 474 497 ok 1999m7 2001m6
177 HWP__01 min/max avail 396 581 need 504 527 ok 2002m1 2003m12
178 IBP__01 min/max avail 396 500 need 482 500 ok 2000m3 2001m9
179 ICIX_01 min/max avail 396 497 need 493 516 FAIL 2001m2 2003m1
180 ICN__01 min/max avail 396 581 need 511 534 ok 2002m8 2004m7
181 IDXX_01 min/max avail 396 581 need 457 480 ok 1998m2 2000m1
182 IKN__01 min/max avail 396 581 need 464 487 ok 1998m9 2000m8
183 IMCL_01 min/max avail 396 581 need 505 528 ok 2002m2 2004m1
184 IMNR_01 min/max avail 396 549 need 499 522 ok 2001m8 2003m7
185 IMNX_01 min/max avail 396 509 need 504 527 FAIL 2002m1 2003m12
186 INSP_01 min/max avail 468 581 need 498 521 ok 2001m7 2003m6
187 INTC_01 min/max avail 396 581 need 501 524 ok 2001m10 2003m9
188 INTV_01 min/max avail 396 581 need 498 521 ok 2001m7 2003m6
189 IOM__01 min/max avail 396 580 need 458 481 ok 1998m3 2000m2
190 IO___01 min/max avail 396 581 need 453 476 ok 1997m10 1999m9
191 IPG__01 min/max avail 396 581 need 512 535 ok 2002m9 2004m8
192 IR___01 min/max avail 396 581 need 504 527 ok 2002m1 2003m12
193 ISSX_01 min/max avail 459 560 need 501 524 ok 2001m10 2003m9
194 ITRI_01 min/max avail 407 581 need 449 472 ok 1997m6 1999m5
195 ITWO_01 min/max avail 436 581 need 495 518 ok 2001m4 2003m3
196 IVX__01 min/max avail 396 551 need 439 462 ok 1996m8 1998m7
197 JDEC_01 min/max avail 453 522 need 477 500 ok 1999m10 2001m9
198 JDSU_01 min/max avail 407 581 need 507 530 ok 2002m4 2004m3
199 JNJ__01 min/max avail 396 581 need 511 534 ok 2002m8 2004m7
200 JNPR_01 min/max avail 474 581 need 505 528 ok 2002m2 2004m1
201 JPM__01 min/max avail 396 581 need 506 529 ok 2002m3 2004m2
202 KANA_01 min/max avail 477 548 need 499 522 ok 2001m8 2003m7
203 KM___01 min/max avail 396 514 need 507 530 FAIL 2002m4 2004m3
204 KNE__01 min/max avail 396 567 need 483 506 ok 2000m4 2002m3
205 KO___01 min/max avail 396 581 need 490 513 ok 2000m11 2002m10
206 KR___01 min/max avail 396 581 need 497 520 ok 2001m6 2003m5
207 KSE__01 min/max avail 396 570 need 500 523 ok 2001m9 2003m8
208 LENS_01 min/max avail 396 581 need 508 531 ok 2002m5 2004m4
209 LGTO_01 min/max avail 427 524 need 481 504 ok 2000m2 2002m1
210 LMT__01 min/max avail 396 581 need 469 492 ok 1999m2 2001m1
211 LSON_01 min/max avail 442 488 need 480 503 FAIL 2000m1 2001m12
212 LTRE_01 min/max avail 432 581 need 460 483 ok 1998m5 2000m4
213 LU___01 min/max avail 436 562 need 482 505 ok 2000m3 2002m2
214 LXK__01 min/max avail 431 581 need 503 526 ok 2001m12 2003m11
215 MAT__01 min/max avail 396 581 need 478 501 ok 1999m11 2001m10
216 MCK__01 min/max avail 420 581 need 472 495 ok 1999m5 2001m4
217 MCLD_01 min/max avail 438 503 need 505 528 FAIL 2002m2 2004m1
218 MDR__01 min/max avail 396 581 need 480 503 ok 2000m1 2001m12
219 MER__01 min/max avail 396 581 need 511 534 ok 2002m8 2004m7
220 MFNX_01 min/max avail 454 507 need 500 523 FAIL 2001m9 2003m8
221 MFN__01 min/max avail 396 459 need 445 468 FAIL 1997m2 1999m1
222 MIR__01 min/max avail 489 521 need 509 532 FAIL 2002m6 2004m5
223 MME__01 min/max avail 396 528 need 443 466 ok 1996m12 1998m11
224 MRCH_01 min/max avail 437 494 need 490 513 FAIL 2000m11 2002m10
225 MRK__01 min/max avail 396 581 need 511 534 ok 2002m8 2004m7
226 MSC__01 min/max avail 396 581 need 448 471 ok 1997m5 1999m4
227 MTEL_01 min/max avail 396 476 need 446 469 ok 1997m3 1999m2
228 MWD__01 min/max avail 396 581 need 479 502 ok 1999m12 2001m11
229 MWHS_01 min/max avail 396 480 need 442 465 ok 1996m11 1998m10
230 MXT__01 min/max avail 442 550 need 513 536 ok 2002m10 2004m9
231 NAFC_01 min/max avail 396 581 need 516 539 ok 2003m1 2004m12
232 NAK__01 min/max avail 396 457 need 457 480 FAIL 1998m2 2000m1
233 NBTY_01 min/max avail 396 581 need 487 510 ok 2000m8 2002m7
234 NETA_01 min/max avail 396 581 need 472 495 ok 1999m5 2001m4
235 NITE_01 min/max avail 463 581 need 491 514 ok 2000m12 2002m11
236 NKE__01 min/max avail 396 581 need 495 518 ok 2001m4 2003m3
237 NOVL_01 min/max avail 396 581 need 480 503 ok 2000m1 2001m12
238 NOVN_01 min/max avail 396 581 need 503 526 ok 2001m12 2003m11
239 NPNT_01 min/max avail 473 491 need 494 517 FAIL 2001m3 2003m2
240 NSIT_01 min/max avail 421 581 need 511 534 ok 2002m8 2004m7
241 NUI__01 min/max avail 396 538 need 514 537 ok 2002m11 2004m10
242 NU___01 min/max avail 396 581 need 445 468 ok 1997m2 1999m1
243 NU___02 min/max avail 396 581 need 483 506 ok 2000m4 2002m3
244 NVDA_01 min/max avail 469 581 need 506 529 ok 2002m3 2004m2
245 NWL__01 min/max avail 396 581 need 478 501 ok 1999m11 2001m10
246 NXCD_01 min/max avail 473 504 need 503 526 FAIL 2001m12 2003m11
247 OCA__01 min/max avail 420 549 need 496 519 ok 2001m5 2003m4
248 OG___01 min/max avail 396 506 need 477 500 ok 1999m10 2001m9
249 OH___01 min/max avail 396 513 need 467 490 ok 1998m12 2000m11
250 OIL__01 min/max avail 396 498 need 464 487 ok 1998m9 2000m8
251 OLS__01 min/max avail 396 481 need 448 471 ok 1997m5 1999m4
252 OMC__01 min/max avail 396 581 need 510 533 ok 2002m7 2004m6
253 OMG__01 min/max avail 406 581 need 515 538 ok 2002m12 2004m11
254 OMX__01 min/max avail 419 526 need 489 512 ok 2000m10 2002m9
255 ONE__01 min/max avail 396 533 need 482 505 ok 2000m3 2002m2
256 ORB__01 min/max avail 396 581 need 475 498 ok 1999m8 2001m7
257 ORCL_01 min/max avail 396 581 need 456 479 ok 1998m1 1999m12
258 ORCL_02 min/max avail 396 581 need 495 518 ok 2001m4 2003m3
259 OXHP_01 min/max avail 396 533 need 454 477 ok 1997m11 1999m10
260 PCG__01 min/max avail 396 581 need 498 521 ok 2001m7 2003m6
261 PCLN_01 min/max avail 471 581 need 490 513 ok 2000m11 2002m10
262 PCMS_01 min/max avail 423 517 need 465 488 ok 1998m10 2000m9
263 PCTL_01 min/max avail 396 500 need 453 476 ok 1997m10 1999m9
264 PDX__01 min/max avail 429 581 need 470 493 ok 1999m3 2001m2
265 PEB__01 min/max avail 396 581 need 484 507 ok 2000m5 2002m4
266 PETC_01 min/max avail 411 488 need 464 487 ok 1998m9 2000m8
267 PFG__01 min/max avail 396 479 need 464 487 FAIL 1998m9 2000m8
268 PG___01 min/max avail 396 581 need 483 506 ok 2000m4 2002m3
269 PHSY_01 min/max avail 396 550 need 491 514 ok 2000m12 2002m11
270 PHYC_01 min/max avail 396 486 need 465 486 ok 1998m10 2000m7
271 PKI__01 min/max avail 396 581 need 511 534 ok 2002m8 2004m7
272 PLX__01 min/max avail 396 533 need 480 503 ok 2000m1 2001m12
273 PMS__01 min/max avail 396 490 need 481 504 FAIL 2000m2 2002m1
274 PMTC_01 min/max avail 396 581 need 463 486 ok 1998m8 2000m7
275 PNC__01 min/max avail 396 581 need 506 529 ok 2002m3 2004m2
276 PPD__01 min/max avail 396 581 need 493 516 ok 2001m2 2003m1
277 PRD__01 min/max avail 396 500 need 474 497 ok 1999m7 2001m6
278 PRIA_01 min/max avail 418 507 need 491 514 FAIL 2000m12 2002m11
279 PSFT_01 min/max avail 396 539 need 469 492 ok 1999m2 2001m1
280 PSIX_01 min/max avail 425 494 need 491 514 FAIL 2000m12 2002m11
281 PSSI_01 min/max avail 413 581 need 471 494 ok 1999m4 2001m3
282 PSX__01 min/max avail 396 458 need 442 465 FAIL 1996m11 1998m10
283 PVN__01 min/max avail 450 548 need 474 497 ok 1999m7 2001m6
284 QCOM_01 min/max avail 396 581 need 515 538 ok 2002m12 2004m11
285 QTRN_01 min/max avail 412 523 need 477 500 ok 1999m10 2001m9
286 Q____01 min/max avail 450 581 need 499 522 ok 2001m8 2003m7
287 RAD__01 min/max avail 396 581 need 471 494 ok 1999m4 2001m3
288 REL__01 min/max avail 396 490 need 486 509 FAIL 2000m7 2002m6
289 REV__01 min/max avail 434 581 need 478 501 ok 1999m11 2001m10
290 RHB__01 min/max avail 396 581 need 509 532 ok 2002m6 2004m5
291 RHR__01 min/max avail 396 454 need 454 477 FAIL 1997m11 1999m10
292 RLR__01 min/max avail 396 487 need 485 508 FAIL 2000m6 2002m5
293 RMBS_01 min/max avail 449 581 need 500 523 ok 2001m9 2003m8
294 ROBV_01 min/max avail 409 524 need 498 521 ok 2001m7 2003m6
295 RSG__01 min/max avail 463 581 need 477 500 ok 1999m10 2001m9
296 RTNB_01 min/max avail 396 581 need 478 501 ok 1999m11 2001m10
297 RXSD_01 min/max avail 402 485 need 467 485 ok 1998m12 2000m6
298 SBL__01 min/max avail 396 563 need 507 530 ok 2002m4 2004m3
299 SCOR_01 min/max avail 396 515 need 515 538 FAIL 2002m12 2004m11
300 SDTI_01 min/max avail 420 559 need 468 491 ok 1999m1 2000m12
301 SEI__01 min/max avail 396 517 need 508 531 FAIL 2002m5 2004m4
302 SEPR_01 min/max avail 396 581 need 515 538 ok 2002m12 2004m11
303 SERO_01 min/max avail 426 557 need 484 507 ok 2000m5 2002m4
304 SFA__01 min/max avail 396 552 need 499 522 ok 2001m8 2003m7
305 SFE__01 min/max avail 396 581 need 498 521 ok 2001m7 2003m6
306 SFSK_01 min/max avail 407 480 need 471 494 FAIL 1999m4 2001m3
307 SGE__01 min/max avail 442 484 need 471 494 FAIL 1999m4 2001m3
308 SGP__01 min/max avail 396 581 need 494 517 ok 2001m3 2003m2
309 SHG__01 min/max avail 403 472 need 471 494 FAIL 1999m4 2001m3
310 SIII_01 min/max avail 399 518 need 455 478 ok 1997m12 1999m11
311 SIRI_01 min/max avail 417 581 need 504 527 ok 2002m1 2003m12
312 SJK__01 min/max avail 399 473 need 466 489 FAIL 1998m11 2000m10
313 SKO__01 min/max avail 396 550 need 502 525 ok 2001m11 2003m10
314 SK___01 min/max avail 396 484 need 483 506 FAIL 2000m4 2002m3
315 SLMD_01 min/max avail 396 509 need 507 530 FAIL 2002m4 2004m3
316 SOC__01 min/max avail 396 492 need 460 483 ok 1998m5 2000m4
317 SPC__01 min/max avail 396 581 need 514 537 ok 2002m11 2004m10
318 SRM__01 min/max avail 396 501 need 496 519 FAIL 2001m5 2003m4
319 SRV__01 min/max avail 396 581 need 469 492 ok 1999m2 2001m1
320 SSAX_01 min/max avail 396 476 need 445 468 ok 1997m2 1999m1
321 STEI_01 min/max avail 396 581 need 476 499 ok 1999m9 2001m8
322 STLC_01 min/max avail 396 448 need 448 471 FAIL 1997m5 1999m4
323 STRM_01 min/max avail 473 501 need 502 525 FAIL 2001m11 2003m10
324 SVU__01 min/max avail 396 581 need 511 534 ok 2002m8 2004m7
325 SW___01 min/max avail 396 483 need 485 508 FAIL 2000m6 2002m5
326 SYBS_01 min/max avail 396 581 need 457 480 ok 1998m2 2000m1
327 SYKE_01 min/max avail 436 581 need 482 505 ok 2000m3 2002m2
328 SYMC_01 min/max avail 396 581 need 445 468 ok 1997m2 1999m1
329 S____01 min/max avail 396 541 need 448 471 ok 1997m5 1999m4
330 S____02 min/max avail 396 541 need 514 537 ok 2002m11 2004m10
331 TCOMA01 min/max avail 396 469 need 445 468 ok 1997m2 1999m1
332 TCSI_01 min/max avail 396 515 need 453 476 ok 1997m10 1999m9
333 TER__01 min/max avail 396 581 need 502 525 ok 2001m11 2003m10
334 THC__01 min/max avail 396 581 need 515 538 ok 2002m12 2004m11
335 TIG__01 min/max avail 400 470 need 459 482 FAIL 1998m4 2000m3
336 TLAB_01 min/max avail 396 581 need 511 534 ok 2002m8 2004m7
337 TLXN_01 min/max avail 396 490 need 468 490 ok 1999m1 2000m11
338 TNB__01 min/max avail 396 581 need 482 505 ok 2000m3 2002m2
339 TRL__01 min/max avail 430 581 need 470 493 ok 1999m3 2001m2
340 TRY__01 min/max avail 396 581 need 452 475 ok 1997m9 1999m8
341 TSAI_01 min/max avail 422 581 need 514 537 ok 2002m11 2004m10
342 TSO__01 min/max avail 396 581 need 485 508 ok 2000m6 2002m5
343 TXT__01 min/max avail 396 581 need 508 531 ok 2002m5 2004m4
344 TXU__01 min/max avail 396 572 need 514 537 ok 2002m11 2004m10
345 TYC__01 min/max avail 396 581 need 485 508 ok 2000m6 2002m5
346 T____01 min/max avail 396 549 need 490 513 ok 2000m11 2002m10
347 UCU__01 min/max avail 396 581 need 508 531 ok 2002m5 2004m4
348 UICI_01 min/max avail 396 554 need 480 503 ok 2000m1 2001m12
349 UIS__01 min/max avail 396 581 need 478 501 ok 1999m11 2001m10
350 UK___01 min/max avail 396 492 need 478 501 FAIL 1999m11 2001m10
351 UNH__01 min/max avail 396 581 need 440 463 ok 1996m9 1998m8
352 UNP__01 min/max avail 396 581 need 455 478 ok 1997m12 1999m11
353 USU__01 min/max avail 463 581 need 498 521 ok 2001m7 2003m6
354 VC___01 min/max avail 396 581 need 456 479 ok 1998m1 1999m12
355 VIAB_01 min/max avail 396 581 need 459 482 ok 1998m4 2000m3
356 VISX_01 min/max avail 396 543 need 481 504 ok 2000m2 2002m1
357 VL___01 min/max avail 459 491 need 493 516 FAIL 2001m2 2003m1
358 VNTV_01 min/max avail 428 478 need 475 498 FAIL 1999m8 2001m7
359 VNWK_01 min/max avail 458 551 need 487 510 ok 2000m8 2002m7
360 VRSN_01 min/max avail 457 581 need 509 532 ok 2002m6 2004m5
361 VTA__01 min/max avail 407 551 need 462 485 ok 1998m7 2000m6
362 WAC__01 min/max avail 396 496 need 488 511 FAIL 2000m9 2002m8
363 WCII_01 min/max avail 396 494 need 496 519 FAIL 2001m5 2003m4
364 WCOM_01 min/max avail 396 508 need 491 508 ok 2000m12 2002m5
365 WDC__01 min/max avail 396 581 need 456 479 ok 1998m1 1999m12
366 WMB__01 min/max avail 396 581 need 505 528 ok 2002m2 2004m1
367 WMX__01 min/max avail 396 461 need 455 478 FAIL 1997m12 1999m11
368 WNC__01 min/max avail 396 581 need 469 492 ok 1999m2 2001m1
369 WND__01 min/max avail 396 563 need 465 488 ok 1998m10 2000m9
370 WXS__01 min/max avail 404 515 need 502 525 FAIL 2001m11 2003m10
371 XEL__01 min/max avail 396 581 need 511 534 ok 2002m8 2004m7
372 XOXO_01 min/max avail 453 501 need 504 527 FAIL 2002m1 2003m12
373 XRX__01 min/max avail 396 581 need 480 503 ok 2000m1 2001m12
374 ZLG__01 min/max avail 396 457 need 457 480 FAIL 1998m2 2000m1
.
. // problem firms
. // count if mi(cara) | cara == 0
. // list case_code cara if mi(cara) | cara == 0, sep(0)
.
. // keep only cara observations, sorted by case code, for merge
. keep if cara < . & cara != 0
(203 observations deleted)
. tabstat cara,by(case_code) stat(mean N)
Summary for variables: cara
by categories of: case_code
case_code | mean N
----------+--------------------
AAM__01 | -2.464074 1
ACF__01 | 1.367124 1
ACTN_01 | 2.584599 1
ACXM_01 | -.1728099 1
ADBE_01 | -.0122286 1
ADPT_01 | .9463797 1
ADRX_01 | -.0693905 1
ADSK_01 | .604749 1
ADVNA01 | -.8320879 1
AET__02 | .7763932 1
AHP__01 | -.0505896 1
AKS__01 | .6137345 1
ALO__01 | -.2377855 1
AMCC_01 | -.8159839 1
AMGN_01 | 1.057484 1
ANF__01 | .4832384 1
ANN__01 | -.3168351 1
AOC__01 | .09054 1
AOL__01 | 3.069158 1
AOR__01 | 1.451382 1
APD__01 | -.2123034 1
APSO_01 | -1.241351 1
ASHW_01 | .4960345 1
ASO__01 | .4350554 1
ATIS_01 | 1.932191 1
ATX__01 | .3360518 1
AVA__01 | .1447165 1
AVS__01 | -2.087744 1
AVY__01 | -.2474855 1
AWA__01 | -.4218963 1
BA___01 | -.2889121 1
BHE__01 | .4183203 1
BHI__01 | .9214464 1
BLS__01 | .0741678 1
BOL__01 | .2281355 1
BRW__01 | .413959 1
BSX__01 | -.4766915 1
BVSN_01 | .0823219 1
CAG__01 | .0813739 1
CATP_01 | -.4052202 1
CA___01 | -.1723417 1
CBIZ_01 | -.1478968 1
CCL__01 | .4592045 1
CC___01 | -.0093623 1
CDE__01 | -.7704606 1
CDN__01 | .7101744 1
CELL_01 | .4501983 1
CEN__01 | .1036611 1
CHK__01 | -.1526485 1
CIEN_01 | 2.72592 1
CI___01 | .3773626 1
CLX__01 | .2129644 1
CMA__01 | .122125 1
CMO__01 | -.1322073 1
COF__01 | .6403509 1
COL__01 | -.6873036 1
COMS_01 | -.3906006 1
CORR_01 | 1.135018 1
CPB__01 | .2145811 1
CPQ__01 | -.0234409 1
CSCO_01 | .4328436 1
CS___01 | -.1800907 1
CTXS_01 | .0139798 1
CU___01 | -.2924872 1
CVS__01 | .0527155 1
DG___01 | .2938153 1
DIIG_01 | .4184438 1
DOW__01 | .3094148 1
DPL__01 | -.0070733 1
DQE__01 | -.0208036 1
DYN__01 | -.1166891 1
EMLX_01 | 1.545486 1
ENTU_01 | -.6485342 1
EP___01 | -.3282504 1
ESST_01 | .1754516 1
ETS__01 | 1.370693 1
EXC__01 | .155867 1
EX___01 | -.3021241 1
FCAA_01 | -.5338462 1
FD___01 | .8679238 1
FLM__01 | -.0884391 1
FLR__01 | -.239344 1
FMO__01 | -.7853068 1
FMXI_01 | .1709273 1
FNV__01 | -.6638313 1
FON__01 | .1037741 1
FOX__01 | -1.123041 1
FTL__01 | -3.054475 1
FTU__01 | .0647633 1
F____01 | -.2003437 1
GAP__01 | -.6288996 1
GAS__01 | .0792614 1
GEMS_01 | -1.278415 1
GEN__01 | -.8457313 1
GFD__01 | -1.805199 1
GLC__01 | -.6797183 1
GLW__01 | 1.198509 1
GNCI_01 | -.1526307 1
GND__01 | -.7807512 1
GRB__01 | .6676445 1
GSPN_01 | .0227807 1
GTIS_01 | -.6125622 1
GTK__01 | 1.368231 1
GTW__01 | -.7444087 1
HAL__01 | .5980921 1
HC___01 | .0962911 1
HGR__01 | 2.942634 1
HMT__01 | .350939 1
HMX__01 | 1.111731 1
HOMS_01 | 3.045149 1
HON__01 | .6519413 1
HRB__01 | -.0322061 1
HRC__01 | -.2899798 1
HUM__01 | .1517329 1
HWP__01 | .2446483 1
IBP__01 | 1.207596 1
ICN__01 | .6311121 1
IDXX_01 | -.086538 1
IFMX_01 | .2822332 1
IKN__01 | .0005527 1
IMCL_01 | 1.477799 1
IMNR_01 | -.4937185 1
INSP_01 | .1874485 1
INTC_01 | .5468413 1
INTV_01 | .4992733 1
IOM__01 | -.8767023 1
IO___01 | -1.476086 1
IPG__01 | -.6186994 1
IR___01 | .5400083 1
ISSX_01 | 1.696801 1
ITRI_01 | -1.324958 1
IVX__01 | -.6723767 1
JDEC_01 | .0469532 1
JDSU_01 | -.0345506 1
JNJ__01 | -.1906818 1
JNPR_01 | 1.469198 1
JPM__01 | .4552803 1
KANA_01 | 1.86881 1
KNE__01 | .7135415 1
KO___01 | .2160286 1
KR___01 | -.1967889 1
KSE__01 | .1740727 1
LENS_01 | -.1539476 1
LFCO_01 | -.8892207 1
LGTO_01 | 1.509799 1
LMT__01 | .1022161 1
LNY__01 | .9921116 1
LTRE_01 | .8984672 1
LU___01 | -1.615773 1
LXK__01 | .4655545 1
MAT__01 | .7097537 1
MCK__01 | .1110767 1
MDM__01 | -.698049 1
MDR__01 | .8127219 1
MER__01 | .1523585 1
MME__01 | -.3710502 1
MRK__01 | -.1950753 1
MSC__01 | -.5922895 1
MSM__01 | .7554797 1
MTEL_01 | .9210796 1
MTRS_01 | 1.307959 1
MWD__01 | .3121291 1
MWHS_01 | .3414355 1
MXT__01 | 1.996557 1
NAFC_01 | 1.860166 1
NBTY_01 | 1.719892 1
NCS__01 | .7454118 1
NETA_01 | .8595154 1
NITE_01 | -.1130053 1
NKE__01 | .5187421 1
NOVL_01 | -1.096907 1
NOVN_01 | .6150262 1
NSIT_01 | .3564894 1
NS___01 | -1.024326 1
NUI__01 | -.0901963 1
NU___01 | -.1824351 1
NU___02 | .2481322 1
NVDA_01 | -.1422449 1
NWL__01 | .1445548 1
OCA__01 | -.8611776 1
OG___01 | .6119668 1
OH___01 | -2.710388 1
OIL__01 | 1.252557 1
OLS__01 | -1.112361 1
OMC__01 | .370723 1
OMG__01 | 1.400294 1
OMX__01 | 1.085479 1
ONE__01 | .7656435 1
ORB__01 | -1.370838 1
ORCL_01 | 2.209667 1
ORCL_02 | .2103566 1
OXHP_01 | -.5004242 1
PCG__01 | .986166 1
PCLN_01 | 1.409982 1
PCMS_01 | 1.648122 1
PCTL_01 | -.8529149 1
PDX__01 | .1932357 1
PEB__01 | -.2974175 1
PETC_01 | .9058417 1
PG___01 | .8012295 1
PHSY_01 | 2.027571 1
PHYC_01 | -1.716352 1
PKI__01 | .8020468 1
PLX__01 | .965428 1
PMTC_01 | .333507 1
PNC__01 | .0530319 1
POI__01 | -.0226024 1
PPD__01 | 1.191024 1
PRD__01 | -1.744155 1
PSFT_01 | 1.107045 1
PSSI_01 | -.1142751 1
PVN__01 | .5860177 1
QCOM_01 | .4643384 1
QHGI_01 | -.1693743 1
QTRN_01 | .3496057 1
Q____01 | -.2314055 1
RAD__01 | -.460102 1
REV__01 | .07706 1
RHB__01 | -.0609342 1
RMBS_01 | 1.940148 1
ROBV_01 | .4590427 1
RSG__01 | .7300416 1
RTNB_01 | .5630198 1
RURL_01 | -.9881437 1
RWY__01 | 1.055105 1
RXSD_01 | .5222729 1
SAMC_01 | -.627183 1
SBL__01 | .365215 1
SCHL_01 | -.1313493 1
SDTI_01 | 1.484569 1
SEPR_01 | 1.605308 1
SERO_01 | 2.67616 1
SFA__01 | .5693539 1
SFE__01 | .7655149 1
SGI__01 | -.507117 1
SGP__01 | -.4070268 1
SIII_01 | .3931465 1
SIRI_01 | .0594133 1
SKO__01 | .6263503 1
SOC__01 | -1.850993 1
SONE_01 | -.0327174 1
SPC__01 | -.2078183 1
SRV__01 | -.4949596 1
SSAX_01 | -.3355985 1
STAF_01 | -.2394084 1
STEI_01 | 1.227911 1
SVU__01 | .1729017 1
SWC__01 | .3995199 1
SYBS_01 | .9026767 1
SYKE_01 | .618531 1
SYMC_01 | .022304 1
S____01 | -.4244186 1
S____02 | .1353256 1
TCOMA01 | 1.344584 1
TCSI_01 | -1.189779 1
TERN_01 | -.6281563 1
TER__01 | .3431683 1
THC__01 | -.6772452 1
TLAB_01 | .604861 1
TLXN_01 | .8059535 1
TNB__01 | .3482152 1
TRL__01 | 1.420889 1
TRY__01 | -.2443733 1
TSAI_01 | .722048 1
TSO__01 | .0831736 1
TXT__01 | .2146297 1
TXU__01 | 1.295706 1
TYC__01 | -.1624902 1
T____01 | .2922451 1
UAG__01 | -.3505309 1
UCR__01 | -.8184888 1
UCU__01 | -.7033873 1
UICI_01 | .8546701 1
UIS__01 | -.2427601 1
UNH__01 | -.2451507 1
UNP__01 | -.4944261 1
USU__01 | .2376361 1
VC___01 | -1.383666 1
VIAB_01 | .4420116 1
VISX_01 | .0435746 1
VNWK_01 | -.3645369 1
VRSN_01 | .9247653 1
VTA__01 | -1.136643 1
WCOM_01 | -1.304159 1
WDC__01 | -1.284308 1
WMB__01 | .434328 1
WNC__01 | -.1135855 1
WND__01 | .274897 1
XEL__01 | .8150525 1
XRX__01 | .2303145 1
----------+--------------------
Total | .1839478 290
-------------------------------
. keep case_code cara
. sort case_code
. desc
Contains data from proxy_proxyR2.dta
obs: 290
vars: 2 22 Apr 2010 10:21
size: 6,670 (99.9% of memory free)
-----------------------------------------------------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-----------------------------------------------------------------------------------------------------------------------------
case_code str7 %9s
cara double %10.0g
-----------------------------------------------------------------------------------------------------------------------------
Sorted by: case_code
Note: dataset has changed since last saved
. save `outfile', replace
file proxy_proxyCARAplus24.dta saved
.
. log close
name: <unnamed>
log: /Users/baum/Documents/Chuck/ ChuckLitGov2/proxy13_2_plus24.smcl
log type: smcl
closed on: 25 Apr 2010, 11:06:45
-----------------------------------------------------------------------------------------------------------------------------