I have MS ACCESS file with .accdb extension. It has three tables. I am trying to read one of the tables but getting error while reading it. I tried import wizard in enterprise guide. It’s working perfectly.
When I am trying to use proc import or tried reading using libname statement I am getting error.
My file is in UNIX server.
PROC IMPORT OUT= WORK.abc1
DATATABLE= "temp"
DBMS=ACCESSCS REPLACE;
DATABASE="/users/ind/user1/temptable.accdb";
server="abd.sas";
port= 22;
SCANMEMO=YES;
USEDATE=NO;
SCANTIME=YES;
run;
ERROR: A socket routine returned error: An unexpected error has occurred. Error number is 0.
ERROR: Failed to connect to the Server:
Hi mate,
Check Connection is refused and socket errors occur when you are using the SAS® PC Files Server and
Error Allocating CLI Environment and Socket Errors when using the PC File Server.
One question only
Does your company uses firewalls or stuff like that ?
In this case, the system administrator must make a port available for the SAS PC Files Server.
This might help
Thanks.
My SAS server is grid server. I came to know that I can not import the access db ditectly to SAS GRID server. I am able import it in PC/BASE SAS using proc import and libname statement.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.