DATA Step, Macro, Functions and more

import mbd on SAS studio not working

Reply
Occasional Contributor
Posts: 5

import mbd on SAS studio not working

[ Edited ]

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
Super User
Posts: 19,792

Re: import mbd on SAS studio not working

Try AccessCS and post the full error message.
Occasional Contributor
Posts: 5

Re: import mbd on SAS studio not working

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
Occasional Contributor
Posts: 5

Re: import mbd on SAS studio not working

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
Super User
Posts: 5,429

Re: import mbd on SAS studio not working

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.

Data never sleeps
Super User
Posts: 19,792

Re: import mbd on SAS studio not working

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?
Super User
Posts: 3,254

Re: import mbd on SAS studio not working

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;

Super User
Posts: 19,792

Re: import mbd on SAS studio not working

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
Ask a Question
Discussion stats
  • 7 replies
  • 289 views
  • 0 likes
  • 4 in conversation