DATA Step, Macro, Functions and more

SAS/ACCESS Interface to PC Files error

Reply
Occasional Contributor
Posts: 6

SAS/ACCESS Interface to PC Files error

I am getting the following error while running proc import command in SAS 9.4

 

"The SAS/ACCESS Interface to PC Files is not installed. Please install this module in order to

IMPORT/EXPORT to these file types."

 

I have SAS and Windows(64-bit) and Microsoft office(32-bit), so I installed SAS PC Files Server(32-bit). But still while running proc import syntax, I am getting the same error.

 

Please help me resolve this.

 

 

 

Super User
Posts: 5,441

Re: SAS/ACCESS Interface to PC Files error

Posted in reply to bhavya123
Please share the log including the import step.
Have you followed the syntax for using a PC Files Server?
Data never sleeps
Occasional Contributor
Posts: 6

Re: SAS/ACCESS Interface to PC Files error

I used proc import syntax below:

 

PROC IMPORT DATAFILE="C:\Users\Desktop\split.xlsx"

DBMS=EXCELCS

OUT=WORK.SASINVOICES REPLACE;

SHEET='Sheet1';

RUN;

please let me know if I have used the correct syntax.

Super Contributor
Posts: 345

Re: SAS/ACCESS Interface to PC Files error

Posted in reply to bhavya123

Execute

proc setinit; run;

to verify that PC Files is part  of your licence.

 

Occasional Contributor
Posts: 6

Re: SAS/ACCESS Interface to PC Files error

Posted in reply to andreas_lds
Yes I checked. PC File server is part of my SAS licence
Super User
Posts: 7,866

Re: SAS/ACCESS Interface to PC Files error

Posted in reply to bhavya123

You need to install SAS/ACCESS for PC Files, the log is very clear about that. The PC Files Server is something different.

Use the Deployment Manager to install the module; if you can't find it in your SAS depot, get in contact with your local SAS representative so you get a software order that matches your license.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 7,866

Re: SAS/ACCESS Interface to PC Files error

Posted in reply to bhavya123

BTW if you don't have the module licensed, save your Excel data as csv and import that. No additional license needed for text files.

It's the better method anyway.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 6

Re: SAS/ACCESS Interface to PC Files error

Posted in reply to KurtBremser
I have already installed PC file server. But even after the install, the
syntax wasn't working. I checked in the "services" folder also, it was
running.

I guess CSV would work.
Super User
Posts: 7,866

Re: SAS/ACCESS Interface to PC Files error

Posted in reply to bhavya123

The PC Files Server is NOT, I repeat NOT, SAS/ACCESS to PC Files.

The first is a special server program for Windows machines that allows non-Windows SAS computers access to the older MS Office formats. The second is a part of the Base SAS package and can be installed on all SAS-supported platforms.

 

You are missing the SAS/ACCESS to PC Files module, so you need to install/license it.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 6

Re: SAS/ACCESS Interface to PC Files error

Posted in reply to KurtBremser
@KurtBremser
Thanks for the explanation. Just a reference to what I stated above:

When I ran "proc setinit; run;", I got this in log:
---SAS/ACCESS Interface to PC Files
14MAY2018
Even then this implies that I don't have SAS/ACCESS to PC Files installed?
Super User
Posts: 7,866

Re: SAS/ACCESS Interface to PC Files error

Posted in reply to bhavya123

For a module to function, 2 facts are necessary:

- the software has to be installed

- the module has to be licensed

 

As it looks, you are lacking prerequisite #1. Run the Deployment Manager to check if you can install the software.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Respected Advisor
Posts: 4,173

Re: SAS/ACCESS Interface to PC Files error

[ Edited ]
Posted in reply to bhavya123

@bhavya123

And you also did restart all your SAS services/servers after the install?

 

The SAS log is very clear: The SAS/ACCESS Interface to PC Files is not installed.

 

 

Proc Setinit will show you what license file got applied.

 

Execute also Proc Product_Status which will show you what SAS recognizes as being installed.

proc product_status;
run;

 You need to then get in the log something like below:

For SAS/ACCESS Interface to PC Files ...
   Custom version information: 9.4_M3

 

Occasional Contributor
Posts: 6

Re: SAS/ACCESS Interface to PC Files error

Thanks. I understood your point.
Product_status syntax doesn't show me "SAS/ACCESS Interface...." log
Ask a Question
Discussion stats
  • 12 replies
  • 179 views
  • 0 likes
  • 5 in conversation