What do you mean by "select"?
Is the file actually using the ancient XLS file format? Or is a the modern open standard XLSX file format?
What is the version of SAS you using?
What is the operating system where SAS is running?
If the file is using XLS then you could try using PROC IMPORT. Do you know the names of the sheets in the file? If you don't tell PROC IMPORT which sheet to use it will just use the first one.
proc import file='./dir/myfile.xlsx' out=from_xls replace dbms=xls ;
run;
Now that you have the data in a dataset you can use it for anything you want. For example if you just want to display it there is no need to use PROC SQL. Just use PROC PRINT.
proc print data=from_xls;
run;
If the file is using XLSX format you can make a libref that points at the file and then access each of the sheets as if they where datasets.
libname myfile xlsx './dir/myfile.xlsx';
If you don't know the names of the sheets in the file you could try just copying all of them into the WORK library and then you will see the names in the SAS log.
proc copy inlib=myfile outlib=work;
run;
... View more
