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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.