Determine which portfolio a given observation falls into according to portfolio breakpoints
Good Sunday
I have encountered some questions, and I urgently need some help. I would like to express my gratitude in advance.
I have a sample looks like the following (the sample is made up but it truly represents what my issue is)
From French's website, I downloaded the breakpoint for the U.S stock portfolio sorted on Book-to-market ratio. The data looks like the following.
For each id of stock, I want to determine which portfolio it falls into, there are 20 portfolios as A to T.
For instance, for stock id 1 it is in 1998 November, its BM is 52.19, 52.19<=56.12, so a new variable called "portfolio" is =A .
If a stock has BM 280 in 1998 November, 280>=276.58 and 280<=347.59, "portfolio' = F for the stock
Can anyone help me with that ???
I have encountered some questions, and I urgently need some help. I would like to express my gratitude in advance.
I have a sample looks like the following (the sample is made up but it truly represents what my issue is)
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input byte id double BM float date 1 52.19043549913022 466 2 51.87621692556536 606 3 58.10318308053835 493 4 77.4699240089114 561 5 90.05075228125858 449 6 28.355143894772176 462 7 67.52974028748436 657 8 1.5287331766716514 669 9 65.01901303140355 650 10 69.40296639912107 589 11 48.26270332956938 677 12 39.48573259681997 541 13 26.34293649098178 557 14 11.858668782616657 399 15 90.5371868037965 444 16 78.85671559801018 466 17 84.31928464613787 550 18 57.80709250160222 449 19 18.77752006591998 559 20 96.86083559678946 525 21 25.209936826685382 576 22 61.11243018890957 650 23 9.80718405713065 480 24 1.250770592364269 424 25 48.66454054383984 624 26 99.65556810205389 602 27 27.06503494369335 424 28 52.95785393841364 430 29 56.628772850733974 510 30 46.90008239997558 667 31 78.7690969573046 561 32 5.024414807580798 577 33 21.41514328440199 665 34 64.0582293160802 562 35 90.29548020874661 578 36 91.7970824304941 543 37 50.02716147343364 511 38 23.53611865596484 498 39 12.683492538224433 454 40 22.829126865443893 530 41 98.26877651295511 516 42 81.94753868221076 552 43 46.54356517227699 493 44 6.513931699575792 412 45 30.805444502090516 630 46 17.300088503677483 637 47 19.269997253334147 477 48 56.837244788964504 573 49 79.73290200506608 661 50 43.72164067506943 485 51 71.85326700643941 649 52 24.27332377086703 424 53 21.72331919309061 532 54 25.285470137638477 684 55 10.175786614581744 657 56 69.30628376110111 519 57 96.43482772301401 655 58 99.29300820947904 638 59 71.12814722128971 607 60 59.47788933988464 476 61 6.145329142124699 416 62 26.620899075289167 436 63 62.336069826349686 459 64 83.50956755272072 619 65 9.329813531907101 616 66 81.45808282723472 510 67 21.943876461073643 649 68 68.40592669454024 474 69 52.19345683156834 533 70 6.042603839228493 444 71 50.19635608996856 424 72 99.04828028199103 421 73 59.773979918820764 417 74 30.70876186407056 488 75 83.21951963866086 470 76 20.209631641590626 578 77 3.7463911862544634 448 78 88.8935819574572 487 79 32.82973723563342 495 80 19.526810510574663 669 81 96.46201971495712 576 82 39.36487929929502 689 83 72.73549607837153 637 84 78.29172643208106 556 85 25.34287545396283 614 86 94.41355632190924 476 87 9.912930692464979 480 88 87.6336863307596 399 89 52.2629474776452 690 90 9.103213599047823 661 91 95.58583330790124 420 92 2.0212103640858183 663 93 20.92870876186407 642 94 91.49797051911985 499 95 36.576189458906825 602 96 45.537461470381785 512 97 86.92669454023866 643 98 14.864894558549759 417 99 46.434797204504534 558 . 45.897000030518505 549 end format %tm date
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input double(A B C D E F G H I J K L M N O P Q R S T) float date 33.09 62.37 89.81 135.26 187.45 242.71 299.95 383.4 498.36 626.16 801.07 990.38 1207.65 1494.07 2005.23 2737.74 3631.71 5381.88 9412.96 75884.43 396 32.03 61.17 89.57 133.07 186.22 235.7 301.73 379.3 479.48 611.96 784.05 973.25 1197.09 1498.28 2014.83 2742.76 3656.59 5497.55 9488.24 78988.09 397 33.57 62.95 92.64 140.49 192.38 244.91 322.9 396.9 505.8 628.3 806.84 999.19 1266.04 1516.77 2082.35 2853.76 3808.67 5526.1 9806.38 82127.25 398 32.92 60.92 88.86 138.45 193.04 241.55 308.52 393.59 496.3 620.66 778.02 976.6 1223.48 1475.88 2044.32 2747.92 3746.03 5285.41 9540.1 81972 399 33.58 62.69 91.75 146.22 197.84 248.44 324.5 412.68 513.94 630.05 792.82 983.53 1242.65 1535.07 2050 2770.05 3737.94 5333.35 9470.69 82139.95 400 33.42 60.84 94.89 145.62 201.42 253.57 326.05 414.95 505.44 640.11 811.76 1018.31 1234.09 1572.28 2062.61 2855.41 3725.19 5462.86 9671.64 84682.02 401 33.42 62.13 96.71 147.41 198.77 256.06 326.66 404.12 523.57 628.3 804.9 1033.88 1262.36 1548 2034.77 2829.11 3826.35 5322.41 9886.7 85186.08 402 34.01 63.8 102.04 150.2 206.96 267.39 337.36 421.65 530.86 635.93 836.07 1074.62 1303.23 1615.66 2133.19 2933.63 3943.62 5501.49 10169.77 84514 403 34.35 64.21 105.94 156 210.37 274.95 345.29 426.37 536.7 649.46 836.83 1063.44 1320.85 1610.89 2144.94 2923.88 3967.2 5462.51 10225.45 81891.34 404 35.83 66.77 110.13 161.77 217.43 277.85 348.74 435.5 542.04 667.39 837.21 1041.35 1309 1597.8 2143.33 2903.71 3971.24 5450.73 10053.94 82852.26 405 41.74 66.29 111.98 163.31 213.71 269.85 343.35 423.79 526.98 661.13 812.58 1018.98 1237.07 1587.92 2047.12 2820.04 3812.01 5410.64 9516.59 84026.71 406 43 69.1 119.01 167.9 218.08 281.94 350.97 430.72 549.74 679.63 830.5 1031.94 1300.39 1620.71 2133.63 2928.71 4008.37 5572.41 9412.14 89451.55 407 45.45 75.24 125.1 171.29 219.48 281.87 357.79 446.65 563.96 687.27 863.72 1062.94 1310.75 1653.36 2130.81 2924.6 3983.1 5727.34 9814.01 91903.74 408 46.8 73.82 123 163.53 220.89 280.99 352.55 444.11 557.95 681.24 850.27 1066.15 1274.43 1635.51 2070.5 2854.28 3905.43 5412.6 9999.32 89878.02 409 46.58 71.59 118.27 156.76 206.03 264.67 330.19 418.02 525.24 643.19 804.71 990 1207.14 1509.43 1972.16 2714.72 3813.24 5165.39 9225.89 85383.3 410 45.96 70.65 120.54 156.62 211.12 270.74 326.35 427.89 515.83 631.57 790.99 990.66 1229.83 1493.96 2014.42 2687.66 3732.42 5334.08 9774.7 81327.59 411 45.88 70.06 118.04 154.01 204.31 253.51 325.85 407.35 506.18 627.16 778.28 953.97 1199.77 1518.87 1987.66 2669.96 3706.82 5281.62 9687.35 84956.38 412 43.54 65.36 111.22 151.28 199.81 252.58 317.96 397.34 507.85 617.35 758.4 933.18 1182.07 1470.98 1929.1 2571.67 3594.24 5217.04 8973.44 79746.79 413 44.03 68.02 111.02 153.93 204.77 250.22 324.67 411.98 507.9 627.53 771.01 967.11 1216.76 1540.39 1929.07 2671.48 3650.66 5189.67 9253.7 86160.74 414 45.24 71.16 114.21 159.72 212.15 262.48 341.31 433.01 534.97 658.4 822.78 1011.63 1253.38 1605.66 2074.88 2753.81 3758.03 5556.71 9691.38 85190.26 415 45.56 73.03 114.26 162.28 208.96 263.41 340.79 422.15 527.44 649.25 796.07 1003.25 1221.32 1545.91 1955.58 2736.84 3630.77 5270.91 9623.03 84752.35 416 47.31 74.22 113.8 160.65 212.05 252.85 330.27 418.22 522.12 657.17 790.66 986.02 1214.57 1555.79 1990.17 2707.46 3682.12 5316.87 9774.97 86287.2 417 43.57 70.68 106.94 150.16 196.88 240.08 312.19 400.71 494.64 612.79 753.47 912.39 1132.84 1456.49 1912.93 2506.49 3507.81 5127.15 9219.83 78644.36 418 45.46 69.32 105.03 146.2 199.9 244.89 311.44 403.88 501.49 613.28 764.91 943.95 1139.93 1435.06 1905.44 2495.4 3504.41 5089.31 9188.23 87192.66 419 45.47 70.56 108.28 151.33 200.04 240.08 307.34 401.53 489.82 613.13 762.11 941.78 1163.93 1463.9 1938.96 2597.44 3592.04 5323.12 9237.8 88047.49 420 48.04 73.26 111.18 156.93 203.11 251.35 315.47 410.29 508.56 639.26 803.24 986.48 1213.95 1533.63 2020.3 2694.9 3803.43 5435.07 9567.11 93603.89 421 48.04 71.73 107.29 156.53 202.93 256.46 326.65 410.57 503.77 647.48 788.98 1002.39 1232.2 1579.65 2005.95 2739.7 3926.59 5555.28 9500.36 92321.64 422 46.98 73.42 109.99 157.57 209.2 267.59 330.24 419.46 508.44 636.78 792.73 1000.66 1264.6 1564.13 2031 2789.83 3893.62 5616.12 10156.67 95740.96 423 47.25 75.47 114.19 163.48 213.17 268.78 333.01 426.39 517.5 653.24 809.1 991.75 1293.31 1610.57 2073.3 2876.39 4045.54 5731.98 10773.01 98400.42 424 47.36 79.36 121.32 162.67 219.41 286.79 347.36 432.94 536.46 676.79 817.67 1008.46 1313.77 1677.08 2131.68 2871.67 4111.99 5809.27 10910.93 95492.38 425 50.94 82.92 122.81 168.8 227.15 293.76 375.3 460.37 572.73 699.91 860.95 1058.62 1361.84 1757.73 2184.62 2983.82 4259.35 5936.14 10996.17 99938.8 426 52.03 85.05 126.42 175.41 232.26 298.82 380.16 473.13 580.12 708.31 874.96 1072.17 1366.26 1762.51 2164.38 3027.39 4371.99 6093.52 11129.59 99727.07 427 51.38 88.07 127.25 174.97 235.83 303.4 392.03 487.9 596.63 717.11 885.34 1078.31 1356.3 1773.08 2219.39 3068.92 4376.9 6391.67 11613.45 107254.72 428 47.53 82.83 120.44 164.66 224.81 282.6 362.03 459.44 561.88 686.92 864.98 1064.75 1337.32 1685.04 2223.2 2977.53 4310.13 6182.64 12034.3 106413.51 429 48.67 82.81 127.28 169.63 230.88 295.12 378.99 470.1 582.42 712.62 907.95 1124.17 1423.17 1799.01 2280.05 3130.79 4415.34 6523.47 12122.73 112117.21 430 49.21 83.83 127.77 173.58 236.83 309.27 380.14 472.57 590.05 714.85 917.06 1147.66 1396.75 1776.13 2267.71 3107.33 4350.24 6422.63 12245.02 120259.8 431 48.25 84.64 130.49 180.12 237.17 305.7 383.73 477.24 584.53 709.58 898.17 1153.04 1426.23 1797.73 2310 3094.58 4570.38 6779.35 12692.44 128193.61 432 49.67 85.84 132.93 182.91 242.29 311.45 389.12 488.81 604.53 741.49 912.51 1171.33 1442.89 1831.25 2322.97 3125.98 4628.91 6874.27 13100.61 126105.77 433 50.01 88.57 140.63 193.67 246.41 313.03 398.68 499.1 613.23 751.31 936.7 1164.21 1492.08 1876.87 2416.84 3226.97 4699.06 6818.2 13141.58 130072.66 434 54.86 92.83 146.99 199.19 260.01 333.55 418.27 517.85 628.93 774.84 970.2 1219.98 1516.76 1934.23 2411.96 3237.78 4694.8 6866.55 13003.69 128430.21 435 58.67 104.85 158.67 212.14 275.2 357.95 441.11 541.41 660.72 810.89 973.18 1257.61 1536.07 1959.56 2442.44 3337.45 4711.41 7047.02 12982.88 137574.11 436 54.66 96.75 147.42 201.87 264.33 346.95 429.97 525.01 635.8 781.99 984.79 1210.84 1487.92 1905.45 2442.49 3296.78 4653.99 6921.24 13111.39 144224.22 437 52.67 93.38 136 183.28 246.16 319.56 400.84 483.08 601.58 733.29 910.39 1124.07 1407.69 1801.42 2279.2 3058.3 4427.54 6559.41 12609.07 136514.84 438 52.28 94.18 145.12 192.54 254.72 335.08 410.1 510.44 641.55 757.45 938.61 1172.99 1481.5 1874.55 2361.98 3157.04 4640.4 6792.07 13352.38 137967.14 439 53.08 94.79 149.03 198.22 263.9 348.27 424.3 525.25 637.48 765.61 944.54 1188.37 1493.78 1953.48 2486.79 3310.82 4774.07 7079.18 14269.29 150264.2 440 51.48 94.59 147.15 192.86 260.08 345.86 418.46 516.72 623.29 755.04 929.58 1184.86 1513.1 1941.66 2451.86 3318.8 4660.08 7206.27 13450.25 159758.92 441 51.45 97.84 153.75 200.27 272.13 356.1 437.19 529.72 641.33 776.76 962.42 1231.15 1588.13 1993.11 2569.82 3393.08 5040.61 7694.38 14193.6 171730.52 442 53.68 97.32 156.39 203.51 278.39 354.21 433.77 525.97 647.91 792.3 952.66 1205.24 1579.96 1980.04 2594.64 3443.63 4870.7 7543.36 13550.51 162789.88 443 55.47 99.58 168.08 216.9 284.92 362.61 437.32 542.38 666.98 791.9 979.03 1219.36 1605.2 2011.5 2626.72 3478.75 4993.84 7643.95 14397.15 170404.58 444 53.39 105.8 162.67 212.87 281.65 360.76 435.03 527.67 647.99 784.41 955.16 1190.42 1605.36 2020.97 2659.82 3400.16 5087.77 7654.79 14982.14 169375.56 445 51.07 101.31 154.53 202.37 265.28 345.34 412.51 505.73 626.49 741.17 917.19 1155.38 1539.98 1932.03 2528.59 3350.09 4777.31 7505.19 14230.92 163407.28 446 49.12 94.53 148.65 198.85 268.42 342.82 418.41 496.4 629.12 748.93 922.63 1164.86 1552.03 1952.02 2536.73 3382.6 5017.3 7623.52 15107.96 182060.31 447 54.37 105.63 164.65 220.2 294.54 371.84 463.45 550.91 687.6 809.4 977.54 1236.22 1655.54 2103.45 2676.36 3646.17 5253.58 8164.65 15324.22 197207.94 448 56.41 111.59 172.72 236.56 300.4 385.35 485.73 595.98 705.2 844.82 1027.76 1266.85 1667.3 2155.71 2782.7 3591.75 5360.22 8308.64 16181 212314.97 449 61.26 120.31 184.62 243.56 317.18 409.27 507.27 612.05 734.19 895.89 1064.38 1316.59 1734.8 2314.43 2971.77 3971.91 5740.96 8734.51 17624.92 229034.56 450 65.49 128.11 192.12 258.91 318.3 422.5 515.35 626.22 765.04 899.67 1069.14 1324.24 1754.8 2323.1 2949.35 3994.93 5738.03 8472.51 17031.8 204334.77 451 70.25 135.73 207.91 270.25 338.59 441.35 553.8 668.5 808.95 968.62 1154.66 1392.26 1858.34 2463.16 3098.93 4152 5848.84 8915.58 17384.82 222298.25 452 70.78 137.88 198.34 259.76 322.37 429.87 530.96 638.46 779.42 918.43 1092.08 1351.32 1760.83 2321.39 2952.78 3927.03 5665.06 8711.25 16398.59 211499.92 453 70.77 132.26 195.79 254.6 324.17 424.12 530.6 621.73 764.7 913.58 1090.43 1364.93 1774.7 2320.63 2933.49 4026.3 5687.21 9171.75 17458.71 241772.64 454 68.33 127.61 191.71 258.57 341.46 429.81 516.4 635.81 779.3 943.11 1112.43 1404.2 1807.63 2364.46 2994.65 4015.82 5907.47 9221.34 18055.87 240136.28 455 66.91 126.37 188.09 254.81 332.08 428 509.4 615.5 762.56 916.95 1092.84 1371.49 1777.3 2285.35 2960.99 3959.91 5806.32 8918.26 17975.45 253636.27 456 66.48 133.02 204.31 273.79 354.91 452.06 548.4 675.03 808.35 969.48 1174.46 1509.78 1935.5 2452.22 3193.47 4273.88 6322.46 9605.37 20012.93 254454.45 457 77.88 144.27 212.2 283.69 370.14 471.45 569.34 694.18 845.26 1011.03 1247.35 1591.5 1987.54 2528.64 3366.04 4505.39 6455.55 10198.76 21099.71 281006.59 458 79.34 147.44 213.37 288.72 375.66 473.27 568.44 700.56 847.57 1031.59 1245.07 1602.1 1970.91 2544.03 3337.46 4561.32 6524.4 10273.69 21142.41 277746.16 459 76.72 141.28 201.16 273.21 357.46 448.54 542.93 665.32 811.13 978.52 1197.48 1486.94 1928.22 2441.42 3211.09 4367.66 6439.43 10081.83 20622.12 271637.59 460 70 134.24 191 259.99 344.31 436.6 534.51 660.78 803.06 960.3 1190.88 1480.28 1867.34 2389.07 3192.88 4415.08 6511.17 10132.09 21766.58 296072.75 461 64.8 121.01 181.04 249.27 308.27 393.03 484.85 598.91 716.89 876.51 1062.94 1373.93 1741.09 2226.51 2918.88 4107.98 6330.41 9840.07 21739.08 291389.34 462 52.04 100.62 146.04 195.51 247.31 317.14 389.57 464.02 577.69 718.29 872.21 1106.55 1414.98 1836.92 2434.21 3568.16 5410.76 8191.93 18435.02 260294.72 463 54.5 101.05 148.32 198.32 261.29 323.66 402.42 478.01 601.32 744.94 891.83 1108.71 1458.19 1951.8 2637.04 3631.24 5505.25 8705.84 20378.27 258871.23 464 55.73 99.48 152.26 193.57 261.29 330.86 415.36 508.07 635.47 759.2 924.58 1178.44 1572.15 2067.16 2702.54 4014.65 5958.15 9453.29 21204.54 284697.34 465 56.12 104.17 151.13 202.26 276.58 347.59 419.41 528.94 653.29 801.27 992.42 1233.56 1606.05 2137.07 2792.71 4100.63 5970.35 9720.17 21355.74 296143.97 466 55.42 101.28 150.98 209.92 278.67 355.83 433.78 535.24 661.89 814.59 1022.72 1293.47 1623.89 2143.74 2931.65 4205.12 6015.14 10048.35 22943.38 334237.16 467 58.22 100.12 150.69 199.9 270.8 331.88 422.54 524.24 646.85 784.13 974.92 1228.89 1577.66 2064.39 2784.86 3989.24 5747.5 9703.7 22384.54 343658.06 468 55.55 93.28 142.17 188.64 241.19 305.83 388.5 485.9 592.69 722.85 930.1 1168.32 1494.34 1987.3 2696.24 4014.66 5677.17 9776.58 21774.32 328707.5 469 53.7 93.38 135.41 183.13 238.25 308.47 394.14 494.21 591.68 750.93 950.48 1171.13 1543.59 2017.46 2703.6 3954.83 6098.12 10449.67 21410.13 362322.75 470 56.77 103.29 160.85 215.78 272.57 341.59 441.47 559.07 653.25 809.36 1031.57 1307.13 1699.29 2247.49 2958.55 4305.35 6576.29 10777.33 24504.28 345127.78 471 57.61 107.2 159.35 221.24 297.14 366.56 463.67 579.04 684.56 845.44 1055.37 1304.95 1682.44 2281.58 2970.11 4357.6 6759.4 10646.28 24092.03 332709.09 472 58.87 102.85 158.49 231.02 316.52 395.56 487.26 602.28 719.87 898.54 1100.66 1364.69 1763.39 2324.29 3080.29 4430.6 6827.32 10843.02 24920.06 369722.22 473 61.88 108.04 162.6 229.07 312.22 384.33 480.77 589.34 706.1 877.82 1088.79 1375.67 1810.02 2295.69 3078.56 4372.03 6561.33 11004.36 23535.79 356634.69 474 55.41 101.63 152.13 214.77 293.83 368.24 448 562.61 679.45 853.02 1016.43 1305.29 1653.5 2173.67 2960.51 4068.29 6494.94 10679.27 23268.29 367472.78 475 49.48 99.77 149.11 208.64 278.12 364.48 442.23 551.47 658.42 838.43 1005.8 1237.96 1612.88 2089.57 2859.2 3851.94 6031.09 10097 22756.21 387922.03 476 44.68 89.51 140.88 194.09 261.71 329.92 414.73 515.89 635.07 792.35 990.07 1231.34 1598.34 2123.81 2850.29 3926.1 6192.58 10111.82 24397.8 444121.88 477 50.03 94.22 138.09 194.01 263.75 335.3 420.55 524.24 639.99 806 997.55 1243.84 1641.46 2154.53 2809.28 4027.21 6549.98 10177.93 25484.86 426504.47 478 49.98 93.47 140.15 190.84 265.08 346.33 438.26 529.04 664.12 823.67 1047.75 1285.68 1676.36 2143.63 2939.66 4276.09 6617.29 10314.82 27867.25 507216.66 479 53.53 94.89 138.18 189.04 253.38 329.08 409.44 506.64 622.84 796.39 987.44 1205.58 1578.18 2003.4 2767 4103.86 6152.65 9878.22 25078.73 437976.25 480 54.97 94.38 134.32 185.24 247.65 318.83 413.83 510.81 634.79 761.02 935.47 1169.14 1454.45 1883.23 2740.67 3950.84 5757.18 9278.64 24630.72 433879.19 481 48.71 95.93 145.16 197.86 258.24 345.75 430.07 536.08 678.41 868.84 1075.02 1384.3 1724.58 2203.74 3105.15 4467.71 6712.75 10440.57 28482.35 512832.94 482 49.17 89.77 136.99 188.52 257.48 338.75 436.61 544.07 707.28 891.34 1092.44 1333.8 1701.73 2214.57 3254.59 4530.7 6777.75 10767.38 27743.99 518187.81 483 48.98 91.32 133.15 196.05 257.83 338.01 434.05 560.46 706.63 879.49 1099.59 1380.21 1764.83 2298.27 3260.14 4508.49 6905.43 11352.26 27960.13 521259.88 484 52.47 87.12 132.71 199.19 268.2 351.37 452.29 563.72 714.36 904.1 1101.77 1382.18 1737.18 2274.2 3140.45 4380.65 6679.25 10908.74 25762.98 524351.56 485 53.26 86.27 135.71 197.03 271.02 346.91 456.74 577.96 714.41 900.4 1130.24 1414.04 1768.05 2287.5 3129.49 4452.65 6605.01 10803.63 24248.53 508893.09 486 55.09 90.18 140.35 208.4 279.78 359.68 482.23 599.11 753.71 976.78 1163.51 1481.83 1862.76 2368.14 3310.88 4838.74 7169.75 11540.18 27277.65 581098.88 487 48.33 88.56 133.47 197.23 265.91 358.37 463.9 601.59 730.57 954.52 1181.72 1469.36 1883.15 2375.88 3209.61 4771.59 6997.56 12002.09 27110.6 571614 488 46.19 83.18 125.61 188.79 251.48 338.43 449.36 591.58 741.16 941.63 1183.94 1453.34 1897.8 2394.78 3267.57 4813.48 7257.06 11618.44 26466.62 543126.19 489 41.87 76.23 124.1 181.18 245.59 336.7 430.11 557.27 719.2 914.06 1119.71 1463.66 1859.8 2398.32 3219.83 4725.92 6894.28 11776.07 27152.06 491105 490 38.02 82.29 126.11 193.49 259.15 368.29 474.85 619.39 800.91 989.61 1220.26 1591.16 2043.46 2588.35 3479.34 5105.33 7263.56 12687.08 28333.61 475003.19 491 54.71 95.7 147.9 224.81 299.65 391.98 508.16 653.76 844.49 1058.41 1291.87 1657.69 2023.64 2575.7 3624.43 5161.47 7649.33 12561.14 28433.06 455606.69 492 49.91 97 150.41 227.84 295.71 391.54 521.75 652.49 821.23 1025.82 1262.32 1603.3 1993.41 2574.22 3564.95 5073.26 7380.28 12542.98 29149.74 460759.28 493 47.29 88.79 143.21 215.38 285.48 381.38 489.22 626.81 812.78 1010.99 1250.38 1550.51 1955.45 2514 3368.69 4890.29 7146.81 12196.37 28193.95 415792.41 494 46.17 94.1 148.66 232.54 320.46 414.43 530.97 657.02 866.84 1079.65 1317.02 1680.79 2112.59 2756.48 3658.05 5329.01 7581.46 12926.76 29872.89 482051.94 495 end format %tm date
For each id of stock, I want to determine which portfolio it falls into, there are 20 portfolios as A to T.
For instance, for stock id 1 it is in 1998 November, its BM is 52.19, 52.19<=56.12, so a new variable called "portfolio" is =A .
If a stock has BM 280 in 1998 November, 280>=276.58 and 280<=347.59, "portfolio' = F for the stock
Can anyone help me with that ???
Comment