Hello!
I am kind of stuck on a problem with a macro execution and I need your support to change it. I have the following code that works fine but it needs to be changed.
Currently the loopw is executed 7 times and we need to change it to be executed n times. The n value will be changed on demand and it will not be the same each time.
Is something like that feasible?
Thank you in advance.
Code is below:
data work.all_data04; infile datalines delimiter=','; input issue_date :date9. WP_M WP_NLR_NM WP_LR WP_LC_Auto WP_NLC PF_M PF_NLR_NM PF_LR PF_LC_Auto PF_NLC WP_LC_Manual; datalines; '01Jan2018'd, 174196, 862771, , , 1989120, 29411, 166220, , , 181979, 123432 '02Jan2018'd, -29475, 1159, 2918750, -2799, 350907, 20895, 242, 158064, , 16345, 345654 '03Jan2018'd, 199642, 129, -4861, 10026, 66110, 24568, 118, -6, 43, 6353, 112233 '04Jan2018'd, 273807, -127477, -296538, 9090, 91608, 66583, -22205, -18308, , 12978, '05Jan2018'd, 191475, -367, -629, 48772, 289391, 47849, -29, 885, , 39606, '06Jan2018'd, 29273, 668648, 1983, , 1047902, 7319, 129788, 190, , 118890, '07Jan2018'd, 14250, , 213, , , 3563, , 81, , , '08Jan2018'd, 181343, -3705, 8418, 27166, 38875, 45339, -629, -531, , 250, '09Jan2018'd, 123844, 1340, 4602, 37704, 105857, 31212, 302, 1358, , 4287, '10Jan2018'd, 198657, -347, -6953, 13781, 147961, 49354, -39, 67, , 4897, '11Jan2018'd, 148271, 7468, 2197, 23296, 41907, 37078, 756, 1056, , 3822, '12Jan2018'd, 225315, 5397, -2924, 235943, 39274, 56332, 1064, 26, , 3725, '13Jan2018'd, 39858, , 3072434, , , 9965, , 156899, , , '14Jan2018'd, 16116, , 226, , , 4029, , 23, , , '15Jan2018'd, 106567, -4123, -8295, 5755, 21750, 41663, -644, 81, , 2245, '16Jan2018'd, 216783, 1995, -952, 26434, 27608, 39356, 472, 549, , 3318, 120000 '17Jan2018'd, 123858, 924, 16617, 70574, 206107, 37401, 245, 2077, , 1336, '18Jan2018'd, 155725, -881, 1374, 56429, 120767, 39987, -153, 1071, , 5478, '19Jan2018'd, 218479, 4811, 6997, 88505, 6115, 49111, 500, 1072, , 2763, '20Jan2018'd, 34652, , , , , 8664, , , , , 240000 '21Jan2018'd, 11603, , , , , 2901, , , , , '22Jan2018'd, 102212, -6085, -10052, 185929, 126654, 29296, -1028, -133, , 1655, '23Jan2018'd, 28460, 54393, -2431, 156845, 81391, 28312, 10993, -219, , 4952, 550055 '24Jan2018'd, 187140, 2344, 5328, 258510, -163801, 40192, 556, 974, , -38010, '25Jan2018'd, 130750, 1910, 4645, 64701, 12617, 36214, 237, 1160, , 291, '26Jan2018'd, 195055, 1891, 2622, 368226, 16505, 43943, 445, 1459, , 1901, '27Jan2018'd, 39358, , , , , 9840, , , , , '28Jan2018'd, 13784, , , , , 3447, , , , , '29Jan2018'd, 172177, 131955, -16000, 56506, 147798, 34865, -332, -87, , 20176, '30Jan2018'd, 193156, -1066, 4623, 712518, 280292, 43967, -170, 852, , 7994, '31Jan2018'd, 68652, 1370, 8539, 24506, 185566, 22017, 302, 370, , 20192, 1501167 '01Feb2018'd, 214573, -2127, 20477, 22120, 67008, 53649, -469, 2068, , 7637, '02Feb2018'd, 232721, 3175, 2127, 22436, 46821, 50092, 611, 779, , 6720, '03Feb2018'd, 105722, 765320, , , 1959262, 21136, 147996, , , 212532, '04Feb2018'd, 12433, , 1290, , , 3108, , 126, , , '05Feb2018'd, 177826, 766, -1875, 69469, 193724, 44251, 279, 469, , 1997, '06Feb2018'd, 150206, -1373, 8160, 232123, 63913, 38442, 134, 1332, , 5440, '07Feb2018'd, 135601, 1516, 5964, 24944, 86377, 33904, 297, 998, , 8440, '08Feb2018'd, 132885, 5508, 3001, 19001, 1776, 33225, 908, 869, , 3055, '09Feb2018'd, 178357, 4387, 5291, 24429, 6933, 44506, 817, 554, , 1498, '10Feb2018'd, 37788, , 3868104, , , 9448, , 216151, , , '11Feb2018'd, 12919, , 208, , , 3230, , 19, , , '12Feb2018'd, 143554, -12046, -11634, 51399, 1985, 39228, -2385, -198, , 1058, '13Feb2018'd, 133765, -713, 2095, 82021, 170893, 36240, -121, 878, , 6165, '14Feb2018'd, 132053, 99895, 428, 136961, 72269, 33016, 295, 825, , 8836, '15Feb2018'd, 113437, 448, 14576, 68629, 26384, 28728, 0, 1418, , 3512, 1234567 '16Feb2018'd, 203388, 2360, 1454, 269763, 132371, 50363, 430, 607, , 14038, '17Feb2018'd, 30281, , , , , 7570, , , , , '18Feb2018'd, 9043, , , , , 2261, , , , , '19Feb2018'd, 12066, , 449, , , 3017, , 45, , , '20Feb2018'd, 157190, -20638, -12956, 81043, 112997, 39199, -3483, 485, , 16944, '21Feb2018'd, 112614, 3503, 240, 242149, 48408, 28156, 644, 858, , 2797, '22Feb2018'd, 136498, 40485, 8240, 195434, 37507, 34127, 8043, 1493, , 742, '23Feb2018'd, 164791, 5643, 1872, 92768, -7149, 41204, 1016, 1006, , 3689, '24Feb2018'd, 34041, , 4508, , 2825, 8511, , 438, , 283, '25Feb2018'd, 11386, , 286, , , 2847, , 17, , , '26Feb2018'd, 135207, -4072, 1489, 234640, 72464, 33804, -537, 1007, , 6765, '27Feb2018'd, 166430, 5262, 3664, 1857697, 15330, 41733, 1006, 1907, , 2156, '03Apr2018'd, 211457, 3204, 10552, 55719, 155517, 52886, 648, 1825, , 12466, '04Apr2018'd, 218472, 937, 4147, 160529, 74529, 54621, 127, 397, , 9740, '05Apr2018'd, 221564, 6513, 668, 39201, 128723, 55412, 1286, 553, , 18627, '06Apr2018'd, 115877, 762778, , , 1268600, 20453, 148719, , , 142432, '07Apr2018'd, 26583, , 372, , , 6646, , 27, , , '08Apr2018'd, 4529, , , , , 1132, , , , , '09Apr2018'd, 12750, , , , , 3188, , , , , '10Apr2018'd, 175822, -6066, -17072, 2498, -12812, 43966, -916, -416, , -568, '11Apr2018'd, 163544, 396, 10241, 57400, 15299, 40892, 19, 1570, , 2109, '12Apr2018'd, 166783, 4250, 6297, 215139, 11546, 41913, 848, 1068, , 1229, '13Apr2018'd, 197589, 851, -189, 177991, 63668, 49400, 127, 455, , 6446, '14Apr2018'd, 35720, , 3591390, , , 8930, , 198747, , , '15Apr2018'd, 14899, , 64, , , 3725, , , , , '16Apr2018'd, 163049, -351, 4487, 124619, 47046, 40773, 134, 1174, , 4331, '17Apr2018'd, 135230, 2587, 22970, 243530, 42773, 33732, 482, 2682, , 3777, '18Apr2018'd, 222904, 4273, 4645, 94730, 58474, 55729, 882, 1396, , 1432, '19Apr2018'd, 147649, 2386, -7389, 297034, 66526, 36915, 498, -361, , 19141, '20Apr2018'd, 182280, 2138, -2298, 121216, 36068, 45574, 511, 952, , 3944, '21Apr2018'd, 30561, , 3914, , , 7640, , 327, , , '22Apr2018'd, 10228, , 630, , , 2557, , 51, , , '23Apr2018'd, 139339, 50651, 9500, 212903, 24209, 34562, 10319, 1202, , 2956, '24Apr2018'd, 144350, -1305, 7192, 191321, 50029, 36375, -288, 1234, , 3796, '25Apr2018'd, 183907, 88015, 21231, 86032, 56504, 36055, 1558, 2509, , 4661, '26Apr2018'd, 191477, 3488, 18767, 308852, 63787, 47705, 722, 2127, , 7723, '27Apr2018'd, 201500, 1146, 15500, 96992, 31160, 50378, 111, 2198, , 3447, '28Apr2018'd, 34849, , 1386, , 832, 8713, , 134, , 83, '29Apr2018'd, 13231, , 267, , , 3308, , 86, , , '30Apr2018'd, 166041, -3631, -7561, 128553, 45230, 41517, -592, 331, , 992, 682520 '03Jun2018'd, 13789, , , , , 3447, , , , , '04Jun2018'd, 162236, 202, -11378, 228581, 261736, 40567, 205, -141, , 24036, '05Jun2018'd, 166688, 5328, 12831, 150848, 21382, 41681, 1077, 1051, , 773, '06Jun2018'd, 151960, -4965, 1517, 25683, 33516, 37993, -771, 468, , 1125, '07Jun2018'd, 120979, 1020, 6403, 60363, 8652, 30305, 229, 974, , 1506, '08Jun2018'd, 208299, 3196, 1638, 34061, 97453, 52013, 596, 863, , 4471, '09Jun2018'd, 30375, , 3304269, , , 7594, , 211645, , , '10Jun2018'd, 13032, 138, , , , 3258, 28, , , , '11Jun2018'd, 150950, -1975, -6778, 100917, 114379, 37740, -351, 642, , 17470, '12Jun2018'd, 154540, 3352, 5510, 197499, 75534, 38549, 641, 693, , 4555, '13Jun2018'd, 133773, 3101, 12071, 9370, 10437, 33358, 629, 1480, , 1537, '14Jun2018'd, 164343, 1728, 16533, 96893, 67843, 41092, 346, 952, , 5524, '15Jun2018'd, 189701, 2803, 2117, 144885, 63598, 47431, 505, 656, , 5730, '16Jun2018'd, 36586, , 979, , , 9147, , 156, , , '17Jun2018'd, 6752, , , , 5134, 1688, , , , 551, '18Jun2018'd, 161631, 7959, 4504, 151106, 58136, 40414, -625, 494, , 4280, '19Jun2018'd, 150702, 1087, 18887, 166494, 321883, 37684, 198, 2004, , 3150, '20Jun2018'd, 142278, 10584, -5564, 53239, -2989, 35947, 1662, 7, , 369, '21Jun2018'd, 97145, 738, 5826, 143578, 64348, 31961, 131, 1021, , 7275, '22Jun2018'd, 225700, 90376, 11095, 135999, 68767, 48082, 285, 1600, , 9279, '23Jun2018'd, 33751, , 290, , , 8438, , 59, , , '24Jun2018'd, 10546, , 177, , , 2637, , 16, , , '25Jun2018'd, 119216, -6358, -12697, 126160, 507954, 29808, -1199, 88, , 460, '26Jun2018'd, 117068, -12691, 12098, 282375, 364037, 29270, -2517, 1305, , 10082, '27Jun2018'd, 150558, 27735, -4982, 27265, 114696, 37646, 5463, 354, , 2854, '28Jun2018'd, 143990, -12900, 9258, 72638, 105393, 36005, -2651, 1623, , 9790, '29Jun2018'd, 215109, -10040, 5667, 82543, 16245, 53783, -1949, 1091, , 1324, '30Jun2018'd, 35773, 166, , , , 8944, 33, , , , 775431 '01Jul2018'd, 12062, , -210, , , 3016, , 11, , , '02Jul2018'd, 155532, 1193, -11789, 46176, 199496, 38896, 245, 35, , 28083, '03Jul2018'd, 175398, 2670, -1969, 169314, 17072, 43858, 534, 176, , 1403, '04Jul2018'd, 157049, 3206, -6037, 195561, 117705, 39335, 637, 1353, , 17187, '05Jul2018'd, 155115, 2922, 4303, 29567, 46864, 38781, 599, 969, , 3910, '06Jul2018'd, 184431, 942, 5604, 338495, 52913, 45966, 185, 927, , 1830, '07Jul2018'd, 40267, 614123, , , 880865, 10071, 120400, , , 104576, '08Jul2018'd, 11281, , , , , 2820, , , , , '09Jul2018'd, 28007, -3751, -5888, 163585, 39468, 33729, -497, 339, , 3890, '10Jul2018'd, 203028, 667, -2699, 133130, 32280, 33242, 247, 584, , 3384, '11Jul2018'd, 181284, 2403, 4714, 76037, 77907, 45330, 566, 674, , 5093, '12Jul2018'd, 151623, 4630, 4347, 207368, 34093, 37912, 806, 878, , 2721, '13Jul2018'd, 212817, -880, 6720, 186730, 33609, 53211, -219, 1029, , 4132, '14Jul2018'd, 34218, , 2949454, , , 8555, , 166444, , , '15Jul2018'd, 11042, , 426, , , 2761, , 41, , , '16Jul2018'd, 150107, -9608, -13884, 226044, 44506, 37537, -1780, -603, , 5640, '17Jul2018'd, 160582, 4725, 9770, 178306, 75222, 40376, 914, 1399, , 6596, '18Jul2018'd, 145533, 51, 4512, 134815, 5339, 36387, -8, 941, , 886, '19Jul2018'd, 117162, -186, 2483, 100912, 25082, 31350, 34, 1350, , 2748, '20Jul2018'd, 238542, 726, 7896, 48690, 28771, 57698, 175, 902, , 3365, '21Jul2018'd, 28083, , -8227, , 26, 7021, , -586, , , '22Jul2018'd, 9988, 193, -8592, , , 2497, 39, -728, , , '23Jul2018'd, 121366, -1833, -12213, 211134, 32497, 34952, -191, -369, , 3742, '24Jul2018'd, 170622, 3245, 7832, 224107, 69375, 38006, 638, 946, , 4844, '25Jul2018'd, 76741, 40976, 9063, 555462, 125614, 19242, 8102, 1834, , 11156, '26Jul2018'd, 172898, 7270, 3721, 195137, 12940, 43226, 1430, -370, , 495, '27Jul2018'd, 207261, 6232, -6508, 220140, 75934, 51873, 1271, 232, , 7668, '28Jul2018'd, 34251, , -5521, , , 8563, , -328, , , '29Jul2018'd, 11359, -233, -10858, , 3458, 2840, -47, -775, , 492, '30Jul2018'd, 162703, 105171, -1701, 68454, 422204, 40680, 982, 1165, , 6921, '31Jul2018'd, 157955, -34140, 14595, 71289, 33967, 39496, -6817, 1541, , 4437, 2016749 '01Aug2018'd, 102176, 6544, 5002, 2281, 2437, 36185, 1337, 937, , 544, '02Aug2018'd, 203737, 4912, 4440, 83610, 69191, 40656, 999, 624, , 11720, '03Aug2018'd, 179749, 2314, 3556, 4652, 35627, 44940, 463, 498, , 5301, '04Aug2018'd, 71424, 802702, -4678, , 1451433, 17366, 156564, -416, , 149006, '05Aug2018'd, 11322, 697, -6838, , -1130, 2831, 139, -424, , -113, '06Aug2018'd, 148123, -2583, -1772, 75915, 38331, 37034, -458, 156, , 3961, '07Aug2018'd, 145122, 4503, 766, 74315, 39052, 36185, 940, 298, , 4801, '08Aug2018'd, 126983, 33, 144, 35105, 76639, 31747, 24, 562, , 3562, '09Aug2018'd, 139680, 51649, -6291, 11928, 203593, 34925, 10255, 265, , 16645, '10Aug2018'd, 164617, 1965, 270, 227940, 36059, 41157, 407, 306, , 4191, '11Aug2018'd, 33079, , 3518026, , , 8270, , 204695, , , '12Aug2018'd, 11086, , -12842, , , 2772, , -652, , , '13Aug2018'd, 124259, -3013, 484, 167964, 55307, 31067, -501, -175, , 5739, '14Aug2018'd, 99605, 345, 5655, 109522, 96068, 24908, 91, 571, , 7904, '15Aug2018'd, 8141, , , , , 2035, , , , , '16Aug2018'd, 85102, -1100, -10978, 125292, -113464, 21277, -154, -317, , 468, '17Aug2018'd, 104407, 359, -5132, 48358, 189067, 26109, 49, -37, , 1579, '18Aug2018'd, 24997, , -5637, , , 6250, , -532, , , '19Aug2018'd, 12777, -99, -7044, , , 3194, -20, -489, , , '20Aug2018'd, 104011, -5152, 1245, 184599, 33163, 25972, -995, 450, , 4039, '21Aug2018'd, 131654, 2053, 84, 113597, 39278, 32833, 404, 12, , 1164, '22Aug2018'd, 108015, -389, -995, 56755, 21668, 27013, -21, 174, , 2090, '23Aug2018'd, 105491, 833, -6547, 77520, 15986, 26375, 169, 64, , 2114, '24Aug2018'd, 128067, 4266, -2681, 39016, 93693, 32028, 807, -147, , -2608, '25Aug2018'd, 24588, -900, -6203, , , 6148, -180, -522, , , '26Aug2018'd, 12548, , -9229, , , 3137, , -664, , , '27Aug2018'd, 127141, -4243, -3269, 138027, -96908, 31787, -793, 113, , 850, '28Aug2018'd, 122929, -189, -2514, 31039, 85069, 30734, -77, -31, , 4787, '29Aug2018'd, 92643, 110132, -491, 14641, 28515, 23162, -96, 745, , 2891, '30Aug2018'd, 108042, -6548, 10429, 1908, 11797, 27012, -1321, 1144, , 1247, '31Aug2018'd, 146769, 4901, 5211, 68175, 95843, 36695, 941, 527, , 9680, 1029614 '01Sep2018'd, 34139, , -6057, , , 8541, , -341, , , '02Sep2018'd, 8687, , -8144, , , 2172, , -575, , , '03Sep2018'd, 164557, 4606, 3549, 41516, 57069, 41145, 889, 371, , 9247, '04Sep2018'd, 152434, 2682, 1529, 30365, 101253, 38111, 531, 359, , 12571, '05Sep2018'd, 139270, 3157, 7212, 44398, 12414, 34820, 622, 1340, , 1170, '06Sep2018'd, 159455, 1880, -44187, 42429, 35579, 39872, 426, -4406, , 4258, '07Sep2018'd, 183352, 1780, 8988, 67418, 12250, 45841, 336, 792, , 1144, '08Sep2018'd, 57819, 808415, -3587, , 1429592, 13192, 157600, -191, , 160462, '09Sep2018'd, 13693, , -8336, , , 3423, , -877, , , '10Sep2018'd, 169419, -2763, 3351, 241043, 79905, 42365, -448, 476, , 7115, '11Sep2018'd, 133497, 1068, -17122, 455032, 19255, 33380, 292, -1461, , 2326, '12Sep2018'd, 133158, 4512, 10227, 302176, 30717, 33292, 787, 812, , 2451, '13Sep2018'd, 137569, 2486, 5518, 97198, 50436, 34445, 420, 613, , 4453, '14Sep2018'd, 170973, 3468, 2043, 129781, 356142, 42757, 685, 247, , 15337, '15Sep2018'd, 23219, -24, 3717821, , , 5805, -5, 198540, , , '16Sep2018'd, 5501, , -11208, , , 1375, , -796, , , '17Sep2018'd, 152376, -42008, 4977, 314602, 290744, 38097, -8385, 587, , 1293, '18Sep2018'd, 134136, -2971, -3463, 760691, 42924, 33536, -590, 276, , 3230, '19Sep2018'd, 122683, 112125, 4676, 150198, 22657, 30673, 447, 813, , 2427, '20Sep2018'd, 173481, -967, -5761, 27631, 28838, 43380, -157, 51, , 1890, '21Sep2018'd, 166837, 2483, 4302, 48807, 121554, 41718, 464, 878, , 11047, '22Sep2018'd, 30528, -192, -7433, , 4779, 7635, -38, -357, , , '23Sep2018'd, 13787, -55, -7752, , , 3447, -11, -349, , , '24Sep2018'd, 135243, -5046, 6328, 571249, 158767, 33815, -888, 1209, , 9595, '25Sep2018'd, 113603, -4208, -4848, 23742, 16830, 28893, -871, -24548, , 694, '26Sep2018'd, 142387, 2402, 7546, 57155, 55289, 34924, 457, 981, , 5309, '27Sep2018'd, 150045, 7216, 450, 137530, 76742, 38777, 1473, 13, , 2618, '28Sep2018'd, 217696, 44753, 3429, 175788, 109448, 53119, 9003, 634, , 8455, '29Sep2018'd, 42829, -560, -2894, , 62668, 10708, -112, -198, , 70, '30Sep2018'd, 11944, -379, -2501, , 10424, 2986, -76, -103, , , 860350 '01Oct2018'd, 164387, -2045, -2192, 88563, 34566, 41112, -395, 151, , 3464, '02Oct2018'd, 164207, 767, 23255, 31658, 45478, 41054, 150, 578, , 1418, '03Oct2018'd, 142612, 367, 16969, 41661, 99109, 35656, 147, 451, , 12624, '04Oct2018'd, 147297, 961, 8819, 67355, 152737, 36826, 198, 879, , 20177, '05Oct2018'd, 177405, -1292, 379, 101204, 56459, 44361, -258, 505, , 6076, '06Oct2018'd, 60561, 817725, -8515, , 1197456, 12867, 159860, -686, , 140393, '07Oct2018'd, 12603, -182, -1697, , , 3151, -36, -94, , , '08Oct2018'd, 173089, 1043, 7725, 23607, 47902, 43275, 291, 709, , 1435, '09Oct2018'd, 151691, 257, 1399, 59346, 53295, 37925, 42, 795, , 4556, '10Oct2018'd, 140801, 3662, -908, 66315, 34459, 35185, 710, 103, , 3482, '11Oct2018'd, 203253, 3145, 9279, 149813, 61524, 50815, 629, 1133, , 6716, '12Oct2018'd, 186413, -1593, 1475, 120569, -34596, 46616, -359, 570, , -2304, '13Oct2018'd, 29392, , 3586308, , , 7348, , 211084, , , '14Oct2018'd, 15618, , -4318, , 764, 3905, , -321, , 115, '15Oct2018'd, 146038, 1149, 10932, 131872, 39354, 36512, 240, 1464, , 4488, '16Oct2018'd, 140797, 1221, 12371, 230156, 246266, 35211, 164, 1340, , 31793, '17Oct2018'd, 119291, 3549, 6068, 171614, -4419, 30002, 716, 771, , -1265, '18Oct2018'd, 133476, 5129, -4601, 303067, 26547, 33371, 943, 1227, , 2632, '19Oct2018'd, 169800, 2192, 15120, 181423, 64297, 42453, 459, 1424, , 2348, '20Oct2018'd, 28700, , , , , 7176, , , , , '21Oct2018'd, 11997, , 1, , 189, 3000, , 0, , 28, '22Oct2018'd, 124030, -245, -4675, 142301, 16278, 31009, 19, -340, , 2431, '23Oct2018'd, 150011, 39, -396, 148997, 70491, 37505, 90, 110, , 2342, '24Oct2018'd, 125780, 155557, 16144, 125268, 12898, 31448, 10459, 1677, , 1625, '25Oct2018'd, 128191, 7709, 8765, 48933, 23216, 32057, 1382, 1116, , 1863, '26Oct2018'd, 123178, -2035, -465, 97080, 5355, 30801, -412, 371, , 738, '27Oct2018'd, 32235, , -273, , , 8059, , -25, , , '03Jan2019'd, 186736, 507, -8225, 109955, 49255, 45051, 89, -311, , 3038, '04Jan2019'd, 165675, -766, 4421, 19225, 108993, 42707, -124, 507, , 11144, '05Jan2019'd, 60425, 677226, , , 1030049, 15107, 131779, , , 119777, '06Jan2019'd, 16197, , , , 374, 4050, , , , 37, '07Jan2019'd, 169640, 2523, -19938, 12565, 32404, 42413, 570, -957, , 3255, '08Jan2019'd, 159878, -531, 9474, 26136, 52510, 41277, -61, 699, , 4743, '09Jan2019'd, 146278, -3614, -2838, 47674, 72028, 36572, -943, 515, , 3676, '10Jan2019'd, 169699, -938, 4049, 30245, -32038, 42428, -175, 747, , 2644, '11Jan2019'd, 206751, -24345, 6914, 72339, 133089, 51474, -4908, 660, , 19789, '12Jan2019'd, 48975, , 3347830, , , 12252, , 189085, , , '13Jan2019'd, 20527, , , , , 5132, , , , , '14Jan2019'd, 157616, 473, -13012, 132218, 202506, 39375, 183, -580, , 6439, '15Jan2019'd, 5588, 140101, 7239, 130223, 6849, 19266, -981, 670, , 986, '16Jan2019'd, 55822, 6389, -1052, 102281, 132506, 49019, 1183, -334, , 7207, '17Jan2019'd, 87541, 829, 4680, 19945, 13534, -14725, 145, 665, , 1644, '18Jan2019'd, 392341, 5546, -235, 626654, 75145, 98089, 1078, 383, , 8576, '19Jan2019'd, 36894, 60, -744, , , 9226, 12, -193, , , '20Jan2019'd, 10227, , , , , 2557, , , , , '21Jan2019'd, 103893, -6842, -16850, 184420, -18615, 25976, -1212, -1250, , -2237, '22Jan2019'd, 218342, 2624, 5412, 483671, 24483, 54803, 502, 917, , 2989, '23Jan2019'd, 56846, 1281, 7175, 311386, 53461, 26369, 271, 671, , 5156, '24Jan2019'd, 130112, 1368, 1929, 162607, 294232, 43819, 183, 437, , 9315, '25Jan2019'd, 231587, 3398, 5889, 205883, 37561, 47659, 598, 1273, , 2203, '26Jan2019'd, 40754, , , , , 10189, , , , , '27Jan2019'd, 17766, 191, 297, , , 4442, 38, 24, , , '28Jan2019'd, 155421, 2414, -16976, 115722, 12819, 38846, 474, -632, , 2127, '29Jan2019'd, 150014, 52768, 4262, 413778, 60783, 36568, 10535, 745, , 944, '30Jan2019'd, 138382, 985, 11142, 230665, 106953, 34598, 208, 1239, , 5541, '31Jan2019'd, 147937, -2537, 5157, 615791, 105095, 36987, -321, 380, , 1970, 841988 '01Feb2019'd, 179218, 2155, -4964, 54950, 76375, 44807, 373, -312, , 9505, '02Feb2019'd, 141054, 751708, 263, , 1814987, 30510, 146067, 55, , 212352, '03Feb2019'd, 15988, 49, 830, , , 3998, 10, 79, , , '04Feb2019'd, 157171, -3057, -11129, 47985, 27745, 39295, -595, -277, , 741, '05Feb2019'd, 161355, -1279, -775, 15070, -1038, 40233, -270, 872, , 553, '06Feb2019'd, 141787, 3624, 13879, 79959, 64854, 34659, 732, 488, , 9543, '07Feb2019'd, 125254, 2253, -5755, 10873, -82892, 35829, 494, 361, , 9758, '08Feb2019'd, 182316, 3022, 10945, 95416, 55845, 45595, 581, 1603, , 4026, '09Feb2019'd, 30871, , 4238594, , , 7718, , 257417, , , '10Feb2019'd, 15386, , 46, , 2615, 3848, , 5, , 262, '11Feb2019'd, 126646, -2582, -23554, 11590, 41696, 31664, -582, -331, , -4022, '12Feb2019'd, 148451, 2857, 12192, 196124, 42137, 37117, 588, 2048, , 5068, '13Feb2019'd, 136614, 1659, 45045, 416357, 93124, 34156, 286, 832, , 4017, '14Feb2019'd, 140195, 900, 34902, 32595, 53480, 31671, 113, 2014, , 6149, '15Feb2019'd, 143380, 3897, 318, 231516, 16881, 35847, 716, 689, , 303, '16Feb2019'd, 32299, , , , , 8075, , , , , '17Feb2019'd, 10170, , , , , 2543, , , , , '18Feb2019'd, 138800, -4256, -26194, 1723105, 106733, 34113, -701, -283, , 6306, '19Feb2019'd, 123447, 2554, 27, 44920, 39891, 30873, 445, 472, , 3660, '20Feb2019'd, 120245, 1746, -10046, 136729, 52224, 30654, 366, -54, , 6548, '21Feb2019'd, 121131, 2971, -2148, 78485, 167123, 30292, 537, 654, , 21084, '22Feb2019'd, 148816, 36253, 26292, 298266, 56378, 37380, 7214, 1723, , 7466, '23Feb2019'd, 29941, 299, , , 17657, 7486, 60, , , -115, '24Feb2019'd, 14580, , 0, , -69, 3645, , 0, , -27, '03Apr2019'd, 151276, -1019, 10896, 119843, 96446, 37895, -204, 630, , 14202, '04Apr2019'd, 152852, 1559, -1494, 48139, 6609, 38221, 337, 891, , 389, '05Apr2019'd, 184089, 4559, 9143, 81370, 107273, 46025, 803, 1039, , 9905, '06Apr2019'd, 130293, 746033, -302, , 1309937, 27146, 145956, -30, , 146426, '07Apr2019'd, 11368, , , , , 2842, , , , , '08Apr2019'd, 126778, -4237, -5701, 406612, 63865, 35859, -803, -60, , 6766, '09Apr2019'd, 163446, 6183, 19762, 137936, 84707, 36302, 1237, 1831, , 10501, '10Apr2019'd, 147956, 1667, 6204, 101398, 71587, 36992, 221, 1105, , 3677, '11Apr2019'd, 151475, 2828, 23020, 60600, 29595, 37871, 504, 2600, , 381, '12Apr2019'd, 165375, -528, -4417, , -1592, 41346, -86, -452, , -239, '13Apr2019'd, 37899, , 3909282, , 8374, 9475, , 232985, , , '14Apr2019'd, 14646, , , , , 3662, , , , , '15Apr2019'd, 147586, -205, 6245, 478536, 46409, 36899, -37, 1609, , 6391, '16Apr2019'd, 171630, 288, 15512, 311525, 27221, 42910, 18, 870, , 3030, '17Apr2019'd, 139129, 10603, 11765, 219792, 47756, 34791, 2099, 1491, , 5491, '18Apr2019'd, 187860, 4243, 26968, 232687, 334072, 46808, 863, 2915, , 2520, '19Apr2019'd, 184984, 4760, 6154, 185486, 102650, 46250, 830, 1128, , 2964, '20Apr2019'd, 42272, 194, , , 369, 10569, 39, , , 51, '21Apr2019'd, 10297, , , , 12375, 2574, , , , , '22Apr2019'd, 165480, 41934, -11535, 81109, 16331, 41374, 8460, 310, , 1358, '23Apr2019'd, 196997, 7465, 11574, 624335, 62353, 48784, 1410, 1560, , 7265, '24Apr2019'd, 200796, 85396, 29373, 145599, 62202, 50204, 815, 2330, , 5518, '25Apr2019'd, 212369, 4216, 13626, 608572, 22234, 53096, 916, 1589, , 1689, '26Apr2019'd, 40280, , , , , 10071, , , , , '27Apr2019'd, 24261, , , , , 6066, , , , , '28Apr2019'd, 3733, , , , , 933, , , , , '29Apr2019'd, 10420, , 1764, , 0, 2605, , 30, , , '12Jun2019'd, 144018, 2405, 2625, 676774, 23374, 36010, 564, 1524, , 3431, '13Jun2019'd, 112225, 21289, 12524, 36024, 33970, 36473, 1955, 1388, , 3260, '14Jun2019'd, 248947, 3240, 10231, 166384, 38502, 52262, 636, 1213, , 2411, '15Jun2019'd, 42070, , 3606506, , 433, 10518, , 220615, , , '16Jun2019'd, 12965, , , 45062, , 3241, , , , , '17Jun2019'd, 23119, 101, , 149, , 5780, 20, , , , '18Jun2019'd, 165635, -6317, -20742, 168740, 75604, 41421, -1153, -623, , 6858, '19Jun2019'd, 158341, 2968, 8805, 82452, 17540, 39588, 574, 1792, , 1562, '20Jun2019'd, 145934, 3460, 15070, 292612, 29930, 36304, 728, 1980, , 1501, '21Jun2019'd, 195189, 92607, 6211, 72068, 142738, 48801, 484, 889, , 5404, '22Jun2019'd, 40968, , 552, , 22344, 10243, , 30, , 1802, '23Jun2019'd, 12881, , , , 7612, 3221, , , , 201, '24Jun2019'd, 125563, -5138, -14160, 318640, 420633, 31575, -949, -864, , 8645, '25Jun2019'd, 152197, 2876, 17009, 142108, 5787, 37877, 600, 1753, , 2854, '26Jun2019'd, 120053, 41981, 5067, 120701, 4653, 29899, 8442, 906, , 4139, '27Jun2019'd, 75359, 7589, 28416, 13441, 174344, 36606, 1457, 1981, , 4969, '28Jun2019'd, 275045, 7485, 15047, 507557, 176354, 53294, 1027, 1556, , 7768, '29Jun2019'd, 41596, , 422, , , 10400, , 57, , , '30Jun2019'd, 11845, , , , 10, 2962, , , , 1, 119366 '01Jul2019'd, 168222, 625, -9998, 208813, 77265, 42059, 62, -579, , 11250, '02Jul2019'd, 165023, 2372, 1976, 80571, 137490, 41259, 494, 863, , 16235, '03Jul2019'd, 115184, 3382, 8024, 715001, 56682, 28799, 708, 1040, , 5716, '04Jul2019'd, 207278, 3495, 16208, 9742, 68889, 51833, 699, 927, , 6726, '05Jul2019'd, 194787, 4425, 5682, 68862, 101207, 46675, 885, 464, , 10195, '06Jul2019'd, 65587, 622154, , , 829833, 16397, 121945, , , 95995, '07Jul2019'd, 13885, , , , , 3471, , , , , '08Jul2019'd, 158312, 2011, -1248, 156344, 47112, 39581, 428, -122, , 3738, '09Jul2019'd, 159595, 3917, 8186, 569204, 18424, 39904, 794, 1055, , 1676, '10Jul2019'd, 153124, 4143, 3429, 78280, 16021, 38085, 797, 641, , 1796, '11Jul2019'd, 153731, -1769, 11483, 14165, 93971, 38435, -344, 2958, , 15193, '12Jul2019'd, 190283, 7314, 9512, 244751, 26999, 47581, 1202, 927, , 2430, '13Jul2019'd, 40535, , 3206581, , , 10135, , 193783, , , '14Jul2019'd, 14561, , , , , 3641, , , , , '15Jul2019'd, 165354, -5420, -7611, 244266, 20906, 41341, -929, 15, , 2513, '16Jul2019'd, 154533, 2287, 4835, 242131, 59837, 38636, 484, 696, , 5672, '17Jul2019'd, 104123, 3943, 3784, 146151, 43791, 26035, 804, 644, , 5366, '18Jul2019'd, 189709, 3276, 7970, 522221, 53179, 52082, 685, 1059, , 2623, '19Jul2019'd, 182669, 147732, -2679, 166003, 1008, 41352, 8796, -40, , 258, '20Jul2019'd, 26998, 0, , , 1977, 6750, 0, , , 297, '21Jul2019'd, 12249, , , 5818, , 3062, , , , , '22Jul2019'd, 162107, 737, -9626, 217992, 37440, 40532, 151, -606, , 2257, '23Jul2019'd, 145540, 3764, 21195, 116975, 110572, 36082, 753, 1785, , 8437, '24Jul2019'd, 136120, 5890, -4111, 153041, 32835, 34039, 1198, 232, , 3986, '25Jul2019'd, 145201, 5165, 20087, 46882, 27753, 36303, 856, 1052, , 3437, '26Jul2019'd, 158956, 4450, 17830, 74389, 29212, 39742, 831, 1637, , 3912, '27Jul2019'd, 34372, , , , 3586, 8593, , , , 455, '28Jul2019'd, 14067, , , , , 3517, , , , , '29Jul2019'd, 146525, -3308, -12874, 68277, 66156, 36637, -632, -333, , 1848, '30Jul2019'd, 156525, 6965, 9669, 957717, 82520, 39134, 1191, 1621, , 8999, '31Jul2019'd, 151031, 607, 12694, 182076, 161708, 37765, 165, 1491, , 2598, 175954 '01Aug2019'd, 154553, 3921, 3398, 16248, 51323, 38640, 744, 581, , 4589, '02Aug2019'd, 176425, 128386, 2069, 64885, 97274, 44109, 460, 659, , 10020, '03Aug2019'd, 85151, 759050, , , 1368874, 20633, 148061, , , 147944, '04Aug2019'd, 14719, , -1093, , , 3680, , -66, , , '05Aug2019'd, 153280, -6449, -15072, 94674, 102168, 38322, -1205, -383, , 15034, '06Aug2019'd, 148176, 2662, 5467, 58664, 19969, 37704, 529, 939, , 953, '07Aug2019'd, 134655, 2580, -7487, 162662, 15957, 33078, 562, 419, , 1508, '08Aug2019'd, 131497, 2488, 1294, 105350, 14982, 32876, 560, 574, , 2066, '09Aug2019'd, 179746, 1596, 6519, 136197, 35788, 44939, 367, 1005, , 3902, '10Aug2019'd, 29187, , 3857959, , , 7297, , 241401, , , '11Aug2019'd, 10286, , , , , 2572, , , , , '12Aug2019'd, 133650, -3789, -15359, 65468, -2195, 33414, -709, -817, , -19, '13Aug2019'd, 125885, 2321, 1773, 52140, 98301, 31473, 449, 371, , 12753, '14Aug2019'd, 105353, 44126, 2518, 10875, 72240, 26340, 8831, 560, , 4492, '15Aug2019'd, 6279, , , , , 1570, , , , , '16Aug2019'd, 72926, -1384, -6405, 7193, 32848, 18240, -262, -324, , 1613, '17Aug2019'd, 20835, , , , , 5209, , , , , '18Aug2019'd, 12457, , , , , 3114, , , , , '19Aug2019'd, 119825, -8109, -8098, 193778, 3756, 29958, -1124, -78, , 83, '20Aug2019'd, 118314, 2684, 6003, 195191, 73293, 29500, 529, 366, , 392, '21Aug2019'd, 101684, 1022, 7422, 86873, 11947, 25423, 230, 926, , 1283, '22Aug2019'd, 106881, 41, 707, 32344, 15265, 26728, -7, 379, , 1109, '23Aug2019'd, 118826, 327, 2311, 59628, 21430, 29708, 51, 516, , 2597, '24Aug2019'd, 29149, , , , , 7288, , , , , '25Aug2019'd, 10953, 22, 2650, , , 2738, 4, 30, , , '26Aug2019'd, 122193, -3303, -23067, 33762, 21982, 30551, -551, -1720, , 2578, '27Aug2019'd, 124138, -247, -5698, 159516, 197368, 31036, -47, -198, , 3841, '28Aug2019'd, 112977, 3907, -4713, 523758, 51338, 28250, 804, -231, , 3689, '29Aug2019'd, 99244, 665, -5580, 242263, 170080, 24816, 145, 339, , 2009, '30Aug2019'd, 145023, -1091, 2358, 120652, 45156, 36266, -181, 293, , 1718, '31Aug2019'd, 20445, , , , , 5112, , , , , 61823 '01Sep2019'd, 17416, , , , , 4354, , , , , '02Sep2019'd, 138481, -1793, -9593, 560071, 96790, 34622, -350, -50, , 13933, '03Sep2019'd, 147902, 3928, -1706, 632184, 171099, 36978, 776, 404, , 24054, '04Sep2019'd, 135114, 2262, 5597, 15569, 170979, 33789, 429, 639, , 21103, '05Sep2019'd, 149977, 2242, 9408, 102921, 62148, 37496, 365, 972, , 3217, '06Sep2019'd, 178666, -188, 4304, 38343, 34432, 44675, 11, 538, , 3064, '07Sep2019'd, 47325, 790783, , , 1387486, 10724, 154289, , , 157870, '08Sep2019'd, 11007, , , , , 2752, , , , , '09Sep2019'd, 164155, -1106, -3131, 261808, 32394, 41042, -126, -134, , 4083, '10Sep2019'd, 141511, 797, -4847, 25770, 22540, 35380, 182, -207, , 1835, '11Sep2019'd, 123120, -63, 6524, 87090, 52427, 30782, -6, 551, , 3890, '12Sep2019'd, 136835, 4912, 3583, 65151, 371574, 34211, 913, 661, , 1593, '13Sep2019'd, 176599, 1241, 10875, 67375, 14736, 44084, 149, 1291, , 1769, '14Sep2019'd, 43485, , 4065039, , , 10872, , 236012, , , '15Sep2019'd, 17196, , , 32442, , 4299, , , , , '16Sep2019'd, 121608, -4319, -3861, 198840, 48870, 30407, -891, 103, , -989, '17Sep2019'd, 155770, 105332, 1627, 246127, 5098, 38947, 291, 443, , 2637, '18Sep2019'd, 118436, 40793, 1119, 595594, 91392, 29611, 8207, 505, , 1982, '19Sep2019'd, 136587, -171, 13598, 142949, 44324, 34149, -1, 1587, , 3258, '20Sep2019'd, 157207, 7404, 8171, 470006, 11069, 40420, 1414, 819, , 1409, '21Sep2019'd, 35589, , , , , 8898, , , , , '22Sep2019'd, 15969, , , , , 3992, , , , , '23Sep2019'd, 136993, -6322, -13762, 245540, 17117, 34125, -1098, -1015, , 1327, '24Sep2019'd, 127416, -803, 5057, 188542, 52753, 31163, -136, 546, , 1662, '25Sep2019'd, 107583, 2991, 5510, 16909, 22992, 27801, 566, 1159, , 2818, '26Sep2019'd, 148988, 7000, -25, 203000, 51879, 37256, 1361, 1582, , 4086, '27Sep2019'd, 204834, 1465, 8744, 71709, 38961, 51301, 203, 962, , 3268, '28Sep2019'd, 48977, , , , , 12248, , , , , '29Sep2019'd, 17926, , , , , 4482, , , , , '30Sep2019'd, 171099, -10374, -11769, 603129, 647194, 42780, -1846, -589, , 5361, 50955 '01Oct2019'd, 158828, 1957, 17488, 44524, 41550, 39726, 372, 1792, , 4572, '02Oct2019'd, 142013, 3639, 6212, 57808, 18246, 35562, 645, 869, , 3817, '03Oct2019'd, 157685, 2383, 5939, 99447, 246723, 39425, 466, 913, , 29858, '04Oct2019'd, 171810, 1226, 9097, 671498, 111199, 42956, 274, 989, , 11127, '05Oct2019'd, 70894, 797151, , , 1200799, 14012, 155866, , , 142975, '06Oct2019'd, 15894, , , , , 3974, , , , , '07Oct2019'd, 154404, -3048, -2323, 175518, 21967, 38749, -556, 548, , 2608, '08Oct2019'd, 149483, 383, 6494, 52900, 325258, 37373, 25, 1038, , 3437, '09Oct2019'd, 179114, 1739, 8269, 88799, 18756, 44787, 309, 1119, , 1795, ; run; /*************/ %MACRO loopW(L); PROC SQL; CREATE TABLE WORK.Rolling05_&L. AS SELECT sum(a.WP_M) + sum(a.WP_NLR_NM) + sum(a.WP_LR) + sum(a.WP_NLC) + sum(a.WP_LC_Auto) + sum(a.WP_LC_Manual) FORMAT=EUROX18.2 as WP, sum(a.WP_M) + sum(a.WP_NLR_NM) FORMAT=EUROX18.2 as WP_NLR, sum(a.WP_M) FORMAT=EUROX18.2 as WP_M, sum(a.WP_NLR_NM) FORMAT=EUROX18.2 as WP_NLR_NM, sum(a.WP_LR) FORMAT=EUROX18.2 as WP_LR, sum(a.WP_NLC) FORMAT=EUROX18.2 as WP_NLC, sum(a.WP_LC_Auto) + sum(a.WP_LC_Manual) FORMAT=EUROX18.2 as WP_LC, sum(a.WP_LC_Auto) FORMAT=EUROX18.2 as WP_LC_Auto, sum(a.WP_LC_Manual) FORMAT=EUROX18.2 as WP_LC_Manual, sum(a.PF_M) + sum(a.PF_NLR_NM) + sum(a.PF_LR) + sum(a.PF_NLC) + sum(coalesce(a.PF_LC_Auto, 0)) FORMAT=EUROX18.2 as PF, sum(a.PF_M) + sum(a.PF_NLR_NM) FORMAT=EUROX18.2 as PF_NLR, sum(a.PF_M) FORMAT=EUROX18.2 as PF_M, sum(a.PF_NLR_NM) FORMAT=EUROX18.2 as PF_NLR_NM, sum(a.PF_LR) FORMAT=EUROX18.2 as PF_LR, sum(a.PF_NLC) FORMAT=EUROX18.2 as PF_NLC, sum(a.PF_LC_Auto) FORMAT=EUROX18.2 as PF_LC from work.all_data04 a where (a.Issue_Date GE intnx('year', (today()- (&L.)+1), -1,'same')) and (Issue_Date LE (TODAY()- (&L.))); QUIT; %MEND loopW;
%loopw(1); %loopw(2); %loopw(3); %loopw(4); %loopw(5); %loopw(6); %loopw(7);
data WORK.Rolling05_All; set WORK.Rolling05_1 WORK.Rolling05_2 WORK.Rolling05_3 WORK.Rolling05_4 WORK.Rolling05_5 WORK.Rolling05_6 WORK.Rolling05_7; run;
PROC SQL; drop table WORK.Rolling05_1; drop table WORK.Rolling05_2; drop table WORK.Rolling05_3; drop table WORK.Rolling05_4; drop table WORK.Rolling05_5; drop table WORK.Rolling05_6; drop table WORK.Rolling05_7; quit;
... View more