Hello all the members, I hope you are very well.
I run the following program
</
title "Statistics from Sales Spreadsheet"; libname Read '/folders/myfolders/Dataset/Wages.xls'; proc means data=Read.'Permanent$' n mean; var Wage Hours_Worked; run;
/>
and here is the errors in the log:
</
OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 *6-3*;
74 title "Statistics from Sales Spreadsheet";
75 libname Read '/folders/myfolders/Dataset/Wages.xls';
ERROR: Library READ is not in a valid format for access method RANDOM.
ERROR: Error in the LIBNAME statement.
76 /* proc means data='/folders/myfolders/Dataset/Wages'.'Permanent$'n mean; */
77 proc means data=Read.'Permanent$' n mean;
____________
22
200
ERROR: Invalid data set name Read..
ERROR 22-322: Syntax error, expecting one of the following: ;, (, ALPHA, CHARTYPE, CLASSDATA, CLM, COMPLETETYPES, CSS, CV, DATA,
DESCEND, DESCENDING, DESCENDTYPES, EXCLNPWGT, EXCLNPWGTS, EXCLUSIVE, FW, IDMIN, INCAS, KURTOSIS, LCLM, MAX, MAXDEC,
MEAN, MEDIAN, MIN, MISSING, MODE, N, NDEC, NMISS, NOLABELS, NONOBS, NOPRINT, NOTHREADS, NOTRAP, NWAY, ORDER, P1, P10,
P20, P25, P30, P40, P5, P50, P60, P70, P75, P80, P90, P95, P99, PCTLDEF, PRINT, PRINTALL, PRINTALLTYPES, PRINTIDS,
PRINTIDVARS, PROBT, Q1, Q3, QMARKERS, QMETHOD, QNTLDEF, QRANGE, RANGE, SKEWNESS, STACKODS, STACKODSOUTPUT, STDDEV,
STDERR, SUM, SUMSIZE, SUMWGT, T, THREADS, UCLM, USS, VAR, VARDEF.
ERROR 200-322: The symbol is not recognized and will be ignored.
78 var Wage Hours_Worked;
ERROR: No data set open to look up variables.
ERROR: No data set open to look up variables.
79 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.10 seconds
cpu time 0.00 seconds
80
81 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
93
/>
Thank you very much,
Deeply appreciated.
I am looking forward to your answers.
... View more
