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

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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

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.


Accepted Solutions
Solution
4 weeks ago
Esteemed Advisor
Esteemed Advisor
Posts: 7,256

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

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.

View solution in original post


All Replies
Solution
4 weeks ago
Esteemed Advisor
Esteemed Advisor
Posts: 7,256

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

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.

New Contributor
Posts: 2

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

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 Smiley Happy.

Esteemed Advisor
Esteemed Advisor
Posts: 7,256

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

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.

Esteemed Advisor
Esteemed Advisor
Posts: 7,256

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

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 101 views
  • 1 like
  • 2 in conversation