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:
</
/>
Thank you very much,
Deeply appreciated.
I am looking forward to your answers.
Open file Wages.xls with excel and save it , if possible, as an xlsx type,
then change the code to read the Wages.xlsx file and try.
Otherwise you need to assign FILENAME the the Wages.xls file with "excel" engine,
import it and only afterwards you can rub proc means on the sas dataset.
There is no libname engine to read XLS format files. There is one for XLSX files. But even then you should get in the habit of telling the libname statement what engine to use when you don't want to use the normal base SAS engine, instead of forcing it to guess.
libname read xlsx '/folders/myfolders/Dataset/Wages.xlsx';
If you are forced to use the XLS file then you will need to use PROC IMPORT to get the data converted into a SAS dataset.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.