Is it possible to use SAS/ACCESS Interface to PC Files engine in Sas University Edition

[chinaski]

Is it possible to use  SAS/ACCESS Interface to PC Files engine in Sas University Edition, i am using the code "libname orionx pcfiles path="&path/sales.xls";"  but i get error massages, if it is not possible, how can i get excel files to use as data set.

[RW9 · Accepted solution]

You are bit confused there.  Your file extension states .xls, which is an old Office binary file.  You cannot libname to it.  Move the file to a newer format such as XLSX (save as from Excel).

This post will help you import Excel data files:

http://blogs.sas.com/content/sastraining/2014/06/26/how-to-read-excel-spreadsheets-with-sas-universi...

Using proc import.

[chinaski]

Thank you for the quick reply, i have just noticed the information "Some SAS installations, including SAS University Edition, do not have the SAS/ACCESS Interface to PC Files engine that is necessary to assign a LIBNAME statement to an Excel file. ", so the only way is to use "proc import" i suppose. I get right on your link for further information, thanks again :).

[RW9]

Yes, SAS/Access is an additional component, so likely not to be in UE.  You can run:

proc setininit;

run;

To see what components you have.

[RW9]

Yes, SAS/Access is an additional component, so likely not to be in UE.  You can run:

proc setininit;

run;

To see what components you have.