1 libname b "D:\DATA";
NOTE: Libref B was successfully assigned as follows:
Engine: V9
Physical Name: D:\DATA
2 run;
3 proc sort data= b.ex;
4 by id;
NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
real time 3.81 sec
cpu time 0.78 sec
5 proc sql;
6 create table work.md as
7 select
8 drug,
9 expenses,
10 input (count,best.) as count
11 from b.ex;
ERROR: The following columns were not found in the contributing tables: count.
12 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.16 sec
cpu time 0.01 sec
... View more
