-
Notifications
You must be signed in to change notification settings - Fork 0
/
0_porthold_clean.lst
1731 lines (1665 loc) · 200 KB
/
0_porthold_clean.lst
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
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
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
183
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
275
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
306
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
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
Pre-Fixing Stats 14:48 Wednesday, August 18, 2010 1
The CONTENTS Procedure
Data Set Name MORN.PORTHOLD_MAIN_CLEAN Observations 92561477
Member Type DATA Variables 17
Engine V9 Indexes 0
Created Saturday, August 14, 2010 01:43:34 PM Observation Length 208
Last Modified Saturday, August 14, 2010 01:54:45 PM Deleted Observations 0
Protection Compressed NO
Data Set Type Sorted NO
Label
Data Representation SOLARIS_X86_64, LINUX_X86_64,
ALPHA_TRU64, LINUX_IA64
Encoding latin1 Western (ISO)
Engine/Host Dependent Information
Data Set Page Size 24576
Number of Data Set Pages 791124
First Data Page 1
Max Obs per Page 117
Obs in First Data Page 97
Number of Data Set Repairs 0
Filename /largefs/jabloche/morningstar/porthold_main_clean.sas7bdat
Release Created 9.0201M0
Host Created Linux
Inode Number 4285
Access Permission rw-r-----
Owner Name jabloche
File Size (bytes) 19442671616
Alphabetic List of Variables and Attributes
# Variable Type Len Format Label
7 country Char 3 Country
15 coupon Num 8 Coupon if holding is bond in pct
5 cusip Char 9 9 digit CUSIP
1 fundid Char 10 Fund ID
16 industry_code Num 8 Industry Code
11 marketvalue Num 8 Market Value of Shares as reported by manager
14 mat_year Num 8
13 maturity Num 8 YYMMDD10. Maturity if holding is bond
2 port_date Num 8 YYMMDD10. Porfolio Date
3 port_year Num 8
17 sector_code Num 8 Sector Code
8 security Char 80 Security Name
10 sharechange Num 8 Change in Shares
9 shares Num 8 Number of Shares Owned
4 stkid Char 10 ISIN
6 type_cd Char 2 Asset Type Code
12 weight Num 8 Portfolio Weight in percentage points
Pre-Fixing Stats 14:48 Wednesday, August 18, 2010 2
The FREQ Procedure
Sector Code
Cumulative Cumulative
sector_code Frequency Percent Frequency Percent
----------------------------------------------------------------
0 34 0.00 34 0.00
0.6 2 0.00 36 0.00
0.63875 1 0.00 37 0.00
0.64653 1 0.00 38 0.00
0.8 3 0.00 41 0.00
1 2201161 4.14 2201202 4.14
1.4 8 0.00 2201210 4.14
1.42 8 0.00 2201218 4.14
2 4785987 8.99 6987205 13.13
2.3279 1 0.00 6987206 13.13
2.37036 1 0.00 6987207 13.13
2.75 2 0.00 6987209 13.13
3 1507408 2.83 8494617 15.96
4 1839779 3.46 10334396 19.42
4.5 1 0.00 10334397 19.42
5 5648413 10.61 15982810 30.04
6 5132372 9.65 21115182 39.68
7 4550614 8.55 25665796 48.23
8 9587269 18.02 35253065 66.25
9 4861109 9.14 40114174 75.39
10 8039468 15.11 48153642 90.49
11 3209099 6.03 51362741 96.52
12 1849442 3.48 53212183 100.00
Frequency Missing = 39349294
Industry Code
Cumulative Cumulative
industry_code Frequency Percent Frequency Percent
------------------------------------------------------------------
1 196588 0.37 196588 0.37
4 554145 1.04 750733 1.42
5 1 0.00 750734 1.42
7 130754 0.25 881488 1.66
10 150056 0.28 1031544 1.94
13 94084 0.18 1125628 2.12
16 278153 0.52 1403781 2.65
19 227224 0.43 1631005 3.08
22 102027 0.19 1733032 3.27
25 332859 0.63 2065891 3.90
28 67776 0.13 2133667 4.02
31 324677 0.61 2458344 4.64
34 284515 0.54 2742859 5.17
37 429322 0.81 3172181 5.98
40 166891 0.31 3339072 6.30
43 275944 0.52 3615016 6.82
46 1114130 2.10 4729146 8.92
49 208560 0.39 4937706 9.31
52 393984 0.74 5331690 10.05
55 446688 0.84 5778378 10.90
58 199342 0.38 5977720 11.27
61 968961 1.83 6946681 13.10
64 522719 0.99 7469400 14.08
65 111435 0.21 7580835 14.29
67 285924 0.54 7866759 14.83
70 950576 1.79 8817335 16.62
73 521394 0.98 9338729 17.61
76 137559 0.26 9476288 17.87
79 186389 0.35 9662677 18.22
82 190048 0.36 9852725 18.58
85 291481 0.55 10144206 19.13
88 349064 0.66 10493270 19.78
91 311492 0.59 10804762 20.37
92 436854 0.82 11241616 21.20
94 141198 0.27 11382814 21.46
97 398135 0.75 11780949 22.21
100 161577 0.30 11942526 22.52
103 422858 0.80 12365384 23.31
106 1485156 2.80 13850540 26.11
109 167537 0.32 14018077 26.43
112 870937 1.64 14889014 28.07
115 1364151 2.57 16253165 30.65
118 137863 0.26 16391028 30.90
121 189022 0.36 16580050 31.26
124 469466 0.89 17049516 32.15
127 107977 0.20 17157493 32.35
130 112936 0.21 17270429 32.56
131 54907 0.10 17325336 32.67
133 880232 1.66 18205568 34.33
136 819050 1.54 19024618 35.87
139 94142 0.18 19118760 36.05
142 142804 0.27 19261564 36.32
145 183743 0.35 19445307 36.66
148 100021 0.19 19545328 36.85
151 315222 0.59 19860550 37.45
154 201966 0.38 20062516 37.83
157 379247 0.72 20441763 38.54
160 437389 0.82 20879152 39.37
163 307593 0.58 21186745 39.95
166 90025 0.17 21276770 40.12
169 194889 0.37 21471659 40.48
172 213126 0.40 21684785 40.89
175 237033 0.45 21921818 41.33
178 529842 1.00 22451660 42.33
181 431120 0.81 22882780 43.15
184 521910 0.98 23404690 44.13
187 857293 1.62 24261983 45.75
190 62334 0.12 24324317 45.86
193 881141 1.66 25205458 47.52
196 149841 0.28 25355299 47.81
199 409845 0.77 25765144 48.58
202 511916 0.97 26277060 49.54
205 280397 0.53 26557457 50.07
206 482127 0.91 27039584 50.98
208 1313015 2.48 28352599 53.46
211 333132 0.63 28685731 54.09
214 398052 0.75 29083783 54.84
217 325916 0.61 29409699 55.45
220 292243 0.55 29701942 56.00
223 317177 0.60 30019119 56.60
226 165509 0.31 30184628 56.91
229 1326091 2.50 31510719 59.41
232 501529 0.95 32012248 60.36
235 835899 1.58 32848147 61.93
238 159208 0.30 33007355 62.23
241 232166 0.44 33239521 62.67
244 208610 0.39 33448131 63.07
247 61899 0.12 33510030 63.18
250 360752 0.68 33870782 63.86
253 123682 0.23 33994464 64.10
256 107942 0.20 34102406 64.30
259 143175 0.27 34245581 64.57
262 62284 0.12 34307865 64.69
263 231587 0.44 34539452 65.12
265 338041 0.64 34877493 65.76
268 138283 0.26 35015776 66.02
271 426176 0.80 35441952 66.83
274 102411 0.19 35544363 67.02
277 234637 0.44 35779000 67.46
280 1248486 2.35 37027486 69.81
283 156540 0.30 37184026 70.11
286 1031366 1.94 38215392 72.05
289 162483 0.31 38377875 72.36
295 127373 0.24 38505248 72.60
298 487126 0.92 38992374 73.52
301 109316 0.21 39101690 73.73
304 567770 1.07 39669460 74.80
307 530373 1.00 40199833 75.80
310 83379 0.16 40283212 75.95
313 510560 0.96 40793772 76.92
316 1294903 2.44 42088675 79.36
319 158906 0.30 42247581 79.66
322 1025901 1.93 43273482 81.59
325 571033 1.08 43844515 82.67
328 455637 0.86 44300152 83.53
331 719655 1.36 45019807 84.88
332 395490 0.75 45415297 85.63
334 1072192 2.02 46487489 87.65
337 127772 0.24 46615261 87.89
340 206625 0.39 46821886 88.28
343 160025 0.30 46981911 88.58
346 259188 0.49 47241099 89.07
349 63817 0.12 47304916 89.19
352 142439 0.27 47447355 89.46
355 178767 0.34 47626122 89.80
358 180275 0.34 47806397 90.14
361 77916 0.15 47884313 90.28
364 428858 0.81 48313171 91.09
367 512669 0.97 48825840 92.06
370 341127 0.64 49166967 92.70
373 15850 0.03 49182817 92.73
376 9969 0.02 49192786 92.75
379 52927 0.10 49245713 92.85
382 16215 0.03 49261928 92.88
385 15414 0.03 49277342 92.91
388 14850 0.03 49292192 92.94
391 22904 0.04 49315096 92.98
394 15897 0.03 49330993 93.01
397 21585 0.04 49352578 93.05
400 9254 0.02 49361832 93.07
403 10283 0.02 49372115 93.09
406 13021 0.02 49385136 93.11
409 55297 0.10 49440433 93.22
412 7341 0.01 49447774 93.23
415 974 0.00 49448748 93.23
418 7981 0.02 49456729 93.25
424 34693 0.07 49491422 93.32
427 29454 0.06 49520876 93.37
430 55174 0.10 49576050 93.47
433 13843 0.03 49589893 93.50
436 4499 0.01 49594392 93.51
439 24102 0.05 49618494 93.55
442 34107 0.06 49652601 93.62
448 44603 0.08 49697204 93.70
451 8874 0.02 49706078 93.72
454 21054 0.04 49727132 93.76
457 9702 0.02 49736834 93.78
460 23013 0.04 49759847 93.82
463 11089 0.02 49770936 93.84
466 17689 0.03 49788625 93.88
469 28140 0.05 49816765 93.93
481 65492 0.12 49882257 94.05
484 14476 0.03 49896733 94.08
490 46588 0.09 49943321 94.17
493 20323 0.04 49963644 94.21
496 31670 0.06 49995314 94.27
499 16224 0.03 50011538 94.30
502 10267 0.02 50021805 94.32
505 9640 0.02 50031445 94.33
511 14357 0.03 50045802 94.36
514 14026 0.03 50059828 94.39
517 3421 0.01 50063249 94.39
520 2591 0.00 50065840 94.40
523 12605 0.02 50078445 94.42
526 8236 0.02 50086681 94.44
529 12629 0.02 50099310 94.46
532 78678 0.15 50177988 94.61
535 57741 0.11 50235729 94.72
538 22495 0.04 50258224 94.76
541 9828 0.02 50268052 94.78
544 8042 0.02 50276094 94.79
547 40067 0.08 50316161 94.87
550 32357 0.06 50348518 94.93
556 27797 0.05 50376315 94.98
559 4511 0.01 50380826 94.99
565 9961 0.02 50390787 95.01
568 85394 0.16 50476181 95.17
571 6200 0.01 50482381 95.18
574 14951 0.03 50497332 95.21
577 10208 0.02 50507540 95.23
580 17250 0.03 50524790 95.26
583 30385 0.06 50555175 95.32
586 3308 0.01 50558483 95.33
589 2521 0.00 50561004 95.33
592 32728 0.06 50593732 95.39
595 5586 0.01 50599318 95.40
598 14101 0.03 50613419 95.43
601 45621 0.09 50659040 95.52
604 6577 0.01 50665617 95.53
607 18457 0.03 50684074 95.56
610 12325 0.02 50696399 95.59
613 96433 0.18 50792832 95.77
616 101175 0.19 50894007 95.96
619 36184 0.07 50930191 96.03
622 31864 0.06 50962055 96.09
625 30224 0.06 50992279 96.14
628 97513 0.18 51089792 96.33
634 10069 0.02 51099861 96.35
637 11173 0.02 51111034 96.37
640 19302 0.04 51130336 96.41
646 15522 0.03 51145858 96.43
649 48773 0.09 51194631 96.53
652 17746 0.03 51212377 96.56
655 97856 0.18 51310233 96.74
658 60669 0.11 51370902 96.86
661 38442 0.07 51409344 96.93
664 45542 0.09 51454886 97.02
667 15545 0.03 51470431 97.05
670 7068 0.01 51477499 97.06
673 77713 0.15 51555212 97.21
676 39310 0.07 51594522 97.28
679 115726 0.22 51710248 97.50
682 48862 0.09 51759110 97.59
688 10904 0.02 51770014 97.61
697 8317 0.02 51778331 97.63
700 19490 0.04 51797821 97.66
703 1388 0.00 51799209 97.67
706 18085 0.03 51817294 97.70
709 9199 0.02 51826493 97.72
712 13645 0.03 51840138 97.74
715 11759 0.02 51851897 97.77
721 27802 0.05 51879699 97.82
724 8651 0.02 51888350 97.83
727 9866 0.02 51898216 97.85
730 3912 0.01 51902128 97.86
733 17049 0.03 51919177 97.89
736 5116 0.01 51924293 97.90
739 7067 0.01 51931360 97.92
742 27638 0.05 51958998 97.97
745 40410 0.08 51999408 98.04
748 44150 0.08 52043558 98.13
751 28457 0.05 52072015 98.18
754 23638 0.04 52095653 98.23
757 16568 0.03 52112221 98.26
760 56715 0.11 52168936 98.36
763 14556 0.03 52183492 98.39
766 10090 0.02 52193582 98.41
769 20153 0.04 52213735 98.45
772 15248 0.03 52228983 98.48
775 22622 0.04 52251605 98.52
778 49039 0.09 52300644 98.61
781 55606 0.10 52356250 98.72
784 5983 0.01 52362233 98.73
787 50338 0.09 52412571 98.82
790 10958 0.02 52423529 98.84
793 41064 0.08 52464593 98.92
796 18005 0.03 52482598 98.95
799 37375 0.07 52519973 99.03
802 56522 0.11 52576495 99.13
805 9077 0.02 52585572 99.15
808 39298 0.07 52624870 99.22
811 73598 0.14 52698468 99.36
823 5388 0.01 52703856 99.37
826 2277 0.00 52706133 99.38
829 6752 0.01 52712885 99.39
832 1808 0.00 52714693 99.39
835 59497 0.11 52774190 99.50
856 16791 0.03 52790981 99.54
859 24569 0.05 52815550 99.58
862 25198 0.05 52840748 99.63
871 69148 0.13 52909896 99.76
874 4437 0.01 52914333 99.77
877 33299 0.06 52947632 99.83
886 21162 0.04 52968794 99.87
889 6430 0.01 52975224 99.88
898 7442 0.01 52982666 99.90
901 12726 0.02 52995392 99.92
904 26139 0.05 53021531 99.97
907 15329 0.03 53036860 100.00
Frequency Missing = 39524617
Cumulative Cumulative
mat_year Frequency Percent Frequency Percent
-------------------------------------------------------------
1900 3 0.00 3 0.00
1901 4 0.00 7 0.00
1903 2 0.00 9 0.00
1930 58 0.00 67 0.00
1931 12 0.00 79 0.00
1932 13 0.00 92 0.00
1933 1 0.00 93 0.00
1934 2 0.00 95 0.00
1937 1 0.00 96 0.00
1939 2 0.00 98 0.00
1949 8 0.00 106 0.00
1950 4 0.00 110 0.00
1952 1 0.00 111 0.00
1960 7 0.00 118 0.00
1984 2 0.00 120 0.00
1985 7 0.00 127 0.00
1986 27 0.00 154 0.00
1987 141 0.00 295 0.00
1988 238 0.00 533 0.00
1989 712 0.00 1245 0.00
1990 1677 0.00 2922 0.01
1991 3088 0.01 6010 0.02
1992 5874 0.02 11884 0.03
1993 10449 0.03 22333 0.06
1994 18704 0.05 41037 0.12
1995 30650 0.09 71687 0.21
1996 48840 0.14 120527 0.34
1997 52984 0.15 173511 0.50
1998 65761 0.19 239272 0.68
1999 85844 0.25 325116 0.93
2000 115027 0.33 440143 1.26
2001 165129 0.47 605272 1.73
2002 269210 0.77 874482 2.50
2003 409088 1.17 1283570 3.67
2004 498835 1.43 1782405 5.10
2005 644695 1.85 2427100 6.95
2006 840742 2.41 3267842 9.35
2007 1062585 3.04 4330427 12.39
2008 1318566 3.77 5648993 16.17
2009 1433669 4.10 7082662 20.27
2010 1374383 3.93 8457045 24.21
2011 1578436 4.52 10035481 28.72
2012 1533234 4.39 11568715 33.11
2013 1562071 4.47 13130786 37.58
2014 1435565 4.11 14566351 41.69
2015 1159751 3.32 15726102 45.01
2016 1296383 3.71 17022485 48.72
2017 1459397 4.18 18481882 52.90
2018 1006383 2.88 19488265 55.78
2019 834632 2.39 20322897 58.17
2020 749900 2.15 21072797 60.31
2021 658696 1.89 21731493 62.20
2022 759557 2.17 22491050 64.37
2023 933814 2.67 23424864 67.05
2024 686448 1.96 24111312 69.01
2025 500991 1.43 24612303 70.44
2026 614388 1.76 25226691 72.20
2027 611829 1.75 25838520 73.95
2028 959442 2.75 26797962 76.70
2029 937994 2.68 27735956 79.38
2030 703431 2.01 28439387 81.40
2031 849201 2.43 29288588 83.83
2032 797237 2.28 30085825 86.11
2033 873415 2.50 30959240 88.61
2034 764307 2.19 31723547 90.80
2035 838528 2.40 32562075 93.20
2036 687808 1.97 33249883 95.17
2037 538841 1.54 33788724 96.71
2038 237202 0.68 34025926 97.39
2039 131954 0.38 34157880 97.76
2040 60829 0.17 34218709 97.94
2041 64671 0.19 34283380 98.12
2042 88838 0.25 34372218 98.38
2043 51250 0.15 34423468 98.52
2044 45259 0.13 34468727 98.65
2045 58302 0.17 34527029 98.82
2046 56389 0.16 34583418 98.98
2047 42571 0.12 34625989 99.10
2048 12244 0.04 34638233 99.14
2049 167001 0.48 34805234 99.62
2050 24043 0.07 34829277 99.69
2051 9757 0.03 34839034 99.71
2052 5638 0.02 34844672 99.73
2053 1733 0.00 34846405 99.74
2054 13407 0.04 34859812 99.77
2055 3682 0.01 34863494 99.78
2056 4201 0.01 34867695 99.80
2057 2630 0.01 34870325 99.80
2058 1759 0.01 34872084 99.81
2059 1716 0.00 34873800 99.81
2060 1655 0.00 34875455 99.82
2061 106 0.00 34875561 99.82
2062 2201 0.01 34877762 99.83
2063 280 0.00 34878042 99.83
2064 127 0.00 34878169 99.83
2065 5199 0.01 34883368 99.84
2066 14568 0.04 34897936 99.88
2067 12039 0.03 34909975 99.92
2068 2794 0.01 34912769 99.93
2069 267 0.00 34913036 99.93
2070 363 0.00 34913399 99.93
2071 5 0.00 34913404 99.93
2074 2 0.00 34913406 99.93
2075 85 0.00 34913491 99.93
2076 87 0.00 34913578 99.93
2077 1726 0.00 34915304 99.93
2078 59 0.00 34915363 99.93
2079 398 0.00 34915761 99.93
2080 17 0.00 34915778 99.93
2081 1 0.00 34915779 99.93
2082 383 0.00 34916162 99.94
2083 2 0.00 34916164 99.94
2084 6 0.00 34916170 99.94
2085 572 0.00 34916742 99.94
2086 422 0.00 34917164 99.94
2087 1121 0.00 34918285 99.94
2088 105 0.00 34918390 99.94
2089 71 0.00 34918461 99.94
2090 1 0.00 34918462 99.94
2091 10 0.00 34918472 99.94
2092 131 0.00 34918603 99.94
2093 330 0.00 34918933 99.94
2094 625 0.00 34919558 99.94
2095 1454 0.00 34921012 99.95
2096 2412 0.01 34923424 99.96
2097 5310 0.02 34928734 99.97
2098 727 0.00 34929461 99.97
2099 6697 0.02 34936158 99.99
2100 1522 0.00 34937680 100.00
2101 308 0.00 34937988 100.00
2102 144 0.00 34938132 100.00
2103 133 0.00 34938265 100.00
2104 40 0.00 34938305 100.00
2105 101 0.00 34938406 100.00
2120 194 0.00 34938600 100.00
2144 7 0.00 34938607 100.00
2180 1 0.00 34938608 100.00
2200 4 0.00 34938612 100.00
2202 2 0.00 34938614 100.00
2203 1 0.00 34938615 100.00
2204 2 0.00 34938617 100.00
2205 3 0.00 34938620 100.00
2207 1 0.00 34938621 100.00
2208 1 0.00 34938622 100.00
2209 2 0.00 34938624 100.00
2939 1 0.00 34938625 100.00
3019 1 0.00 34938626 100.00
4670 155 0.00 34938781 100.00
9999 76 0.00 34938857 100.00
Frequency Missing = 57622620
Cumulative Cumulative
port_year Frequency Percent Frequency Percent
--------------------------------------------------------------
1900 1 0.00 1 0.00
1983 2102 0.00 2103 0.00
1984 45752 0.05 47855 0.05
1985 55290 0.06 103145 0.11
1986 76726 0.08 179871 0.19
1987 71367 0.08 251238 0.27
1988 123752 0.13 374990 0.41
1989 216290 0.23 591280 0.64
1990 232690 0.25 823970 0.89
1991 298527 0.32 1122497 1.21
1992 440021 0.48 1562518 1.69
1993 678862 0.73 2241380 2.42
1994 875096 0.95 3116476 3.37
1995 960487 1.04 4076963 4.40
1996 1049281 1.13 5126244 5.54
1997 1554091 1.68 6680335 7.22
1998 2408553 2.60 9088888 9.82
1999 2812248 3.04 11901136 12.86
2000 3809713 4.12 15710849 16.97
2001 4569953 4.94 20280802 21.91
2002 6406960 6.92 26687762 28.83
2003 7475649 8.08 34163411 36.91
2004 7776679 8.40 41940090 45.31
2005 7761390 8.39 49701480 53.70
2006 8415838 9.09 58117318 62.79
2007 10200042 11.02 68317360 73.81
2008 11935354 12.89 80252714 86.70
2009 12308763 13.30 92561477 100.00
Asset Type Code
Cumulative Cumulative
type_cd Frequency Percent Frequency Percent
------------------------------------------------------------
0 1272819 1.38 1272819 1.38
1 1747333 1.89 3020152 3.26
10 806964 0.87 3827116 4.13
11 185443 0.20 4012559 4.34
2 410020 0.44 4422579 4.78
3 940928 1.02 5363507 5.79
4 520021 0.56 5883528 6.36
5 619779 0.67 6503307 7.03
6 771204 0.83 7274511 7.86
7 477908 0.52 7752419 8.38
8 54070 0.06 7806489 8.43
9 279047 0.30 8085536 8.74
B 8098759 8.75 16184295 17.48
BA 34069 0.04 16218364 17.52
BC 174828 0.19 16393192 17.71
BD 509019 0.55 16902211 18.26
BE 1930 0.00 16904141 18.26
BF 567438 0.61 17471579 18.88
BG 9589989 10.36 27061568 29.24
BH 34530 0.04 27096098 29.27
BI 1062362 1.15 28158460 30.42
BJ 31219 0.03 28189679 30.46
BK 334017 0.36 28523696 30.82
BL 38784 0.04 28562480 30.86
BM 1131488 1.22 29693968 32.08
BN 38 0.00 29694006 32.08
BO 12660 0.01 29706666 32.09
BP 6238 0.01 29712904 32.10
BQ 20434 0.02 29733338 32.12
BR 91815 0.10 29825153 32.22
BS 98 0.00 29825251 32.22
BT 617616 0.67 30442867 32.89
BU 2685 0.00 30445552 32.89
BV 73 0.00 30445625 32.89
BW 247 0.00 30445872 32.89
BY 569131 0.61 31015003 33.51
C 303462 0.33 31318465 33.84
CB 865791 0.94 32184256 34.77
CC 3608 0.00 32187864 34.77
CD 11910 0.01 32199774 34.79
CF 5478 0.01 32205252 34.79
CH 228599 0.25 32433851 35.04
CI 44743 0.05 32478594 35.09
CL 26710 0.03 32505304 35.12
CO 4521 0.00 32509825 35.12
CP 161309 0.17 32671134 35.30
CQ 5307 0.01 32676441 35.30
CR 88042 0.10 32764483 35.40
CS 1765 0.00 32766248 35.40
CT 66709 0.07 32832957 35.47
CU 74952 0.08 32907909 35.55
CV 297 0.00 32908206 35.55
CX 27 0.00 32908233 35.55
DA 2783 0.00 32911016 35.56
DB 213 0.00 32911229 35.56
DC 13 0.00 32911242 35.56
DD 1037 0.00 32912279 35.56
DE 102 0.00 32912381 35.56
DF 76819 0.08 32989200 35.64
DG 204 0.00 32989404 35.64
DH 1803 0.00 32991207 35.64
DI 1471 0.00 32992678 35.64
DJ 514 0.00 32993192 35.64
DM 479 0.00 32993671 35.65
DP 7 0.00 32993678 35.65
E 54019792 58.36 87013470 94.01
EC 13565 0.01 87027035 94.02
EI 261442 0.28 87288477 94.30
EL 39377 0.04 87327854 94.35
EP 5210 0.01 87333064 94.35
EQ 144297 0.16 87477361 94.51
ER 71766 0.08 87549127 94.58
EU 34643 0.04 87583770 94.62
EV 1083 0.00 87584853 94.62
EW 76854 0.08 87661707 94.71
EX 24058 0.03 87685765 94.73
FC 33790 0.04 87719555 94.77
FE 84785 0.09 87804340 94.86
FM 128928 0.14 87933268 95.00
FO 358497 0.39 88291765 95.39
FT 285977 0.31 88577742 95.70
FV 25099 0.03 88602841 95.72
IF 202937 0.22 88805778 95.94
IN 96 0.00 88805874 95.94
IP 84 0.00 88805958 95.94
IT 25471 0.03 88831429 95.97
MF 853008 0.92 89684437 96.89
MI 2733 0.00 89687170 96.89
MN 41383 0.04 89728553 96.94
MQ 69902 0.08 89798455 97.01
MU 56276 0.06 89854731 97.08
MV 32399 0.04 89887130 97.11
MX 72975 0.08 89960105 97.19
OO 33 0.00 89960138 97.19
OS 3272 0.00 89963410 97.19
OT 381 0.00 89963791 97.19
P 310684 0.34 90274475 97.53
PA 7945 0.01 90282420 97.54
PC 57903 0.06 90340323 97.60
PI 21523 0.02 90361846 97.62
PK 1460 0.00 90363306 97.63
PP 123 0.00 90363429 97.63
Q 1280289 1.38 91643718 99.01
QQ 1163 0.00 91644881 99.01
SA 20 0.00 91644901 99.01
SC 597 0.00 91645498 99.01
SD 82654 0.09 91728152 99.10
SE 7806 0.01 91735958 99.11
SI 46750 0.05 91782708 99.16
SQ 421 0.00 91783129 99.16
SR 18949 0.02 91802078 99.18
ST 631 0.00 91802709 99.18
SV 2 0.00 91802711 99.18
TP 61194 0.07 91863905 99.25
WR 49683 0.05 91913588 99.30
YF 647889 0.70 92561477 100.00
Country
Cumulative Cumulative
country Frequency Percent Frequency Percent
------------------------------------------------------------
ABW 2060 0.00 2060 0.00
AFG 3 0.00 2063 0.00
AGO 11 0.00 2074 0.00
AIA 17 0.00 2091 0.00
ALB 53 0.00 2144 0.00
ANT 6064 0.01 8208 0.01
ARE 3890 0.00 12098 0.01
ARG 56712 0.07 68810 0.08
ATG 2 0.00 68812 0.08
AUS 592784 0.69 661596 0.77
AUT 80232 0.09 741828 0.86
BEL 123844 0.14 865672 1.01
BGD 129 0.00 865801 1.01
BGR 4131 0.00 869932 1.01
BHR 325 0.00 870257 1.01
BHS 3008 0.00 873265 1.02
BIH 64 0.00 873329 1.02
BLR 1 0.00 873330 1.02
BLZ 671 0.00 874001 1.02
BMU 107803 0.13 981804 1.14
BOL 11 0.00 981815 1.14
BRA 325767 0.38 1307582 1.52
BRB 511 0.00 1308093 1.52
BWA 539 0.00 1308632 1.53
CAN 1093416 1.27 2402048 2.80
CHE 459247 0.54 2861295 3.33
CHI 256 0.00 2861551 3.34
CHL 58239 0.07 2919790 3.40
CHN 234556 0.27 3154346 3.68
CIV 1218 0.00 3155564 3.68
CMR 48 0.00 3155612 3.68
COD 1 0.00 3155613 3.68
COG 199 0.00 3155812 3.68
COL 15806 0.02 3171618 3.70
CRI 606 0.00 3172224 3.70
CYM 119250 0.14 3291474 3.84
CYP 2184 0.00 3293658 3.84
CZE 15457 0.02 3309115 3.86
DEU 646823 0.75 3955938 4.61
DMA 2 0.00 3955940 4.61
DNK 130619 0.15 4086559 4.76
DOM 2738 0.00 4089297 4.77
DZA 241 0.00 4089538 4.77
ECU 2858 0.00 4092396 4.77
EGY 20073 0.02 4112469 4.79
ESP 271383 0.32 4383852 5.11
EST 1575 0.00 4385427 5.11
FIN 188346 0.22 4573773 5.33
FJI 266 0.00 4574039 5.33
FLK 1 0.00 4574040 5.33
FRA 772898 0.90 5346938 6.23
FRO 2 0.00 5346940 6.23
GAB 420 0.00 5347360 6.23
GBR 1744761 2.03 7092121 8.27
GEO 271 0.00 7092392 8.27
GER 1 0.00 7092393 8.27
GGY 814 0.00 7093207 8.27
GHA 2314 0.00 7095521 8.27
GIB 3119 0.00 7098640 8.27
GRC 106018 0.12 7204658 8.40
GRD 94 0.00 7204752 8.40
GTM 539 0.00 7205291 8.40
GUM 2 0.00 7205293 8.40
GUY 27 0.00 7205320 8.40
HKG 537359 0.63 7742679 9.02
HND 157 0.00 7742836 9.02
HRV 4287 0.00 7747123 9.03
HUN 30325 0.04 7777448 9.06
IDN 89954 0.10 7867402 9.17
IMN 149 0.00 7867551 9.17
IND 246928 0.29 8114479 9.46
IOM 468 0.00 8114947 9.46
IOT 1 0.00 8114948 9.46
IRL 141560 0.16 8256508 9.62
IRN 544 0.00 8257052 9.62
IRQ 579 0.00 8257631 9.62
ISL 3811 0.00 8261442 9.63
ISR 136924 0.16 8398366 9.79
ITA 332308 0.39 8730674 10.18
JAM 1719 0.00 8732393 10.18
JEY 1553 0.00 8733946 10.18
JOR 1030 0.00 8734976 10.18
JPN 2615556 3.05 11350532 13.23
KAZ 2219 0.00 11352751 13.23
KEN 1508 0.00 11354259 13.23
KOR 416251 0.49 11770510 13.72
KWT 513 0.00 11771023 13.72
LBN 1789 0.00 11772812 13.72
LBR 4189 0.00 11777001 13.73
LIE 465 0.00 11777466 13.73
LKA 2185 0.00 11779651 13.73
LTU 999 0.00 11780650 13.73
LUX 74996 0.09 11855646 13.82
LVA 162 0.00 11855808 13.82
MAC 115 0.00 11855923 13.82
MAR 3180 0.00 11859103 13.82
MCO 111 0.00 11859214 13.82
MDA 22 0.00 11859236 13.82
MEX 245836 0.29 12105072 14.11
MHL 7543 0.01 12112615 14.12
MKD 48 0.00 12112663 14.12
MLT 38 0.00 12112701 14.12
MNE 27 0.00 12112728 14.12
MNG 3 0.00 12112731 14.12
MUS 2897 0.00 12115628 14.12
MWI 2 0.00 12115630 14.12
MYS 176898 0.21 12292528 14.33
NAM 38 0.00 12292566 14.33
NCL 6 0.00 12292572 14.33
NER 62 0.00 12292634 14.33
NGA 3444 0.00 12296078 14.33
NIC 43 0.00 12296121 14.33
NLD 447545 0.52 12743666 14.85
NOR 148833 0.17 12892499 15.03
NPL 3 0.00 12892502 15.03
NZL 60255 0.07 12952757 15.10
OMN 1521 0.00 12954278 15.10
PAK 6387 0.01 12960665 15.11
PAN 16714 0.02 12977379 15.12
PER 25702 0.03 13003081 15.15
PHL 66192 0.08 13069273 15.23
PNG 1229 0.00 13070502 15.23
POL 59283 0.07 13129785 15.30
PRI 12721 0.01 13142506 15.32
PRK 33 0.00 13142539 15.32
PRT 55185 0.06 13197724 15.38
PRY 8 0.00 13197732 15.38
QAT 5143 0.01 13202875 15.39
REU 33 0.00 13202908 15.39
ROM 573 0.00 13203481 15.39
ROU 1741 0.00 13205222 15.39
RUS 104388 0.12 13309610 15.51
SAU 19 0.00 13309629 15.51
SGP 278710 0.32 13588339 15.84
SLE 1 0.00 13588340 15.84
SLV 2406 0.00 13590746 15.84
SRB 232 0.00 13590978 15.84
SVK 841 0.00 13591819 15.84
SVN 716 0.00 13592535 15.84
SWE 288214 0.34 13880749 16.18
SWZ 746 0.00 13881495 16.18
TCA 6 0.00 13881501 16.18
TGO 25 0.00 13881526 16.18
THA 130465 0.15 14011991 16.33
TTO 1023 0.00 14013014 16.33
TUN 945 0.00 14013959 16.33
TUR 103199 0.12 14117158 16.45
TWN 357431 0.42 14474589 16.87
UGA 267 0.00 14474856 16.87
UKR 5511 0.01 14480367 16.88
UMI 3 0.00 14480370 16.88
URY 3303 0.00 14483673 16.88
USA 71092601 82.86 85576274 99.74
UZB 8 0.00 85576282 99.74
VEN 20299 0.02 85596581 99.76
VGB 9821 0.01 85606402 99.77
VIR 10 0.00 85606412 99.77
VNM 895 0.00 85607307 99.77
WLF 2 0.00 85607309 99.77
YUG 251 0.00 85607560 99.77
ZAF 194367 0.23 85801927 100.00
ZMB 79 0.00 85802006 100.00
ZWE 893 0.00 85802899 100.00
Frequency Missing = 6758578
Pre-Fixing Stats 14:48 Wednesday, August 18, 2010 3
The MEANS Procedure
Variable Label N N Miss Mean Std Dev Minimum 1st Pctl 5th Pctl 25th Pctl 50th Pctl 75th Pctl 95th Pctl 99th Pctl Maximum
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
shares Number of Shares Owned 92551763 9714 53830525.27 58931142988 -18775991.00 6.0000000 400.0000000 7956.00 66500.00 580000.00 5808834.00 26704400.00 3.55685E14
sharechange Change in Shares 92550144 11333 46806908.58 58863287171 -1.916696E13 -1580000.00 -77424.00 0 0 1105.00 836943.00 9900000.00 3.55685E14
marketvalue Market Value of Shares as reported by manager 92561402 75 4410183.46 45342488170 -3.55685E14 0 2986.00 78625.00 492900.00 2132745.00 15226744.00 66031875.00 1.9305452E14
weight Portfolio Weight in percentage points 92192844 368633 2.4076620 3250.40 0 0.000020000 0.000610000 0.0235800 0.1523100 0.6442000 2.2967300 4.9065300 11157333.30
coupon Coupon if holding is bond in pct 35888200 56673277 5.9289451 3.5414246 0 0 0 5.0000000 6.0000000 7.5000000 10.1250000 12.5000000 750.0000000
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
How many records have invalid maturity i.e. before portfolio date 14:48 Wednesday, August 18, 2010 4
--------
5415
Port Year 1900 record 14:48 Wednesday, August 18, 2010 5
port_ industry_ sector_
Obs fundid port_date year stkid cusip type_cd country security shares sharechange marketvalue weight maturity mat_year coupon code code
4650067 FSUSA0006A 1900-12-31 1900 C Umb Repurchase Agreement 795000 795000 795000 100 2003-02-03 2003 . . .
*************** Post-Fixing Stats ********* This is final dataset ************* 14:48 Wednesday, August 18, 2010 6
The CONTENTS Procedure
Data Set Name MORN.PORTHOLD_MAIN_CLEAN_FIXED Observations 92561476
Member Type DATA Variables 17
Engine V9 Indexes 0
Created Wednesday, August 18, 2010 03:17:59 PM Observation Length 208
Last Modified Wednesday, August 18, 2010 03:17:59 PM Deleted Observations 0
Protection Compressed NO
Data Set Type Sorted NO
Label
Data Representation SOLARIS_X86_64, LINUX_X86_64, ALPHA_TRU64, LINUX_IA64
Encoding latin1 Western (ISO)
Engine/Host Dependent Information
Data Set Page Size 24576
Number of Data Set Pages 791124
First Data Page 1
Max Obs per Page 117
Obs in First Data Page 97
Number of Data Set Repairs 0
Filename /largefs/jabloche/morningstar/porthold_main_clean_fixed.sas7bdat
Release Created 9.0201M0
Host Created Linux
Inode Number 986170
Access Permission rw-r-----
Owner Name jabloche
File Size (bytes) 19442671616
Alphabetic List of Variables and Attributes
# Variable Type Len Format Label
7 country Char 3 Country
15 coupon Num 8 Coupon if holding is bond in pct
5 cusip Char 9 9 digit CUSIP
1 fundid Char 10 Fund ID
16 industry_code Num 8 Industry Code
11 marketvalue Num 8 Market Value of Shares as reported by manager
14 mat_year Num 8
13 maturity Num 8 YYMMDD10. Maturity if holding is bond
2 port_date Num 8 YYMMDD10. Porfolio Date
3 port_year Num 8
17 sector_code Num 8 Sector Code
8 security Char 80 Security Name
10 sharechange Num 8 Change in Shares
9 shares Num 8 Number of Shares Owned
4 stkid Char 10 ISIN
6 type_cd Char 2 Asset Type Code
12 weight Num 8 Portfolio Weight in percentage points
*************** Post-Fixing Stats ********* This is final dataset ************* 14:48 Wednesday, August 18, 2010 7
The FREQ Procedure
Sector Code
Cumulative Cumulative
sector_code Frequency Percent Frequency Percent
----------------------------------------------------------------
0 34 0.00 34 0.00
1 2201161 4.14 2201195 4.14
2 4785987 8.99 6987182 13.13
3 1507408 2.83 8494590 15.96
4 1839779 3.46 10334369 19.42
5 5648413 10.61 15982782 30.04
6 5132372 9.65 21115154 39.68
7 4550614 8.55 25665768 48.23
8 9587269 18.02 35253037 66.25
9 4861109 9.14 40114146 75.39
10 8039468 15.11 48153614 90.49
11 3209099 6.03 51362713 96.52
12 1849442 3.48 53212155 100.00
Frequency Missing = 39349321
Industry Code
Cumulative Cumulative
industry_code Frequency Percent Frequency Percent
------------------------------------------------------------------
1 196588 0.37 196588 0.37
4 554145 1.04 750733 1.42
5 1 0.00 750734 1.42
7 130754 0.25 881488 1.66
10 150056 0.28 1031544 1.94
13 94084 0.18 1125628 2.12
16 278153 0.52 1403781 2.65
19 227224 0.43 1631005 3.08
22 102027 0.19 1733032 3.27
25 332859 0.63 2065891 3.90
28 67776 0.13 2133667 4.02
31 324677 0.61 2458344 4.64
34 284515 0.54 2742859 5.17
37 429322 0.81 3172181 5.98
40 166891 0.31 3339072 6.30
43 275944 0.52 3615016 6.82
46 1114130 2.10 4729146 8.92
49 208560 0.39 4937706 9.31
52 393984 0.74 5331690 10.05
55 446688 0.84 5778378 10.90
58 199342 0.38 5977720 11.27
61 968961 1.83 6946681 13.10
64 522719 0.99 7469400 14.08
65 111435 0.21 7580835 14.29
67 285924 0.54 7866759 14.83
70 950576 1.79 8817335 16.62
73 521394 0.98 9338729 17.61
76 137559 0.26 9476288 17.87
79 186389 0.35 9662677 18.22
82 190048 0.36 9852725 18.58
85 291481 0.55 10144206 19.13