import mbd on SAS studio not working

[tony7zx]

I use these code

libname CARS515 "/folders/myfolders/HW1/CARS515";
proc import out=CARS515.CARS_DET datatable='CARS_DET' dbms=access replace;

database='/folders/myfolders/Cars_Det.mdb';
run;

the error is dbms= access is not working.

After I change access to accessCS

the error is

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

55

56 proc import datatable='CARS_DET'

57 out=CARS515.CARS_DET dbms=accessCS replace;

58 database='/folders/myfolders/Cars_Det.mdb';

59 run;

ERROR: Server Name is invalid or missing.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

60

61 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73

[Reeza]

Try AccessCS and post the full error message.

[tony7zx]

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

55

56 proc import datatable='CARS_DET'

57 out=CARS515.CARS_DET dbms=access replace;

ERROR: DBMS type ACCESS not valid for import.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.01 seconds

cpu time 0.00 seconds

58 database='/folders/myfolders/Cars_Det.mdb';

59 run;

60

61 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73

[tony7zx]

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
55
56 proc import datatable='CARS_DET'
57 out=CARS515.CARS_DET dbms=accessCS replace;
58 database='/folders/myfolders/Cars_Det.mdb';
59 run;

ERROR: Server Name is invalid or missing.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

[LinusH]

The ACCESSCS requires a PC Files Server to function.

Are you running SAS on UNIX/Linux? The a PC Files Server is requires as I recall it.

[Reeza]

You're using SAS UE? I'm going back on my original suggestion, I think it should be ACCESS only. Can you please post the log from that attempt?

[SASKiwi]

I agree with Linus. SAS 9.4 needs the SAS PC File Server using ACCESSCS to work on Unix. Please confirm your SAS server is running on Unix/Linux. The operating system is shown at the top of your SAS log when you first start SAS.

This link is useful:

http://support.sas.com/documentation/cdl/en/acpcref/67382/HTML/default/viewer.htm#n08xs35g2w8mt1n1dh...

Also please confirm that SAS/ACCESS to PC Files is licensed: proc setinit noalias; run;

[Reeza]

Just a note that Access files are not mentioned in the fact sheet for UE so you may not be able to import access files using SAS UE.

https://www.sas.com/content/dam/SAS/en_us/doc/factsheet/sas-university-edition-107140.pdf