options validvarname=v7; libname unit3lib xlsx "/home/u43642319/ccerdaiiiphd/Sales_Data_U3_A1.xlsx"; proc sort; by Store; run; proc means data=unit3lib.Sales_Data_U3_A1 noprint; var Sales; by Store; output out=newsales; run; proc print data=newsales; run; data Store Day_of_year Sales A 1 3973 A 2 2957 A 3 402 A 4 9761 A 5 6244 A 6 2001 A 7 7880 A 8 7460 A 9 861 A 10 3681 A 11 3219 A 12 3895 A 13 3054 A 14 7676 A 15 7182 A 16 3411 A 17 2336 A 18 6126 A 19 6853 A 20 649 A 21 1164 A 22 7253 A 23 6437 A 24 953 A 25 8049 A 26 4790 A 27 5467 A 28 7563 A 29 342 A 30 6203 A 31 8555 A 32 5116 A 33 4922 A 34 9653 A 35 6909 A 36 4607 A 37 4821 A 38 2844 A 39 3472 A 40 1295 A 41 7614 A 42 8463 A 43 2935 A 44 2309 A 45 802 A 46 9307 A 47 6211 A 48 8100 A 49 8745 A 50 1160 A 51 1321 A 52 1334 A 53 489 A 54 373 A 55 8429 A 56 1821 A 57 3195 A 58 7266 A 59 4319 A 60 9391 A 61 8350 A 62 2835 A 63 2567 A 64 7131 A 65 8586 A 66 1528 A 67 6466 A 68 8063 A 69 2022 A 70 9644 A 71 1253 A 72 3934 A 73 7845 A 74 9255 A 75 5540 A 76 6763 A 77 4391 A 78 3292 A 79 4428 A 80 7298 A 81 8410 A 82 3862 A 83 5905 A 84 6403 A 85 5986 A 86 8726 A 87 2682 A 88 8440 A 89 7689 A 90 2666 A 91 9885 A 92 5333 A 93 1708 A 94 4435 A 95 9614 A 96 7794 A 97 787 A 98 5272 A 99 5255 A 100 9757 A 101 7233 A 102 8580 A 103 7079 A 104 2348 A 105 9034 A 106 5004 A 107 512 A 108 1213 A 109 8122 A 110 5388 A 111 6252 A 112 9273 A 113 6179 A 114 1984 A 115 1117 A 116 4620 A 117 9610 A 118 2190 A 119 2048 A 120 8593 A 121 7885 A 122 5266 A 123 8269 A 124 9937 A 125 7688 A 126 3843 A 127 118 A 128 4095 A 129 4536 A 130 8522 A 131 7359 A 132 6774 A 133 2141 A 134 6755 A 135 7796 A 136 5074 A 137 2524 A 138 8229 A 139 5489 A 140 208 A 141 8995 A 142 7363 A 143 4669 A 144 2991 A 145 9588 A 146 2555 A 147 4643 A 148 9927 A 149 5384 A 150 4413 A 151 5524 A 152 563 A 153 584 A 154 6850 A 155 7411 A 156 3708 A 157 747 A 158 8035 A 159 1107 A 160 8005 A 161 8057 A 162 5511 A 163 3230 A 164 429 A 165 3001 A 166 1879 A 167 703 A 168 4087 A 169 8583 A 170 4751 A 171 4807 A 172 4816 A 173 4871 A 174 1356 A 175 3951 A 176 6964 A 177 1769 A 178 5809 A 179 6011 A 180 9943 A 181 8521 A 182 1190 A 183 7894 A 184 5877 A 185 7143 A 186 7198 A 187 3283 A 188 8292 A 189 683 A 190 6980 A 191 4385 A 192 7535 A 193 1280 A 194 6326 A 195 5342 A 196 3887 A 197 9180 A 198 2483 A 199 4366 A 200 6848 A 201 6228 A 202 2698 A 203 3590 A 204 7656 A 205 6554 A 206 8361 A 207 1796 A 208 9980 A 209 4994 A 210 9377 A 211 8011 A 212 223 A 213 7847 A 214 771 A 215 4398 A 216 2183 A 217 2544 A 218 1531 A 219 1842 A 220 9559 A 221 2219 A 222 1401 A 223 3108 A 224 6429 A 225 2171 A 226 2165 A 227 2277 A 228 9201 A 229 2671 A 230 4603 A 231 2558 A 232 6797 A 233 4359 A 234 1733 A 235 9565 A 236 1259 A 237 7167 A 238 1637 A 239 8144 A 240 3147 A 241 8837 A 242 460 A 243 7664 A 244 9253 A 245 7321 A 246 1252 A 247 9092 A 248 7549 A 249 2176 A 250 6435 A 251 5094 A 252 4420 A 253 5933 A 254 9239 A 255 197 A 256 1438 A 257 5774 A 258 5182 A 259 313 A 260 7309 A 261 1567 A 262 1331 A 263 9458 A 264 9492 A 265 4668 A 266 5294 A 267 2041 A 268 7421 A 269 8628 A 270 3648 A 271 3573 A 272 6294 A 273 4699 A 274 5900 A 275 2597 A 276 7461 A 277 6518 A 278 6020 A 279 1481 A 280 890 A 281 8158 A 282 7117 A 283 4079 A 284 429 A 285 5879 A 286 6159 A 287 2540 A 288 4684 A 289 1489 A 290 8690 A 291 7173 A 292 8168 A 293 4954 A 294 8493 A 295 7417 A 296 448 A 297 7931 A 298 265 A 299 379 A 300 3881 A 301 3364 A 302 5043 A 303 6312 A 304 595 A 305 2745 A 306 2206 A 307 2995 A 308 908 A 309 2991 A 310 9383 A 311 7605 A 312 9380 A 313 1292 A 314 2274 A 315 2977 A 316 5003 A 317 8090 A 318 862 A 319 3713 A 320 5695 A 321 636 A 322 5831 A 323 7307 A 324 3731 A 325 6578 A 326 7591 A 327 7355 A 328 7899 A 329 7067 A 330 5007 A 331 817 A 332 1459 A 333 3423 A 334 9999 A 335 1725 A 336 3817 A 337 5885 A 338 802 A 339 1710 A 340 5920 A 341 3698 A 342 8204 A 343 7693 A 344 917 A 345 380 A 346 8889 A 347 1099 A 348 900 A 349 1836 A 350 7210 A 351 4070 A 352 8600 A 353 5709 A 354 136 A 355 6463 A 356 8889 A 357 9742 A 358 3291 A 359 8605 A 360 1450 A 361 1983 A 362 3497 A 363 5429 A 364 2832 A 365 7876 B 1 674 B 2 5504 B 3 4041 B 4 7625 B 5 9339 B 6 9171 B 7 7672 B 8 7939 B 9 574 B 10 4489 B 11 1943 B 12 3840 B 13 5079 B 14 834 B 15 8034 B 16 6924 B 17 6631 B 18 7176 B 19 8775 B 20 721 B 21 3148 B 22 1094 B 23 3131 B 24 1720 B 25 9286 B 26 6815 B 27 3661 B 28 7906 B 29 8855 B 30 3278 B 31 5830 B 32 7611 B 33 4785 B 34 4117 B 35 4884 B 36 467 B 37 6779 B 38 9001 B 39 6236 B 40 5854 B 41 8196 B 42 8982 B 43 4162 B 44 2544 B 45 2120 B 46 9638 B 47 9249 B 48 3072 B 49 2446 B 50 7257 B 51 7377 B 52 7150 B 53 4531 B 54 8984 B 55 4315 B 56 9749 B 57 3374 B 58 2313 B 59 9189 B 60 2141 B 61 889 B 62 6544 B 63 5251 B 64 707 B 65 7046 B 66 1345 B 67 4089 B 68 8990 B 69 4880 B 70 4169 B 71 5230 B 72 9253 B 73 7797 B 74 9138 B 75 6501 B 76 8401 B 77 7105 B 78 1097 B 79 6224 B 80 3798 B 81 5494 B 82 9912 B 83 4228 B 84 5389 B 85 7633 B 86 3950 B 87 9314 B 88 1190 B 89 3134 B 90 9168 B 91 4271 B 92 3444 B 93 8109 B 94 853 B 95 9420 B 96 9759 B 97 6069 B 98 6376 B 99 1725 B 100 6445 B 101 8635 B 102 4416 B 103 2128 B 104 5040 B 105 3252 B 106 6553 B 107 3881 B 108 5204 B 109 9595 B 110 9500 B 111 9830 B 112 5618 B 113 9910 B 114 3288 B 115 762 B 116 1184 B 117 321 B 118 122 B 119 5642 B 120 858 B 121 7110 B 122 9720 B 123 7663 B 124 242 B 125 670 B 126 7877 B 127 4436 B 128 7406 B 129 5673 B 130 2771 B 131 3846 B 132 5183 B 133 817 B 134 2322 B 135 4949 B 136 9830 B 137 9509 B 138 8435 B 139 6035 B 140 9949 B 141 5833 B 142 3912 B 143 9711 B 144 3198 B 145 9837 B 146 6953 B 147 5517 B 148 2825 B 149 876 B 150 4566 B 151 1386 B 152 2059 B 153 8267 B 154 6721 B 155 6317 B 156 4934 B 157 8808 B 158 1610 B 159 6851 B 160 4698 B 161 7255 B 162 1578 B 163 8591 B 164 3163 B 165 9960 B 166 1984 B 167 343 B 168 8113 B 169 9089 B 170 4222 B 171 2559 B 172 9984 B 173 1409 B 174 2987 B 175 6252 B 176 5105 B 177 7359 B 178 1631 B 179 1658 B 180 6938 B 181 8137 B 182 8449 B 183 789 B 184 6566 B 185 8642 B 186 3758 B 187 2943 B 188 3042 B 189 6916 B 190 3232 B 191 2951 B 192 5472 B 193 1390 B 194 5046 B 195 238 B 196 6825 B 197 6908 B 198 6807 B 199 5456 B 200 8509 B 201 7823 B 202 8752 B 203 3627 B 204 6011 B 205 2346 B 206 4211 B 207 547 B 208 2934 B 209 646 B 210 9577 B 211 9144 B 212 2019 B 213 5610 B 214 8313 B 215 6746 B 216 1275 B 217 601 B 218 4423 B 219 596 B 220 9336 B 221 2176 B 222 644 B 223 4569 B 224 8543 B 225 4793 B 226 8685 B 227 4556 B 228 4126 B 229 4252 B 230 3699 B 231 3351 B 232 2195 B 233 4517 B 234 5913 B 235 2137 B 236 8996 B 237 3549 B 238 9736 B 239 3869 B 240 1344 B 241 8976 B 242 5374 B 243 3562 B 244 1714 B 245 4184 B 246 2795 B 247 7744 B 248 5653 B 249 5942 B 250 3635 B 251 4837 B 252 1773 B 253 5745 B 254 6617 B 255 1656 B 256 5954 B 257 8550 B 258 9542 B 259 6617 B 260 4330 B 261 9292 B 262 4884 B 263 8899 B 264 5157 B 265 7403 B 266 5775 B 267 6490 B 268 9803 B 269 6360 B 270 5764 B 271 8390 B 272 2011 B 273 6864 B 274 9453 B 275 1075 B 276 2337 B 277 5192 B 278 5640 B 279 8395 B 280 3224 B 281 1401 B 282 1824 B 283 5556 B 284 4531 B 285 7181 B 286 9834 B 287 9125 B 288 547 B 289 8363 B 290 5982 B 291 8328 B 292 7878 B 293 8954 B 294 1267 B 295 345 B 296 6744 B 297 5402 B 298 764 B 299 6632 B 300 9859 B 301 793 B 302 9362 B 303 3585 B 304 4500 B 305 7921 B 306 4053 B 307 2097 B 308 8099 B 309 9834 B 310 3378 B 311 266 B 312 6095 B 313 5884 B 314 3588 B 315 7659 B 316 2340 B 317 1341 B 318 1397 B 319 138 B 320 2475 B 321 6066 B 322 1432 B 323 7545 B 324 3393 B 325 8182 B 326 8218 B 327 2129 B 328 8015 B 329 8484 B 330 6064 B 331 7303 B 332 526 B 333 6755 B 334 8069 B 335 6932 B 336 124 B 337 7143 B 338 748 B 339 7366 B 340 2571 B 341 2518 B 342 2695 B 343 5110 B 344 3321 B 345 7332 B 346 8432 B 347 1164 B 348 6865 B 349 9757 B 350 7955 B 351 6348 B 352 762 B 353 143 B 354 1511 B 355 514 B 356 810 B 357 6759 B 358 2769 B 359 6971 B 360 7137 B 361 5698 B 362 8144 B 363 1570 B 364 252 B 365 6425 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 71 options validvarname=v7; 72 libname unit3lib xlsx "/home/u43642319/ccerdaiiiphd/Sales_Data_U3_A1.xlsx"; NOTE: Libref UNIT3LIB was successfully assigned as follows: Engine: XLSX Physical Name: /home/u43642319/ccerdaiiiphd/Sales_Data_U3_A1.xlsx 73 74 75 proc sort; ERROR: File WORK.VERSION_1572212903017.DATA does not exist. 76 by Store; 77 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 181.03k OS Memory 30628.00k Timestamp 10/27/2019 11:28:57 PM Step Count 58 Switch Count 0 Page Faults 0 Page Reclaims 26 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 78 79 proc means data=unit3lib.Sales_Data_U3_A1 noprint; 80 var Sales; 81 by Store; 82 output out=newsales; 83 run; NOTE: The import data set has 730 observations and 3 variables. NOTE: The above message was for the following BY group: Store=B NOTE: There were 730 observations read from the data set UNIT3LIB.Sales_Data_U3_A1. NOTE: The data set WORK.NEWSALES has 10 observations and 5 variables. NOTE: PROCEDURE MEANS used (Total process time): real time 0.03 seconds user cpu time 0.03 seconds system cpu time 0.00 seconds memory 3941.03k OS Memory 34732.00k Timestamp 10/27/2019 11:28:57 PM Step Count 59 Switch Count 4 Page Faults 0 Page Reclaims 978 Page Swaps 0 Voluntary Context Switches 24 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264 84 85 proc print data=newsales; 86 run; NOTE: There were 10 observations read from the data set WORK.NEWSALES. NOTE: PROCEDURE PRINT used (Total process time): real time 0.02 seconds user cpu time 0.02 seconds system cpu time 0.00 seconds memory 1843.46k OS Memory 31912.00k Timestamp 10/27/2019 11:28:57 PM Step Count 60 Switch Count 0 Page Faults 0 Page Reclaims 162 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 87 88 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 99
... View more