topic Re: why it does not work (the xls file is 32 bit , the SAS is 64 bit version , have install PC file in SAS Procedures

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

tianerhu — Mon, 02 Mar 2020 02:19:31 GMT

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

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

run;

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

ghosh — Mon, 02 Mar 2020 02:32:04 GMT

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

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

tianerhu — Mon, 02 Mar 2020 02:38:02 GMT

thank you , but it doesn't work

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

ghosh — Mon, 02 Mar 2020 03:51:38 GMT

what is the error message?

Can you try with an xlsx file format?

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

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

tianerhu — Mon, 02 Mar 2020 04:14:04 GMT

thank you , but it doesn't work

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

Kurt_Bremser — Mon, 02 Mar 2020 06:49:03 GMT

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

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

ed_sas_member — Mon, 02 Mar 2020 08:42:47 GMT

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;

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

Kurt_Bremser — Mon, 02 Mar 2020 10:09:39 GMT

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

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

ballardw — Mon, 02 Mar 2020 17:09:17 GMT

@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.

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

tianerhu — Fri, 06 Mar 2020 15:54:51 GMT

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

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

tianerhu — Fri, 06 Mar 2020 15:55:27 GMT

Thank you so much .