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

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

chinaski — Mon, 03 Jul 2017 11:04:06 GMT

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.

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

RW9 — Mon, 03 Jul 2017 11:12:40 GMT

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-university-edition/

Using proc import.

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

chinaski — Mon, 03 Jul 2017 11:33:03 GMT

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 :).

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

RW9 — Mon, 03 Jul 2017 11:37:11 GMT

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.

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

RW9 — Mon, 03 Jul 2017 11:37:13 GMT

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.