options validvarname=any;
libname apple 'C:\Users\liaodong\Documents\My SAS Files\Wages.xls';
proc means data = apple.'Permanent$'n mean;
var wage;
run;
message in log:
39 options validvarname=any; 40 libname apple xlsx 'C:\Users\liaodong\Documents\My SAS Files\Wages.xls'; ERROR: Invalid physical name for library APPLE. ERROR: Error in the LIBNAME statement. 41 proc means data = apple.'Permanent$'n mean; ERROR: Libref APPLE is not assigned. 42 var wage; ERROR: No data set open to look up variables. 43 run;
NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE MEANS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
... View more