topic Re: import mbd on SAS studio not working in SAS Programming

import mbd on SAS studio not working

tony7zx — Mon, 09 Nov 2015 23:20:53 GMT

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;

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

61 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: import mbd on SAS studio not working

Reeza — Mon, 09 Nov 2015 22:53:48 GMT

Try AccessCS and post the full error message.

Re: import mbd on SAS studio not working

tony7zx — Mon, 09 Nov 2015 23:15:16 GMT

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

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;

61 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: import mbd on SAS studio not working

tony7zx — Mon, 09 Nov 2015 23:17:00 GMT

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

Re: import mbd on SAS studio not working

LinusH — Tue, 10 Nov 2015 08:16:52 GMT

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.

Re: import mbd on SAS studio not working

Reeza — Tue, 10 Nov 2015 16:30:25 GMT

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?

Re: import mbd on SAS studio not working

SASKiwi — Tue, 10 Nov 2015 18:44:02 GMT

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#n08xs35g2w8mt1n1dhiyyd898s6z.htm

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

Re: import mbd on SAS studio not working

Reeza — Tue, 10 Nov 2015 18:46:07 GMT

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