why it does not work (the xls file is 32 bit , the SAS is 64 bit version , have install PC files

[tianerhu]

libname apple    'C:\Users\Documents\Sales.xls';

proc print  data = apple.Sales;
   where EmpID = '9888' or EmpID = '0177';

run;

[ghosh]

libname apple excel   'C:\Users\Documents\Sales.xls';

[tianerhu]

thank you ,  but  it doesn't work

[ghosh]

what is the error message?

Can you try with an xlsx file format?

libname apple XLSX   'C:\Users\Documents\Sales.xlsx';

[tianerhu]

thank you , but it doesn't work

[Kurt_Bremser]

As I wrote in the other thread, run proc setinit and proc productstatus to verify that ACCESS to PC Files is licensed and installed.

[ballardw]

---

@tianerhu wrote:

thank you ,  but  it doesn't work

---

Doesn't work is awful vague.

Are there errors in the log?: Post the code and log in a code box opened with the {i} to maintain formatting of error messages.

No output? Post any log in a code box.

Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

[tianerhu]

thank you for your help , i will reply the next week , i have to prepare the midterm

[ed_sas_member]

Hi @tianerhu 

In case you don't have the license mentioned by @Kurt_Bremser , an alternative could be the use of PROC IMPORT:

proc import datafile='C:\Users\Documents\Sales.xls'
		    out=work.Sales /* 'work' or any other library*/
			dbms=xls
			replace;
run;

proc print data = work.Sales; /* 'work' or any other library*/
   where EmpID = '9888' or EmpID = '0177';
run;

[Kurt_Bremser]

All uses of the excel/xls/xlsx/excelcs engines require that ACCESS to PC Files is licensed and installed.

[tianerhu]

Thank you so much .