10-14-2017 07:06 AM
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.
10-14-2017 11:24 PM
I used proc import syntax below:
PROC IMPORT DATAFILE="C:\Users\Desktop\split.xlsx"
please let me know if I have used the correct syntax.
10-15-2017 01:50 AM
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.
10-15-2017 01:53 AM
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.
10-15-2017 04:00 AM
10-15-2017 05:18 AM
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.
10-15-2017 07:01 AM
10-15-2017 01:58 PM
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.
10-15-2017 05:22 AM - edited 10-15-2017 05:23 AM
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