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 |
|
proc import datafile="/home/u43642319/ccerdaiiiphd/Sales_Data_U3_A1.csv" dbms=csv
out=sales_data_u3_a1_import replace;
run;
proc print data=work.sales_data_u3_a1_import;
var Store Sales;
run;
title 'Analysis of Sales by Store'; ods select BasicIntervals;
proc univariate data=work.sales_data_u3_a1_import cibasic;
var Sales;
by Store;
run;
You use PROC SORT and don't indicate a data set you want to sort.
You need to specify the data set to sort using DATA=.
In general, I recommend ALWAYS having a DATA= on your PROC so it's explicitly clear which dataset you're working with. This will help you avoid errors and bugs later on that are hard to debug.
proc sort; * what data set is being sorted?;
by Store;
run;
@maplesyrup wrote:
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;7071 options validvarname=v7;72 libname unit3lib xlsx "/home/u43642319/ccerdaiiiphd/Sales_Data_U3_A1.xlsx";NOTE: Libref UNIT3LIB was successfully assigned as follows:Engine: XLSXPhysical Name: /home/u43642319/ccerdaiiiphd/Sales_Data_U3_A1.xlsx737475 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 secondsuser cpu time 0.00 secondssystem cpu time 0.00 secondsmemory 181.03kOS Memory 30628.00kTimestamp 10/27/2019 11:28:57 PMStep Count 58 Switch Count 0Page Faults 0Page Reclaims 26Page Swaps 0Voluntary Context Switches 0Involuntary Context Switches 0Block Input Operations 0Block Output Operations 07879 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=BNOTE: 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 secondsuser cpu time 0.03 secondssystem cpu time 0.00 secondsmemory 3941.03kOS Memory 34732.00kTimestamp 10/27/2019 11:28:57 PMStep Count 59 Switch Count 4Page Faults 0Page Reclaims 978Page Swaps 0Voluntary Context Switches 24Involuntary Context Switches 0Block Input Operations 0Block Output Operations 2648485 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 secondsuser cpu time 0.02 secondssystem cpu time 0.00 secondsmemory 1843.46kOS Memory 31912.00kTimestamp 10/27/2019 11:28:57 PMStep Count 60 Switch Count 0Page Faults 0Page Reclaims 162Page Swaps 0Voluntary Context Switches 0Involuntary Context Switches 0Block Input Operations 0Block Output Operations 88788 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;99
You need to change your PROC SORT to add a dataset to sort and also an output dataset which you should then use in following steps:
proc sort data = unit3lib.sales_data_U3_A1
out = sales;
by Store;
run;
proc import datafile="/home/u43642319/ccerdaiiiphd/Sales_Data_U3_A1.csv" dbms=csv
out=sales_data_u3_a1_import replace;
run;
proc print data=work.sales_data_u3_a1_import;
var Store Sales;
run;
title 'Analysis of Sales by Store'; ods select BasicIntervals;
proc univariate data=work.sales_data_u3_a1_import cibasic;
var Sales;
by Store;
run;
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.
Explore Now →SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.