BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
maplesyrup
Calcite | Level 5

 

 

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

StoreDay_of_yearSales
A13973
A22957
A3402
A49761
A56244
A62001
A77880
A87460
A9861
A103681
A113219
A123895
A133054
A147676
A157182
A163411
A172336
A186126
A196853
A20649
A211164
A227253
A236437
A24953
A258049
A264790
A275467
A287563
A29342
A306203
A318555
A325116
A334922
A349653
A356909
A364607
A374821
A382844
A393472
A401295
A417614
A428463
A432935
A442309
A45802
A469307
A476211
A488100
A498745
A501160
A511321
A521334
A53489
A54373
A558429
A561821
A573195
A587266
A594319
A609391
A618350
A622835
A632567
A647131
A658586
A661528
A676466
A688063
A692022
A709644
A711253
A723934
A737845
A749255
A755540
A766763
A774391
A783292
A794428
A807298
A818410
A823862
A835905
A846403
A855986
A868726
A872682
A888440
A897689
A902666
A919885
A925333
A931708
A944435
A959614
A967794
A97787
A985272
A995255
A1009757
A1017233
A1028580
A1037079
A1042348
A1059034
A1065004
A107512
A1081213
A1098122
A1105388
A1116252
A1129273
A1136179
A1141984
A1151117
A1164620
A1179610
A1182190
A1192048
A1208593
A1217885
A1225266
A1238269
A1249937
A1257688
A1263843
A127118
A1284095
A1294536
A1308522
A1317359
A1326774
A1332141
A1346755
A1357796
A1365074
A1372524
A1388229
A1395489
A140208
A1418995
A1427363
A1434669
A1442991
A1459588
A1462555
A1474643
A1489927
A1495384
A1504413
A1515524
A152563
A153584
A1546850
A1557411
A1563708
A157747
A1588035
A1591107
A1608005
A1618057
A1625511
A1633230
A164429
A1653001
A1661879
A167703
A1684087
A1698583
A1704751
A1714807
A1724816
A1734871
A1741356
A1753951
A1766964
A1771769
A1785809
A1796011
A1809943
A1818521
A1821190
A1837894
A1845877
A1857143
A1867198
A1873283
A1888292
A189683
A1906980
A1914385
A1927535
A1931280
A1946326
A1955342
A1963887
A1979180
A1982483
A1994366
A2006848
A2016228
A2022698
A2033590
A2047656
A2056554
A2068361
A2071796
A2089980
A2094994
A2109377
A2118011
A212223
A2137847
A214771
A2154398
A2162183
A2172544
A2181531
A2191842
A2209559
A2212219
A2221401
A2233108
A2246429
A2252171
A2262165
A2272277
A2289201
A2292671
A2304603
A2312558
A2326797
A2334359
A2341733
A2359565
A2361259
A2377167
A2381637
A2398144
A2403147
A2418837
A242460
A2437664
A2449253
A2457321
A2461252
A2479092
A2487549
A2492176
A2506435
A2515094
A2524420
A2535933
A2549239
A255197
A2561438
A2575774
A2585182
A259313
A2607309
A2611567
A2621331
A2639458
A2649492
A2654668
A2665294
A2672041
A2687421
A2698628
A2703648
A2713573
A2726294
A2734699
A2745900
A2752597
A2767461
A2776518
A2786020
A2791481
A280890
A2818158
A2827117
A2834079
A284429
A2855879
A2866159
A2872540
A2884684
A2891489
A2908690
A2917173
A2928168
A2934954
A2948493
A2957417
A296448
A2977931
A298265
A299379
A3003881
A3013364
A3025043
A3036312
A304595
A3052745
A3062206
A3072995
A308908
A3092991
A3109383
A3117605
A3129380
A3131292
A3142274
A3152977
A3165003
A3178090
A318862
A3193713
A3205695
A321636
A3225831
A3237307
A3243731
A3256578
A3267591
A3277355
A3287899
A3297067
A3305007
A331817
A3321459
A3333423
A3349999
A3351725
A3363817
A3375885
A338802
A3391710
A3405920
A3413698
A3428204
A3437693
A344917
A345380
A3468889
A3471099
A348900
A3491836
A3507210
A3514070
A3528600
A3535709
A354136
A3556463
A3568889
A3579742
A3583291
A3598605
A3601450
A3611983
A3623497
A3635429
A3642832
A3657876
B1674
B25504
B34041
B47625
B59339
B69171
B77672
B87939
B9574
B104489
B111943
B123840
B135079
B14834
B158034
B166924
B176631
B187176
B198775
B20721
B213148
B221094
B233131
B241720
B259286
B266815
B273661
B287906
B298855
B303278
B315830
B327611
B334785
B344117
B354884
B36467
B376779
B389001
B396236
B405854
B418196
B428982
B434162
B442544
B452120
B469638
B479249
B483072
B492446
B507257
B517377
B527150
B534531
B548984
B554315
B569749
B573374
B582313
B599189
B602141
B61889
B626544
B635251
B64707
B657046
B661345
B674089
B688990
B694880
B704169
B715230
B729253
B737797
B749138
B756501
B768401
B777105
B781097
B796224
B803798
B815494
B829912
B834228
B845389
B857633
B863950
B879314
B881190
B893134
B909168
B914271
B923444
B938109
B94853
B959420
B969759
B976069
B986376
B991725
B1006445
B1018635
B1024416
B1032128
B1045040
B1053252
B1066553
B1073881
B1085204
B1099595
B1109500
B1119830
B1125618
B1139910
B1143288
B115762
B1161184
B117321
B118122
B1195642
B120858
B1217110
B1229720
B1237663
B124242
B125670
B1267877
B1274436
B1287406
B1295673
B1302771
B1313846
B1325183
B133817
B1342322
B1354949
B1369830
B1379509
B1388435
B1396035
B1409949
B1415833
B1423912
B1439711
B1443198
B1459837
B1466953
B1475517
B1482825
B149876
B1504566
B1511386
B1522059
B1538267
B1546721
B1556317
B1564934
B1578808
B1581610
B1596851
B1604698
B1617255
B1621578
B1638591
B1643163
B1659960
B1661984
B167343
B1688113
B1699089
B1704222
B1712559
B1729984
B1731409
B1742987
B1756252
B1765105
B1777359
B1781631
B1791658
B1806938
B1818137
B1828449
B183789
B1846566
B1858642
B1863758
B1872943
B1883042
B1896916
B1903232
B1912951
B1925472
B1931390
B1945046
B195238
B1966825
B1976908
B1986807
B1995456
B2008509
B2017823
B2028752
B2033627
B2046011
B2052346
B2064211
B207547
B2082934
B209646
B2109577
B2119144
B2122019
B2135610
B2148313
B2156746
B2161275
B217601
B2184423
B219596
B2209336
B2212176
B222644
B2234569
B2248543
B2254793
B2268685
B2274556
B2284126
B2294252
B2303699
B2313351
B2322195
B2334517
B2345913
B2352137
B2368996
B2373549
B2389736
B2393869
B2401344
B2418976
B2425374
B2433562
B2441714
B2454184
B2462795
B2477744
B2485653
B2495942
B2503635
B2514837
B2521773
B2535745
B2546617
B2551656
B2565954
B2578550
B2589542
B2596617
B2604330
B2619292
B2624884
B2638899
B2645157
B2657403
B2665775
B2676490
B2689803
B2696360
B2705764
B2718390
B2722011
B2736864
B2749453
B2751075
B2762337
B2775192
B2785640
B2798395
B2803224
B2811401
B2821824
B2835556
B2844531
B2857181
B2869834
B2879125
B288547
B2898363
B2905982
B2918328
B2927878
B2938954
B2941267
B295345
B2966744
B2975402
B298764
B2996632
B3009859
B301793
B3029362
B3033585
B3044500
B3057921
B3064053
B3072097
B3088099
B3099834
B3103378
B311266
B3126095
B3135884
B3143588
B3157659
B3162340
B3171341
B3181397
B319138
B3202475
B3216066
B3221432
B3237545
B3243393
B3258182
B3268218
B3272129
B3288015
B3298484
B3306064
B3317303
B332526
B3336755
B3348069
B3356932
B336124
B3377143
B338748
B3397366
B3402571
B3412518
B3422695
B3435110
B3443321
B3457332
B3468432
B3471164
B3486865
B3499757
B3507955
B3516348
B352762
B353143
B3541511
B355514
B356810
B3576759
B3582769
B3596971
B3607137
B3615698
B3628144
B3631570
B364252
B365

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
 

 

1 ACCEPTED SOLUTION

Accepted Solutions
maplesyrup
Calcite | Level 5

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;

View solution in original post

4 REPLIES 4
Reeza
Super User

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;
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
 

 


 

SASKiwi
PROC Star

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;
maplesyrup
Calcite | Level 5

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;

Reeza
Super User
That’s not the correct solution and you really shouldn’t mark your own answer as correct.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Mastering the WHERE Clause in PROC SQL

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.

Discussion stats
  • 4 replies
  • 633 views
  • 0 likes
  • 3 in conversation