1 The SAS System 17:05 Wednesday, September 19, 2018
1 %_eg_hidenotesandsource;
5 %_eg_hidenotesandsource;
28
29 proc means data=WORK.SALES;
30 class country;
31 var salary;
32 output out=subtotal sum=salary;
33 run;
NOTE: There were 165 observations read from the data set WORK.SALES.
NOTE: The data set WORK.SUBTOTAL has 3 observations and 4 variables.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.16 seconds
cpu time 0.04 seconds
34
35 data want;
36 set WORK.SALES (in=a) salary (in=b);
ERROR: File WORK.SALARY.DATA does not exist.
37 if b then country=cat(strip(country)," Total");
38 run;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.WANT may be incomplete. When this step was stopped there were 0 observations and 9 variables.
WARNING: Data set WORK.WANT was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
39
40 proc sort data=want;
41 by country employee;
ERROR: Variable EMPLOYEE not found.
42 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
43
44 %_eg_hidenotesandsource;
56
57
58 %_eg_hidenotesandsource;
61 Hi RW9, I did, kindly refer to screenshot below.
... View more