Hi,
So i have Access Database with 2 tables dropped in one of the folders in the share drive by another team.
I need to import the tables in EG SAS(Remote) and i even moved that db in my unix folders.
When trying to import the tables using the proc import wizard i get the attached message
and when running the libname code from below i get the following error:
LIBNAME mylib pcfiles PATH="xxx/External/yy/xx.accdb";
ERROR: The SERVER= option is required for establishing a connection through the SAS/ACCESS Interface to PC Files.
What Server option they talking about if i have it all in UNIX?
Anyone please
PS. i have office 2010 so it has to be that system driver thing whatever that means
Try it without PCFILES in the libname statement.
without pcfiles:
LIBNAME mylib path="&ROOTNAME/External/CP_Data/CPData_LOC_&CP_DATE1..accdb";
ERROR: Libname MYLIB is not assigned.
ERROR: Error in the LIBNAME statement.
or:
LIBNAME mylib "&ROOTNAME/External/CP_Data/CPData_LOC_&CP_DATE1..accdb";
ERROR: Library MYLIB is not in a valid format for access method RANDOM.
ERROR: Error in the LIBNAME statement.
tried proc import:
PROC IMPORT OUT= SLOCCov DATATABLE= "SLOCCov" DBMS=ACCESS REPLACE;
DATABASE="&ROOTNAME/External/CP_Data/CPData_LOC_&CP_DATE1..accdb";
SCANMEMO=YES;
USEDATE=NO;
SCANTIME=YES;
RUN;
ERROR: DBMS type ACCESS not valid for import.
If you can post a sample accdb I am reasonably positive I can convert the tables to SAS datasets. Do not need MS acess and can handle 32 and 64bit, all can be done with the IML interface to R.
You can test your code using
SAS provides sample accdb
C:\Program Files\sashome\SASFoundation\9.4\access\sasmisc
demo.accdb
but my access data is in unix already. I transferred the access database to my UNIX SAS folders
Will i still need the pc file server?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.