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.
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.
Execute
proc setinit; run;
to verify that PC Files is part of your licence.
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.
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.
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.
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.
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.